About this Dataset

Workforce Management Information - Defra

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 Environment, Food and Rural Affairs
Last updated: 2025-04-18T04:03:19Z

Tables

Workforce Management Information October 2020

@ukgov.workforce_management_information_defra.workforce_management_information_october_2020

33.51 KB
19 rows
42 columns


CREATE TABLE workforce_management_information_october_2020 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR
);

Workforce Management Information September 2019

@ukgov.workforce_management_information_defra.workforce_management_information_september_2019

37.74 KB
16 rows
42 columns


CREATE TABLE workforce_management_information_september_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_h_c_aa_ao" BIGINT,
  "payroll_fte_aa_ao" DOUBLE,
  "payroll_h_c_eo" BIGINT,
  "payroll_fte_eo" DOUBLE,
  "payroll_h_c_seo_heo" BIGINT,
  "payroll_fte_seo_heo" DOUBLE,
  "payroll_h_c_g6_7" BIGINT,
  "payroll_fte_g6_7" DOUBLE,
  "payroll_h_c_scs" BIGINT,
  "payroll_fte_scs" DOUBLE,
  "payroll_h_c_other" BIGINT,
  "payroll_fte_other" DOUBLE,
  "total_payroll_h_c" BIGINT,
  "total_payroll_fte" DOUBLE,
  "agency_clerical_admin_h_c" BIGINT,
  "agency_clerical_admin_fte" DOUBLE,
  "interim_managers_h_c" BIGINT,
  "interim_managers_fte" DOUBLE,
  "specialist_contractors_h_c" BIGINT,
  "specialist_contractors_fte" DOUBLE,
  "consultants_consultancy_h_c" BIGINT,
  "consultants_consultancy_fte" DOUBLE,
  "total_non_payroll_h_c_cws" BIGINT,
  "total_non_payroll_fte_cws" DOUBLE,
  "total_all_staff_h_c" BIGINT,
  "total_all_staff_fte" DOUBLE,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" VARCHAR,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR,
  "total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" BIGINT,
  "notes_for_cabinet_office_not_for_publication" BIGINT
);

Workforce Management Information September 2020

@ukgov.workforce_management_information_defra.workforce_management_information_september_2020

33.11 KB
19 rows
42 columns


CREATE TABLE workforce_management_information_september_2020 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR
);