Workforce Management Information - Department For Work And Pensions

year Year	month Month	organisation_name Organisation Name	organisation_type Organisation Type	main_parent_or_sponsoring_department Main, Parent Or Sponsoring Department:	payroll_staff_ao_aa_headcount Payroll Staff; AO/AA; Headcount	payroll_staff_ao_aa_full_time_equivalent Payroll Staff; AO/AA; Full-time Equivalent	payroll_staff_eo_headcount Payroll Staff; EO; Headcount	payroll_staff_eo_full_time_equivalent Payroll Staff; EO; Full-time Equivalent	payroll_staff_seo_heo_headcount Payroll Staff; SEO/HEO; Headcount	payroll_staff_seo_heo_full_time_equivalent Payroll Staff; SEO/HEO; Full-time Equivalent	payroll_staff_grade_6_7_headcount Payroll Staff; Grade 6/7; Headcount	payroll_staff_grade_6_7_full_time_equivalent Payroll Staff; Grade 6/7; Full-time Equivalent	payroll_staff_scs_headcount Payroll Staff; SCS; Headcount	payroll_staff_scs_full_time_equivalent Payroll Staff; SCS; Full-time Equivalent	payroll_staff_other_unknown_unspecified_headcount Payroll Staff; Other, Unknown, Unspecified; Headcount	payroll_staff_other_unknown_unspecified_full_time_equivalent Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent	payroll_staff_total_headcount Payroll Staff; Total; Headcount	payroll_staff_total_full_time_equivalent Payroll Staff; Total; Full-time Equivalent	non_payroll_staff_admin_and_clerical_headcount Non-payroll Staff; Admin And Clerical; Headcount	non_payroll_staff_admin_and_clerical_full_time_equivalent Non-payroll Staff; Admin And Clerical; Full-time Equivalent	non_payroll_staff_interim_managers_specialist_contract_3714f708 Non-payroll Staff; Interim Managers & Specialist Contractors & Medical; Headcount	non_payroll_staff_interim_managers_specialist_contract_4752efd2 Non-payroll Staff; Interim Managers & Specialist Contractors & Medical; Full-time Equivalent	non_payroll_staff_other_contingent_labour_headcount Non-payroll Staff; Other Contingent Labour; Headcount	non_payroll_staff_other_contingent_labour_full_time_equivalent Non-payroll Staff; Other Contingent Labour; Full-time Equivalent	non_payroll_staff_total_contingent_labour_headcount Non-payroll Staff; Total Contingent Labour: Headcount	non_payroll_staff_total_contingent_labour_full_time_equivalent Non-payroll Staff; Total Contingent Labour: Full-time Equivalent	grand_total_workforce_numbers_headcount Grand Total (workforce Numbers); Headcount	grand_total_workforce_numbers_full_time_equivalent Grand Total (workforce Numbers); Full-time Equivalent	payroll_staff_costs_salary Payroll Staff Costs; Salary	payroll_staff_costs_allowances Payroll Staff Costs; Allowances	payroll_staff_costs_non_consolidated_performance_payments Payroll Staff Costs; Non-consolidated Performance Payments	payroll_staff_costs_overtime Payroll Staff Costs; Overtime	payroll_staff_costs_employer_pension_contributions Payroll Staff Costs; Employer Pension Contributions	payroll_staff_costs_employer_national_insurance_contributions Payroll Staff Costs; Employer National Insurance Contributions	payroll_staff_costs_total_paybill Payroll Staff Costs; Total Paybill	non_payroll_staff_costs_contingent_labour Non-Payroll Staff Costs; Contingent Labour	non_payroll_staff_costs_consultancy Non-Payroll Staff Costs; Consultancy	non_payroll_staff_costs_total_staff_costs Non-Payroll Staff Costs; Total Staff Costs	grand_total_paybill_staffing_payroll_and_non_payroll_costs Grand Total Paybill/staffing (payroll And Non-payroll) Costs
2024	February	Department for Work and Pensions	Ministerial Department	Department for Work and Pensions	24675	21237.61	46859	42175.72	13827	13060.68	4259	4098.53	296	288.26			89916	80861			899	899			899	899	90815	81760	Ł214,218,528.48	Ł3,486,792.67	Ł773,103.72	Ł5,287,063.50	Ł58,324,032.23	Ł21,395,339.63	Ł303,484,860.23	Ł11,722,379.32	Ł1,354,030.00	Ł13,076,409.32	Ł316,561,269.55
2024	February	Health and Safety Executive	Crown Non Departmental Public Body	Department for Work and Pensions	323	294.3	537	507.84	1541	1472.2	592	568.38	36	35.09			3029	2878	23	22.4	42	41.8			65	64	3094	2942	Ł11,324,968.67	Ł167,321.17	Ł0.00	Ł9,687.33	Ł2,860,343.24	Ł1,199,594.15	Ł15,561,914.56	Ł698,273.53	Ł0.00	Ł698,273.53	Ł16,260,188.09
2024	February	The Pensions Regulator	Executive Non-Departmental Public Body	Department for Work and Pensions											969.2	940.97	969	941	44.3827	43.09			2.16	2.1	47	45	1016	986	Ł4,297,587.01	Ł0.00	Ł19,038.66	Ł10,708.70	Ł1,022,491.53	Ł433,424.83	Ł5,783,250.73	Ł615,270.56		Ł615,270.56	Ł6,398,521.29
2024	February	Money & Pensions Service	Executive Non-Departmental Public Body	Department for Work and Pensions											492	473.1	492	473			29	19.6			29	20	521	493	Ł2,338,263.55	Ł37,850.46	Ł0.00	Ł0.00	Ł230,400.79	Ł262,573.92	Ł2,869,088.72	Ł167,233.63	Ł0.00	Ł167,233.63	Ł3,036,322.35


CREATE TABLE february_2024 (
  "year" BIGINT,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_staff_ao_aa_headcount" DOUBLE,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" DOUBLE,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" DOUBLE,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" DOUBLE,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" DOUBLE,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE,
  "payroll_staff_total_headcount" BIGINT,
  "payroll_staff_total_full_time_equivalent" BIGINT,
  "non_payroll_staff_admin_and_clerical_headcount" DOUBLE,
  "non_payroll_staff_admin_and_clerical_full_time_equivalent" DOUBLE,
  "non_payroll_staff_interim_managers_specialist_contract_3714f708" DOUBLE,
  "non_payroll_staff_interim_managers_specialist_contract_4752efd2" DOUBLE,
  "non_payroll_staff_other_contingent_labour_headcount" DOUBLE,
  "non_payroll_staff_other_contingent_labour_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_contingent_labour_headcount" BIGINT,
  "non_payroll_staff_total_contingent_labour_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultancy_number_of_contracts" VARCHAR,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill" VARCHAR,
  "non_payroll_staff_costs_contingent_labour" VARCHAR,
  "non_payroll_staff_costs_consultancy" VARCHAR,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);