Non-consolidated Performance Related Payments For The FCO And FCO Services

CREATE TABLE fco_non_consolidated_performance_related_pay_2017_18 (
  "main_department" VARCHAR,
  "organisation" VARCHAR,
  "delegated_grades" VARCHAR,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "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,
  "scs_on_standard_contracts" VARCHAR,
  "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,
  "information_for_scs_on_non_standard_terms" VARCHAR,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "comments" VARCHAR
);

CREATE TABLE non_consolidated_performance_related_pay_2018_19 (
  "main_department" VARCHAR,
  "organisation" VARCHAR,
  "delegated_grades" VARCHAR,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "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,
  "scs_on_standard_contracts" VARCHAR,
  "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,
  "information_for_scs_on_non_standard_terms" VARCHAR,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "comments" VARCHAR
);

CREATE TABLE non_consolidated_performance_related_payments_for_the__d8b124c4 (
  "main_department" VARCHAR,
  "organisation" VARCHAR,
  "annual_paybill_delegated_grades_for_financial_year_2014_15" VARCHAR  -- Annual Paybill (delegated Grades For Financial Year 2014/15),
  "headcount_delegated_grades_as_at_31_march_2015" BIGINT  -- Headcount (delegated Grades As At 31 March 2015),
  "in_year_cost_of_in_year_ncprp_for_delegated_grades_only" VARCHAR  -- In-Year - Cost Of In-year NCPRP For Delegated Grades Only (£),
  "in_year_number_of_staff_in_delegated_grades_receiving__dcdd1498" BIGINT  -- In-Year - Number Of Staff In Delegated Grades Receiving An In-year NCPRP,
  "in_year_number_of_staff_in_delegated_grades_receiving__41c65dd9" VARCHAR  -- In-Year - Number Of Staff In Delegated Grades Receiving An In-year NCPRP As A % Of Headcount,
  "in_year_value_of_maximum_in_year_ncprp_paid_to_a_membe_3d22f6e7" VARCHAR  -- In-Year - Value Of Maximum In-year NCPRP Paid To A Member Of Staff In The Delegated Grades,
  "in_year_median_ncprp_for_those_receiving_an_in_year_nc_4e4e149c" VARCHAR  -- In-Year - Median NCPRP For Those Receiving An In-year NCPRP For Delegated Grades,
  "end_of_year_cost_of_end_of_year_ncprp_for_delegated_gr_7b1b4680" VARCHAR  -- End Of Year - Cost Of End Of Year NCPRP For Delegated Grades Only (£s),
  "end_of_year_number_of_staff_in_delegated_grades_receiv_0ec921b4" BIGINT  -- End Of Year - Number Of Staff In Delegated Grades Receiving An End Of Year NCPRP,
  "end_of_year_delegated_grade_staff_receiving_an_end_of__8d8228bc" VARCHAR  -- End Of Year - Delegated Grade Staff Receiving An End Of Year NCPRP As A % Of Headcount,
  "end_of_year_value_of_maximum_end_of_year_ncprp_paid_to_0e891936" VARCHAR  -- End Of Year - Value Of Maximum End Of Year NCPRP Paid To A Member Of Staff In The Delegated Grades,
  "end_of_year_median_ncprp_for_those_receiving_an_end_of_87dfbc0f" VARCHAR  -- End Of Year - Median NCPRP For Those Receiving An End Of Year NCPRP For Delegated Grades,
  "total_overall_cost_of_ncprp_in_year_and_end_of_year_fo_5b549edf" VARCHAR  -- Total Overall Cost Of NCPRP (in-year And End Of Year) For Delegated Grades Only,
  "total_cost_of_ncprp_as_a_of_paybill_for_delegated_grades_only" VARCHAR  -- Total Cost Of NCPRP As A % Of Paybill For Delegated Grades Only (%),
  "scs_on_standard_contracts_end_of_year_ncprp_annual_scs_f616845d" VARCHAR  -- SCS On Standard Contracts (end Of Year NCPRP) - Annual SCS Paybill For Those SCS On Standard Contracts (for Financial Year 2014/15),
  "scs_on_standard_contracts_end_of_year_ncprp_number_of__b2844d92" DOUBLE  -- SCS On Standard Contracts (end Of Year NCPRP) - Number Of SCS On Standard Contracts - Headcount (as At 31 March 2015),
  "scs_on_standard_contracts_end_of_year_ncprp_cost_of_nc_35e21f8e" VARCHAR  -- SCS On Standard Contracts (end Of Year NCPRP) - Cost Of NCPRP For SCS Standard Contract Staff (£s),
  "scs_on_standard_contracts_end_of_year_ncprp_cost_of_nc_d54a9f09" VARCHAR  -- SCS On Standard Contracts (end Of Year NCPRP) - Cost Of NCPRP For SCS Standard Contract Staff As A % Of SCS Standard Contract Staff Paybill For 2014/15 (%),
  "scs_on_standard_contracts_end_of_year_ncprp_number_of__8270a5ba" DOUBLE  -- SCS On Standard Contracts (end Of Year NCPRP) - Number Of SCS Standard Contract Staff Receiving A NCPRP,
  "scs_on_standard_contracts_end_of_year_ncprp_scs_standa_84e4e985" VARCHAR  -- SCS On Standard Contracts (end Of Year NCPRP) - SCS Standard Contract Staff Receiving A NCPRP As A % Of SCS Standard Contract Staff Headcount,
  "scs_on_standard_contracts_end_of_year_ncprp_value_of_m_caead551" VARCHAR  -- SCS On Standard Contracts (end Of Year NCPRP) - Value Of Maximum NCPRP Paid To A Member Of SCS Standard Contract Staff In 2014/15,
  "scs_on_standard_contracts_end_of_year_ncprp_median_ncp_30ce5fb2" VARCHAR  -- SCS On Standard Contracts (end Of Year NCPRP) - Median NCPRP For Those SCS Standard Contract Staff Receiving A NCPRP,
  "information_for_scs_on_non_standard_contracts_number_o_d789bf6d" DOUBLE  -- Information For SCS On Non-standard Contracts - Number Of SCS On Non-standard Contarcts - Headcount (as At 31 March 2015),
  "information_for_scs_on_non_standard_contracts_value_of_f850c28d" VARCHAR  -- Information For SCS On Non-standard Contracts - Value Of Maximum NCPRP Paid To A Member Of SCS Non-standard Contract Staff 2014/15,
  "comments" VARCHAR
);