MOD: Senior Officials' Business Expenses, Hospitality And Meetings, January To December 2017

CREATE TABLE mod_permanent_secretaries_business_meetings_april_to_june_2017 (
  "name_permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE mod_permanent_secretaries_business_meetings_january_to_1310de47 (
  "name_permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE mod_permanent_secretaries_business_meetings_july_to_se_b12f2cd3 (
  "name_permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE mod_permanent_secretaries_business_meetings_october_to_e7a8954c (
  "name_permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE mod_senior_officials_business_expenses_hospitality_and_52029818 (
  "employee_name" VARCHAR,
  "substantive_rank" VARCHAR,
  "date_expense_incurred" TIMESTAMP,
  "expense_type" VARCHAR,
  "line_item_description" VARCHAR,
  "line_amount" DOUBLE,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR
);

CREATE TABLE mod_s_senior_officials_hospitality_2_star_and_above_ap_6505c525 (
  "senior_official_scs2_and_above" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE mod_s_senior_officials_hospitality_2_star_and_above_ju_e7889835 (
  "senior_official_scs2_and_above" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE mod_s_senior_officials_hospitality_2_star_and_above_oc_9c873782 (
  "senior_official_scs2_and_above" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE mod_s_senior_officials_travel_2_star_and_above_april_t_6eb05e74 (
  "name" VARCHAR,
  "duty_type" VARCHAR,
  "claim_type_group" VARCHAR,
  "claim_type" VARCHAR,
  "amount" DOUBLE,
  "duty_start_date" VARCHAR,
  "duty_end_date" VARCHAR
);

CREATE TABLE mod_s_senior_officials_travel_2_star_and_above_april_t_fc67e6d7 (
  "traveller_name" VARCHAR,
  "document_type" VARCHAR,
  "first_segment_depart_date" TIMESTAMP,
  "trip_duration_days" DOUBLE,
  "room_nights" DOUBLE,
  "arrival_airport" VARCHAR,
  "hotel_city" VARCHAR,
  "class_of_service" VARCHAR,
  "base_sales" DOUBLE,
  "reason_code_description" VARCHAR,
  "account_name" VARCHAR,
  "unnamed_11" VARCHAR
);

CREATE TABLE mod_s_senior_officials_travel_2_star_and_above_july_to_a5ca3cb4 (
  "employee_name" VARCHAR,
  "substantive_rank" VARCHAR,
  "date_expense_incurred" TIMESTAMP,
  "expense_type" VARCHAR,
  "line_item_description" VARCHAR,
  "expense_line_amount" DOUBLE
);

CREATE TABLE mod_s_senior_officials_travel_2_star_and_above_july_to_eb593da4 (
  "traveller_name" VARCHAR,
  "product_type" VARCHAR,
  "document_type" VARCHAR,
  "first_segment_depart_date" TIMESTAMP,
  "trip_duration_days" DOUBLE,
  "room_nights" DOUBLE,
  "arrival_airport" VARCHAR,
  "hotel_city" VARCHAR,
  "class_of_service" VARCHAR,
  "base_sales" DOUBLE,
  "reason_code_description" VARCHAR,
  "account_name" VARCHAR
);

CREATE TABLE mod_s_senior_officials_travel_2_star_and_above_july_to_eceb24c5 (
  "name" VARCHAR,
  "duty_type" VARCHAR,
  "claim_type_group" VARCHAR,
  "claim_type" VARCHAR,
  "amount" DOUBLE,
  "duty_start_date" VARCHAR,
  "duty_end_date" VARCHAR
);

CREATE TABLE mod_s_senior_officials_travel_2_star_and_above_october_27869e96 (
  "name" VARCHAR,
  "duty_type" VARCHAR,
  "claim_type_group" VARCHAR,
  "claim_type" VARCHAR,
  "amount" DOUBLE,
  "duty_start_date" VARCHAR,
  "duty_end_date" VARCHAR
);

CREATE TABLE mod_s_senior_officials_travel_2_star_and_above_october_3c7f9475 (
  "employee_name" VARCHAR,
  "substantive_rank" VARCHAR,
  "date_expense_incurred" TIMESTAMP,
  "expense_type" VARCHAR,
  "line_item_description" VARCHAR,
  "expense_line_amount" DOUBLE,
  "unnamed_6" VARCHAR
);

CREATE TABLE mod_s_senior_officials_travel_2_star_and_above_october_a190cfe8 (
  "traveller_name" VARCHAR,
  "document_type" VARCHAR,
  "first_segment_depart_date" TIMESTAMP,
  "trip_duration_days" DOUBLE,
  "room_nights" DOUBLE,
  "arrival_airport" VARCHAR,
  "hotel_city" VARCHAR,
  "class_of_service" VARCHAR,
  "base_sales" DOUBLE,
  "reason_code_description" VARCHAR,
  "account_name" VARCHAR,
  "unnamed_11" VARCHAR
);