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  -- Name (Permanent Secretary Only),
  "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  -- Name (Permanent Secretary Only),
  "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  -- Name (Permanent Secretary Only),
  "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  -- Name (Permanent Secretary Only),
  "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: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43
);

CREATE TABLE mod_s_senior_officials_hospitality_2_star_and_above_ap_6505c525 (
  "senior_official_scs2_and_above" VARCHAR  -- Senior Official (SCS2 And Above),
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE mod_s_senior_officials_hospitality_2_star_and_above_ju_e7889835 (
  "senior_official_scs2_and_above" VARCHAR  -- Senior Official (SCS2 And Above),
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE mod_s_senior_officials_hospitality_2_star_and_above_oc_9c873782 (
  "senior_official_scs2_and_above" VARCHAR  -- Senior Official (SCS2 And Above),
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

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  -- Trip Duration (days),
  "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  -- Unnamed: 11
);

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  -- Trip Duration (days),
  "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  -- Unnamed: 6
);

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  -- Trip Duration (days),
  "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  -- Unnamed: 11
);