Ministry Of Justice Non-Consolidated Performance Related Payments 2012-2013

CREATE TABLE ministry_of_justice_non_consolidated_performance_relat_d0996664 (
  "main_department" VARCHAR,
  "organisation" VARCHAR,
  "annual_paybill_delegated_grades_for_financial_year_2012_13" VARCHAR  -- Annual Paybill (delegated Grades For Financial Year 2012/13),
  "headcount_delegated_grades_as_at_31_march_2013" BIGINT  -- Headcount (delegated Grades As At 31 March 2013),
  "cost_of_in_year_ncprp_for_delegated_grades_s" VARCHAR  -- Cost Of In-year NCPRP For Delegated Grades (£s),
  "number_of_staff_in_delegated_grades_receiving_an_in_year_ncprp" BIGINT,
  "number_of_staff_in_delegated_grades_receiving_an_in_ye_15882454" VARCHAR  -- Number Of Staff In Delegated Grades Receiving An In-year NCPRP As A % Of Headcount,
  "value_of_maximum_in_year_ncprp_paid_to_a_member_of_sta_c18760e3" VARCHAR  -- Value Of Maximum In-year NCPRP Paid To A Member Of Staff In The Delegated Grades,
  "median_ncprp_for_those_receiving_an_in_year_ncprp_fopr_6e4bb43e" VARCHAR  -- Median NCPRP For Those Receiving An In-year NCPRP Fopr Delegated Grades,
  "cost_of_end_of_year_ncprp_for_delegated_grades_s" VARCHAR  -- Cost Of End Of Year NCPRP For Delegated Grades (£s),
  "number_of_staff_in_delegated_grades_receiving_an_end_o_8213bfc2" BIGINT  -- Number Of Staff In Delegated Grades Receiving An End Of Year NCPRP,
  "delegated_grade_staff_receiving_an_end_of_year_ncprp_a_a88f6f85" VARCHAR  -- Delegated Grade Staff Receiving An End Of Year NCPRP As A % Of Headcount,
  "value_of_maximum_end_of_year_ncprp_paid_to_a_member_of_bcfd0e27" VARCHAR  -- Value Of Maximum End Of Year NCPRP Paid To A Member Of Staff In The Delegated Grades,
  "median_ncprp_for_those_receiving_an_end_of_year_ncprp__0bf2152f" VARCHAR  -- Median NCPRP For Those Receiving An End Of Year NCPRP Fopr Delegated Grades,
  "overall_cost_of_ncprp_in_year_and_end_of_year_for_dele_0b270ee8" VARCHAR  -- Overall Cost Of NCPRP (in-year And End Of Year) For Delegated Grades,
  "cost_of_ncprp_as_a_of_paybill_for_delegated_grades" VARCHAR  -- Cost Of NCPRP As A % Of Paybill For Delegated Grades (%),
  "annual_scs_paybill_for_those_scs_on_standard_contracts_924fa899" VARCHAR  -- Annual SCS Paybill For Those SCS On Standard Contracts (for Financial Year 2012/13),
  "number_of_scs_on_standard_contracts_headcount_as_at_31_54cdf90a" BIGINT  -- Number Of SCS On Standard Contracts - Headcount (as At 31 March 2013),
  "cost_of_ncprp_for_scs_standard_contract_staff_s" VARCHAR  -- Cost Of NCPRP For SCS Standard Contract Staff (£s),
  "cost_of_ncprp_for_scs_standard_contract_staff_as_a_of__a40caec6" VARCHAR  -- Cost Of NCPRP For SCS Standard Contract Staff As A % Of SCS Standard Contract Staff Paybill For 2012/13 (%),
  "number_of_scs_standard_contract_staff_receiving_a_ncprp" BIGINT,
  "scs_standard_contract_staff_receiving_a_ncprp_as_a_of__e981919d" VARCHAR  -- SCS Standard Contract Staff Receiving A NCPRP As A % Of SCS Standard Contract Staff Headcount,
  "value_of_maximum_ncprp_paid_to_a_member_of_scs_standar_0f8c2f56" VARCHAR  -- Value Of Maximum NCPRP Paid To A Member Of SCS Standard Contract Staff For 2012/13,
  "median_ncprp_for_those_scs_standard_contract_staff_rec_6e9ae1b5" VARCHAR  -- Median NCPRP For Those SCS Standard Contract Staff Receiving A NCPRP,
  "number_of_scs_on_non_standard_contracts_headcount_as_a_eec63ed8" VARCHAR  -- Number Of SCS On Non-standard Contracts - Headcount (as At 31 March 2013),
  "value_of_maximum_ncprp_paid_to_a_member_of_scs_non_sta_c356fff5" VARCHAR  -- Value Of Maximum NCPRP Paid To A Member Of SCS Non-standard Contract Staff For 2012/13,
  "comments" VARCHAR
);