Performance-related Pay - Home Office

CREATE TABLE performance_related_pay_home_office (
  "main_department" VARCHAR,
  "organisation" VARCHAR,
  "annual_paybill_delegated_grades_for_financial_year_2011_12" VARCHAR  -- Annual Paybill (delegated Grades For Financial Year 2011/12),
  "headcount_delegated_grades_as_at_31_march_2012" BIGINT  -- Headcount (delegated Grades As At 31 March 2012),
  "cost_of_in_year_ncprp_for_delegated_grades_only" VARCHAR  -- Cost Of In-year NCPRP For Delegated Grades Only (£),
  "number_of_staff_in_delegated_grades_receiving_an_in_year_ncprp" BIGINT,
  "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_eff65e99" VARCHAR  -- In-Year - Value Of Maximum In-year NCPRP Paid To A Member Of Staff In The Delegated Grades Only,
  "in_year_median_ncprp_for_those_receiving_an_in_year_nc_9f644b13" VARCHAR  -- In-Year - Median NCPRP For Those Receiving An In-year NCPRP For Delegated Grades Only,
  "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_32a398c4" VARCHAR  -- End Of Year - Value Of Maximum End Of Year NCPRP Paid To A Member Of Staff In The Delegated Grades Only,
  "end_of_year_median_ncprp_for_those_receiving_an_end_of_e8c2ed72" VARCHAR  -- End Of Year - Median NCPRP For Those Receiving An End Of Year NCPRP For Delegated Grades Only,
  "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_fa9dccb8" VARCHAR  -- SCS On Standard Contracts (end Of Year NCPRP) - Annual SCS Paybill For Those SCS On Standard Contracts (for Financial Year 2011/12),
  "scs_on_standard_contracts_end_of_year_ncprp_number_of__8f4ba00f" DOUBLE  -- SCS On Standard Contracts (end Of Year NCPRP) - Number Of SCS On Standard Contracts - Headcount (as At 31 March 2012),
  "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_53015507" 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 2011/12 (%),
  "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_8728308f" VARCHAR  -- SCS On Standard Contracts (end Of Year NCPRP) - Value Of Maximum NCPRP Paid To A Member Of SCS Standard Contract Staff For 2011/12,
  "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_a52bb28c" DOUBLE  -- Information For SCS On Non-standard Contracts - Number Of SCS On Non-standard Contarcts - Headcount (as At 31 March 2012),
  "information_for_scs_on_non_standard_contracts_value_of_a2a8627d" VARCHAR  -- Information For SCS On Non-standard Contracts Value Of Maximum MCPRP Paid To A Member Of SCS Non-standard Contract Staff For 2011/12,
  "comments" VARCHAR
);