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	October	Department for Work and Pensions	Ministerial Department	Department for Work and Pensions	24289	20888.09	49699	44860.91	13893	13077	4404	4215.79	297	289.7			92582	83331			839	839			839	839	93421	84170	Ł234,201,635.60	Ł3,510,593.82	Ł950,420.42	Ł3,347,391.47	Ł64,024,473.59	Ł22,974,471.70	Ł329,008,986.60	Ł14,248,156.06	Ł529,430.65	Ł14,777,586.71	Ł343,786,573.31
2024	October	Health and Safety Executive	Crown Non Departmental Public Body	Department for Work and Pensions	296	269.48	534	504.06	1610	1535.93	594	569.12	36	35.09			3070	2914	12	11.6	31	31			43	43	3113	2956	Ł11,784,081.79	Ł177,536.18	Ł125,704.06	Ł14,555.41	Ł3,165,425.54	Ł1,353,474.26	Ł16,620,777.24	Ł664,447.85	Ł0.00	Ł664,447.85	Ł17,285,225.09
2024	October	The Pensions Regulator	Executive Non-Departmental Public Body	Department for Work and Pensions											926	899.15	926	899	60	58.03			1	1	61	59	987	958	Ł4,043,606.67	Ł0.00	Ł134,937.50	Ł10,044.57	Ł1,154,681.86	Ł465,467.67	Ł5,808,738.27	Ł733,778.15	Ł0.00	Ł733,778.15	Ł6,542,516.42
2024	October	Money & Pensions Service	Executive Non-Departmental Public Body	Department for Work and Pensions											490	471.3	490	471			11	9.2			11	9	501	481	Ł2,413,400.65	Ł55,069.76	Ł0.00	Ł0.00	Ł242,620.26	Ł286,625.20	Ł2,997,715.87	Ł202,397.69	Ł0.00	Ł202,397.69	Ł3,200,113.56


CREATE TABLE october_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
);