Non-consolidated Performance Related Pay - Department For Business, Innovation And Skills

CREATE TABLE non_consolidated_performance_related_pay_department_fo_6abbc774 (
  "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" DOUBLE  -- Headcount (delegated Grades As At 31 March 2013),
  "cost_of_in_year_ncprp_for_delegated_grades" VARCHAR  -- Cost Of In-year NCPRP For Delegated Grades (£),
  "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_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_f9b05d20" 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_grades_s" VARCHAR  -- End Of Year - Cost Of End Of Year NCPRP For Delegated Grades (£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_4ff39001" 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_6cb98a6c" 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_e1aa6230" VARCHAR  -- Total Overall Cost Of NCPRP (in-year And End Of Year) For Delegated Grades,
  "total_cost_of_ncprp_as_a_of_paybill_for_delegated_grades" VARCHAR  -- Total Cost Of NCPRP As A % Of Paybill For Delegated Grades (%),
  "scs_on_standard_contracts_end_of_year_ncprp_annual_scs_f30495e5" VARCHAR  -- SCS On Standard Contracts (end Of Year NCPRP) - Annual SCS Paybill For Those SCS On Standard Contracts (for Financial Year 2012/13),
  "scs_on_standard_contracts_end_of_year_ncprp_number_of__128fc846" DOUBLE  -- SCS On Standard Contracts (end Of Year NCPRP) - Number Of SCS On Standard Contracts - Headcount (as At 31 March 2013),
  "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_8faaaf95" 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 2012/13 (%),
  "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_dfd9d6c8" VARCHAR  -- SCS On Standard Contracts (end Of Year NCPRP) - Value Of Maximum NCPRP Paid To A Member Of SCS Standard Contract Staff For 2012/13,
  "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_94f6dc58" DOUBLE  -- Information For SCS On Non-standard Contracts - Number Of SCS On Non-standard Contarcts - Headcount (as At 31 March 2013),
  "information_for_scs_on_non_standard_contracts_value_of_08cfac63" VARCHAR  -- Information For SCS On Non-standard Contracts Value Of Maximum MCPRP Paid To A Member Of SCS Non-standard Contract Staff For 2012/13,
  "comments" VARCHAR
);