About this Dataset

Workforce Management Information - Department For Work And Pensions

"Monthly management information on staff numbers and paybill costs in Civil Service departments, their agencies and their executive NDPBs.
For workforce numbers, both payroll and non-payroll (contingent labour, including consultants) information is provided, split between full-time equivalents (FTE) and headcount, with payroll staff numbers mapped to standard Civil Service grades.
For costs, payroll paybill information is broken down into its component parts i.e. salaries, allowances, employers pensions contributions etc. For non-payroll costs, these are split between costs for consultancy and those of other non-payroll workers.
Staffing numbers are as at the last day of the month for the reference month. Cost information is that for the reference month. For baseline 2010/11 returns, staffing numbers are as at 31 March 2011, and paybill costs are for the financial year 2010/11."

Publisher name: Department for Work and Pensions
Last updated: 2025-06-30T04:00:47Z

Tables

April 2025

@ukgov.workforce_management_information_dwp.april_2025

40.52 kB
4 rows
41 columns

CREATE TABLE april_2025 (
  "year" BIGINT,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" DOUBLE  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" DOUBLE  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" DOUBLE  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" DOUBLE  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" DOUBLE  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" DOUBLE  -- Payroll Staff; Other; Unknown; Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff; Other; Unknown; Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" BIGINT  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" BIGINT  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_admin_and_clarical_headcount" DOUBLE  -- Non-payroll Staff; Admin And Clarical; Headcount,
  "non_payroll_staff_admin_and_clarical_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Admin And Clarical; Full-time Equivalent,
  "non_payroll_staff_interim_managers_specialist_contract_061436f1" DOUBLE  -- Non-payroll Staff; Interim Managers, Specialist Contractors And Medical; Headcount,
  "non_payroll_staff_interim_managers_specialist_contract_ed1e7076" DOUBLE  -- Non-payroll Staff; Interim Managers, Specialist Contractors And Medical; Full-time Equivalent,
  "non_payroll_staff_other_contingent_labour_headcount" DOUBLE  -- Non-payroll Staff; Other Contingent Labour; Headcount,
  "non_payroll_staff_other_contingent_labour_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Other Contingent Labour; Full-time Equivalent,
  "non_payroll_staff_total_contingent_labour_headcount" BIGINT  -- Non-payroll Staff; Total Contingent Labour; Headcount,
  "non_payroll_staff_total_contingent_labour_full_time_equivalent" BIGINT  -- Non-payroll Staff; Total Contingent Labour; Full-time Equivalent,
  "non_payroll_staff_consultancy_number_of_contracts" VARCHAR  -- Non-payroll Staff; Consultancy; Number Of Contracts,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs: Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_bill" VARCHAR  -- Payroll Staff Costs; Total Bill,
  "non_payroll_staff_costs_contingent_labour" VARCHAR  -- Non-payroll Staff Costs; Contingent Labour,
  "non_payroll_staff_costs_consultancy" VARCHAR  -- Non-payroll Staff Costs; Consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs
);

May 2025

@ukgov.workforce_management_information_dwp.may_2025

40.55 kB
4 rows
41 columns

CREATE TABLE may_2025 (
  "year" BIGINT,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" DOUBLE  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" DOUBLE  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" DOUBLE  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" DOUBLE  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" DOUBLE  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" DOUBLE  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" BIGINT  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" BIGINT  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_admin_and_clerical_headcount" DOUBLE  -- Non-payroll Staff; Admin And Clerical; Headcount,
  "non_payroll_staff_admin_and_clerical_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Admin And Clerical; Full-time Equivalent,
  "non_payroll_staff_interim_managers_specialist_contract_3714f708" DOUBLE  -- Non-payroll Staff; Interim Managers & Specialist Contractors & Medical; Headcount,
  "non_payroll_staff_interim_managers_specialist_contract_4752efd2" DOUBLE  -- Non-payroll Staff; Interim Managers & Specialist Contractors & Medical; Full-time Equivalent,
  "non_payroll_staff_other_contingent_labour_headcount" DOUBLE  -- Non-payroll Staff; Other Contingent Labour; Headcount,
  "non_payroll_staff_other_contingent_labour_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Other Contingent Labour; Full-time Equivalent,
  "non_payroll_staff_total_contingent_labour_headcount" BIGINT  -- Non-payroll Staff; Total Contingent Labour; Headcount,
  "non_payroll_staff_total_contingent_labour_full_time_equivalent" BIGINT  -- Non-payroll Staff; Total Contingent Labour; Full-time Equivalent,
  "non_payroll_staff_consultancy_number_of_contracts" VARCHAR  -- Non-payroll Staff; Consultancy; Number Of Contracts,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour,
  "non_payroll_staff_costs_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs
);