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

34.31 kB
19 rows
42 columns

CREATE TABLE workforce_management_information_october_2020 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR  -- Please Read The Additional Data Fields Descriptions Before Entering Information Into This Template. Completed Templates Must Be Returned To Your Organisation's Main, Parent Or Sponsoring Department. They Will Provide One Return To Cabinet Office Capturing Information For All Their Relevant Organisations. (NB: This Data Sheet Is Password Protected. Contact Cabinet Office If You Require The Password.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

Workforce Management Information September 2019

@ukgov.workforce_management_information_defra.workforce_management_information_september_2019

38.64 kB
16 rows
42 columns

CREATE TABLE workforce_management_information_september_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_h_c_aa_ao" BIGINT  -- Payroll H/C - AA/ AO,
  "payroll_fte_aa_ao" DOUBLE  -- Payroll FTE - AA/AO,
  "payroll_h_c_eo" BIGINT  -- Payroll H/C - EO,
  "payroll_fte_eo" DOUBLE  -- Payroll FTE - EO,
  "payroll_h_c_seo_heo" BIGINT  -- Payroll H/C - SEO/HEO,
  "payroll_fte_seo_heo" DOUBLE  -- Payroll FTE - SEO/HEO,
  "payroll_h_c_g6_7" BIGINT  -- Payroll H/C - G6/7,
  "payroll_fte_g6_7" DOUBLE  -- Payroll FTE - G6/7,
  "payroll_h_c_scs" BIGINT  -- Payroll H/C - SCS,
  "payroll_fte_scs" DOUBLE  -- Payroll FTE - SCS,
  "payroll_h_c_other" BIGINT  -- Payroll H/C - Other,
  "payroll_fte_other" DOUBLE  -- Payroll FTE - Other,
  "total_payroll_h_c" BIGINT,
  "total_payroll_fte" DOUBLE,
  "agency_clerical_admin_h_c" BIGINT  -- Agency (Clerical / Admin) H/C,
  "agency_clerical_admin_fte" DOUBLE  -- Agency (Clerical / Admin) FTE,
  "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 H/C,
  "consultants_consultancy_fte" DOUBLE  -- Consultants / Consultancy FTE,
  "total_non_payroll_h_c_cws" BIGINT  -- Total Non Payroll H/C (CWs),
  "total_non_payroll_fte_cws" DOUBLE  -- Total Non Payroll FTE (CWs),
  "total_all_staff_h_c" BIGINT,
  "total_all_staff_fte" DOUBLE  -- Total All Staff FTE -,
  "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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" VARCHAR  -- Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" BIGINT  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" BIGINT  -- Notes For Cabinet Office (Not For Publication)
);

Workforce Management Information September 2020

@ukgov.workforce_management_information_defra.workforce_management_information_september_2020

33.9 kB
19 rows
42 columns

CREATE TABLE workforce_management_information_september_2020 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR  -- Please Read The Additional Data Fields Descriptions Before Entering Information Into This Template. Completed Templates Must Be Returned To Your Organisation's Main, Parent Or Sponsoring Department. They Will Provide One Return To Cabinet Office Capturing Information For All Their Relevant Organisations. (NB: This Data Sheet Is Password Protected. Contact Cabinet Office If You Require The Password.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);