Baselight
Sign In

Workforce Management Information - Defra

Department for Environment, Food and Rural Affairs

@ukgov.workforce_management_information_defra

Loading...
Loading...

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 - Defra

@ukgov.workforce_management_information_defra.workforce_management_information_defra
  • 41.51 KB
  • 16 rows
  • 41 columns
Loading... 

CREATE TABLE workforce_management_information_defra (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_staff_ao_aa_headcount" VARCHAR,
  "payroll_staff_ao_aa_full_time_equivalent" VARCHAR,
  "payroll_staff_eo_headcount" VARCHAR,
  "payroll_staff_eo_full_time_equivalent" VARCHAR,
  "payroll_staff_seo_heo_headcount" VARCHAR,
  "payroll_staff_seo_heo_full_time_equivalent" VARCHAR,
  "payroll_staff_grade_6_7_headcount" VARCHAR,
  "payroll_staff_grade_6_7_full_time_equivalent" VARCHAR,
  "payroll_staff_scs_headcount" VARCHAR,
  "payroll_staff_scs_full_time_equivalent" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_headcount" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" VARCHAR,
  "payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR,
  "non_payroll_staff_intermin_managers_headcount" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" VARCHAR,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" VARCHAR,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" VARCHAR,
  "non_payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "grand_total_workforce_numbers_headcount" VARCHAR,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR,
  "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_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

Workforce Management Information July 2020

@ukgov.workforce_management_information_defra.workforce_management_information_july_2020
  • 33.06 KB
  • 19 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_july_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 - March 2018

@ukgov.workforce_management_information_defra.workforce_management_information_march_2018
  • 41.69 KB
  • 16 rows
  • 41 columns
Loading... 

CREATE TABLE workforce_management_information_march_2018 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_staff_ao_aa_headcount" VARCHAR,
  "payroll_staff_ao_aa_full_time_equivalent" VARCHAR,
  "payroll_staff_eo_headcount" VARCHAR,
  "payroll_staff_eo_full_time_equivalent" VARCHAR,
  "payroll_staff_seo_heo_headcount" VARCHAR,
  "payroll_staff_seo_heo_full_time_equivalent" VARCHAR,
  "payroll_staff_grade_6_7_headcount" VARCHAR,
  "payroll_staff_grade_6_7_full_time_equivalent" VARCHAR,
  "payroll_staff_scs_headcount" VARCHAR,
  "payroll_staff_scs_full_time_equivalent" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_headcount" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" VARCHAR,
  "payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR,
  "non_payroll_staff_intermin_managers_headcount" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" VARCHAR,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" VARCHAR,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" VARCHAR,
  "non_payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "grand_total_workforce_numbers_headcount" VARCHAR,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR,
  "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_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

Workforce Management Information November 2018

@ukgov.workforce_management_information_defra.workforce_management_information_november_2018
  • 42.28 KB
  • 16 rows
  • 41 columns
Loading... 

CREATE TABLE workforce_management_information_november_2018 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_staff_ao_aa_headcount" VARCHAR,
  "payroll_staff_ao_aa_full_time_equivalent" VARCHAR,
  "payroll_staff_eo_headcount" VARCHAR,
  "payroll_staff_eo_full_time_equivalent" VARCHAR,
  "payroll_staff_seo_heo_headcount" VARCHAR,
  "payroll_staff_seo_heo_full_time_equivalent" VARCHAR,
  "payroll_staff_grade_6_7_headcount" VARCHAR,
  "payroll_staff_grade_6_7_full_time_equivalent" VARCHAR,
  "payroll_staff_scs_headcount" VARCHAR,
  "payroll_staff_scs_full_time_equivalent" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_headcount" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" VARCHAR,
  "payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR,
  "non_payroll_staff_intermin_managers_headcount" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" VARCHAR,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" VARCHAR,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" VARCHAR,
  "non_payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "grand_total_workforce_numbers_headcount" VARCHAR,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR,
  "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_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

Workforce Management Information June 2019

@ukgov.workforce_management_information_defra.workforce_management_information_june_2019
  • 33.28 KB
  • 50 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_june_2019 (
  "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 January 2020

@ukgov.workforce_management_information_defra.workforce_management_information_january_2020
  • 37.95 KB
  • 14 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_january_2020 (
  "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" DOUBLE,
  "allowances" DOUBLE,
  "non_consolidated_performance_payments" DOUBLE,
  "overtime" DOUBLE,
  "employer_pension_contributions" DOUBLE,
  "employer_national_insurance_contributions" DOUBLE,
  "total_paybill_for_payroll_staff" DOUBLE,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" DOUBLE,
  "total_monthly_cost_of_consultants_consultancy" DOUBLE,
  "total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR,
  "notes_for_cabinet_office_not_for_publication" VARCHAR
);

Workforce Management Information October 2020

@ukgov.workforce_management_information_defra.workforce_management_information_october_2020
  • 33.51 KB
  • 19 rows
  • 42 columns
Loading... 

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 March 2020

@ukgov.workforce_management_information_defra.workforce_management_information_march_2020
  • 33.52 KB
  • 19 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_march_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 March 2019

@ukgov.workforce_management_information_defra.workforce_management_information_march_2019
  • 44.29 KB
  • 16 rows
  • 41 columns
Loading... 

CREATE TABLE workforce_management_information_march_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" BIGINT,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "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_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

Workforce Management Information February 2020 Revised

@ukgov.workforce_management_information_defra.workforce_management_information_february_2020_revised
  • 34.12 KB
  • 19 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_february_2020_revised (
  "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 May 2020

@ukgov.workforce_management_information_defra.workforce_management_information_may_2020
  • 33.65 KB
  • 19 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_may_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 July 2019

@ukgov.workforce_management_information_defra.workforce_management_information_july_2019
  • 33.22 KB
  • 50 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_july_2019 (
  "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 February 2019

@ukgov.workforce_management_information_defra.workforce_management_information_february_2019
  • 42.04 KB
  • 16 rows
  • 41 columns
Loading... 

CREATE TABLE workforce_management_information_february_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_staff_ao_aa_headcount" VARCHAR,
  "payroll_staff_ao_aa_full_time_equivalent" VARCHAR,
  "payroll_staff_eo_headcount" VARCHAR,
  "payroll_staff_eo_full_time_equivalent" VARCHAR,
  "payroll_staff_seo_heo_headcount" VARCHAR,
  "payroll_staff_seo_heo_full_time_equivalent" VARCHAR,
  "payroll_staff_grade_6_7_headcount" VARCHAR,
  "payroll_staff_grade_6_7_full_time_equivalent" VARCHAR,
  "payroll_staff_scs_headcount" VARCHAR,
  "payroll_staff_scs_full_time_equivalent" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_headcount" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" VARCHAR,
  "payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR,
  "non_payroll_staff_intermin_managers_headcount" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" VARCHAR,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" VARCHAR,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" VARCHAR,
  "non_payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "grand_total_workforce_numbers_headcount" VARCHAR,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR,
  "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_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

Workforce Management Information December 2018

@ukgov.workforce_management_information_defra.workforce_management_information_december_2018
  • 41.63 KB
  • 16 rows
  • 41 columns
Loading... 

CREATE TABLE workforce_management_information_december_2018 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_staff_ao_aa_headcount" VARCHAR,
  "payroll_staff_ao_aa_full_time_equivalent" VARCHAR,
  "payroll_staff_eo_headcount" VARCHAR,
  "payroll_staff_eo_full_time_equivalent" VARCHAR,
  "payroll_staff_seo_heo_headcount" VARCHAR,
  "payroll_staff_seo_heo_full_time_equivalent" VARCHAR,
  "payroll_staff_grade_6_7_headcount" VARCHAR,
  "payroll_staff_grade_6_7_full_time_equivalent" VARCHAR,
  "payroll_staff_scs_headcount" VARCHAR,
  "payroll_staff_scs_full_time_equivalent" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_headcount" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" VARCHAR,
  "payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR,
  "non_payroll_staff_intermin_managers_headcount" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" VARCHAR,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" VARCHAR,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" VARCHAR,
  "non_payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "grand_total_workforce_numbers_headcount" VARCHAR,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR,
  "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_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

Workforce Management Information April 2020

@ukgov.workforce_management_information_defra.workforce_management_information_april_2020
  • 32.97 KB
  • 19 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_april_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 October 2019

@ukgov.workforce_management_information_defra.workforce_management_information_october_2019
  • 38.7 KB
  • 16 rows
  • 43 columns
Loading... 

CREATE TABLE workforce_management_information_october_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" DOUBLE,
  "allowances" DOUBLE,
  "non_consolidated_performance_payments" BIGINT,
  "overtime" DOUBLE,
  "employer_pension_contributions" DOUBLE,
  "employer_national_insurance_contributions" DOUBLE,
  "total_paybill_for_payroll_staff" DOUBLE,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" DOUBLE,
  "total_monthly_cost_of_consultants_consultancy" DOUBLE,
  "total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR,
  "notes_for_cabinet_office_not_for_publication" VARCHAR,
  "month" VARCHAR
);

Workforce Management Information December 2019 Revised

@ukgov.workforce_management_information_defra.workforce_management_information_december_2019_revised
  • 38.7 KB
  • 14 rows
  • 43 columns
Loading... 

CREATE TABLE workforce_management_information_december_2019_revised (
  "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" DOUBLE,
  "payroll_fte_other" DOUBLE,
  "total_payroll_h_c" BIGINT,
  "total_payroll_fte" DOUBLE,
  "agency_clerical_admin_h_c" DOUBLE,
  "agency_clerical_admin_fte" DOUBLE,
  "interim_managers_h_c" DOUBLE,
  "interim_managers_fte" DOUBLE,
  "specialist_contractors_h_c" DOUBLE,
  "specialist_contractors_fte" DOUBLE,
  "consultants_consultancy_h_c" DOUBLE,
  "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" DOUBLE,
  "allowances" DOUBLE,
  "non_consolidated_performance_payments" DOUBLE,
  "overtime" DOUBLE,
  "employer_pension_contributions" DOUBLE,
  "employer_national_insurance_contributions" DOUBLE,
  "total_paybill_for_payroll_staff" DOUBLE,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" DOUBLE,
  "total_monthly_cost_of_consultants_consultancy" DOUBLE,
  "total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR,
  "notes_for_cabinet_office_not_for_publication" VARCHAR,
  "month" VARCHAR
);

Workforce Management Information September 2020

@ukgov.workforce_management_information_defra.workforce_management_information_september_2020
  • 33.11 KB
  • 19 rows
  • 42 columns
Loading... 

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
);

Workforce Management Information May 2019

@ukgov.workforce_management_information_defra.workforce_management_information_may_2019
  • 33.28 KB
  • 50 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_may_2019 (
  "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 - March 2017

@ukgov.workforce_management_information_defra.workforce_management_information_march_2017
  • 43.43 KB
  • 16 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_march_2017 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_staff_ao_aa_headcount" VARCHAR,
  "payroll_staff_ao_aa_full_time_equivalent" VARCHAR,
  "payroll_staff_eo_headcount" VARCHAR,
  "payroll_staff_eo_full_time_equivalent" VARCHAR,
  "payroll_staff_seo_heo_headcount" VARCHAR,
  "payroll_staff_seo_heo_full_time_equivalent" VARCHAR,
  "payroll_staff_grade_6_7_headcount" VARCHAR,
  "payroll_staff_grade_6_7_full_time_equivalent" VARCHAR,
  "payroll_staff_scs_headcount" VARCHAR,
  "payroll_staff_scs_full_time_equivalent" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_headcount" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" VARCHAR,
  "payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR,
  "non_payroll_staff_intermin_managers_headcount" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" VARCHAR,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" VARCHAR,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" VARCHAR,
  "non_payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "grand_total_workforce_numbers_headcount" VARCHAR,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR,
  "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_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR,
  "unnamed_41" VARCHAR
);

Workforce Management Information November 2019

@ukgov.workforce_management_information_defra.workforce_management_information_november_2019
  • 38.29 KB
  • 14 rows
  • 43 columns
Loading... 

CREATE TABLE workforce_management_information_november_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_h_c_aa_ao" DOUBLE,
  "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" DOUBLE,
  "payroll_fte_other" DOUBLE,
  "total_payroll_h_c" BIGINT,
  "total_payroll_fte" DOUBLE,
  "agency_clerical_admin_h_c" DOUBLE,
  "agency_clerical_admin_fte" DOUBLE,
  "interim_managers_h_c" DOUBLE,
  "interim_managers_fte" DOUBLE,
  "specialist_contractors_h_c" DOUBLE,
  "specialist_contractors_fte" DOUBLE,
  "consultants_consultancy_h_c" DOUBLE,
  "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" DOUBLE,
  "allowances" DOUBLE,
  "non_consolidated_performance_payments" DOUBLE,
  "overtime" DOUBLE,
  "employer_pension_contributions" DOUBLE,
  "employer_national_insurance_contributions" DOUBLE,
  "total_paybill_for_payroll_staff" DOUBLE,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" DOUBLE,
  "total_monthly_cost_of_consultants_consultancy" DOUBLE,
  "total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR,
  "notes_for_cabinet_office_not_for_publication" VARCHAR,
  "month" VARCHAR
);

Workforce Management Information August 2020

@ukgov.workforce_management_information_defra.workforce_management_information_august_2020
  • 33.12 KB
  • 19 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_august_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 November 2020

@ukgov.workforce_management_information_defra.workforce_management_information_november_2020
  • 33.92 KB
  • 440 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_november_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 January 2019

@ukgov.workforce_management_information_defra.workforce_management_information_january_2019
  • 41.92 KB
  • 16 rows
  • 41 columns
Loading... 

CREATE TABLE workforce_management_information_january_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_staff_ao_aa_headcount" VARCHAR,
  "payroll_staff_ao_aa_full_time_equivalent" VARCHAR,
  "payroll_staff_eo_headcount" VARCHAR,
  "payroll_staff_eo_full_time_equivalent" VARCHAR,
  "payroll_staff_seo_heo_headcount" VARCHAR,
  "payroll_staff_seo_heo_full_time_equivalent" VARCHAR,
  "payroll_staff_grade_6_7_headcount" VARCHAR,
  "payroll_staff_grade_6_7_full_time_equivalent" VARCHAR,
  "payroll_staff_scs_headcount" VARCHAR,
  "payroll_staff_scs_full_time_equivalent" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_headcount" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" VARCHAR,
  "payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" VARCHAR,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR,
  "non_payroll_staff_intermin_managers_headcount" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" VARCHAR,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" VARCHAR,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" VARCHAR,
  "non_payroll_staff_total_employees_full_time_equivalent" VARCHAR,
  "grand_total_workforce_numbers_headcount" VARCHAR,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR,
  "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_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

Workforce Management Information June 2020

@ukgov.workforce_management_information_defra.workforce_management_information_june_2020
  • 33.46 KB
  • 19 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_june_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 April 2019

@ukgov.workforce_management_information_defra.workforce_management_information_april_2019
  • 33.29 KB
  • 50 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_april_2019 (
  "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
Loading... 

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 August 2019

@ukgov.workforce_management_information_defra.workforce_management_information_august_2019
  • 33.29 KB
  • 50 rows
  • 42 columns
Loading... 

CREATE TABLE workforce_management_information_august_2019 (
  "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
);

Share link

Anyone who has the link will be able to view this.