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

@ukgov.workforce_management_information_defra.workforce_management_information_april_2019
  • 34.09 kB
  • 50 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_april_2019 (
  "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 April 2020

@ukgov.workforce_management_information_defra.workforce_management_information_april_2020
  • 33.76 kB
  • 19 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_april_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 August 2019

@ukgov.workforce_management_information_defra.workforce_management_information_august_2019
  • 34.09 kB
  • 50 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_august_2019 (
  "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 August 2020

@ukgov.workforce_management_information_defra.workforce_management_information_august_2020
  • 33.92 kB
  • 19 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_august_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 December 2018

@ukgov.workforce_management_information_defra.workforce_management_information_december_2018
  • 42.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  -- Main, Parent Or Sponsoring Department,
  "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 Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "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) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "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) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff 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" VARCHAR
);

Workforce Management Information December 2019 Revised

@ukgov.workforce_management_information_defra.workforce_management_information_december_2019_revised
  • 39.63 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  -- 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" DOUBLE  -- 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" DOUBLE  -- Agency (Clerical / Admin) H/C,
  "agency_clerical_admin_fte" DOUBLE  -- Agency (Clerical / Admin) FTE,
  "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 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" 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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" DOUBLE  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" DOUBLE  -- Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication),
  "month" VARCHAR
);

Workforce Management Information - Defra

@ukgov.workforce_management_information_defra.workforce_management_information_defra
  • 42.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  -- Main, Parent Or Sponsoring Department,
  "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 Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "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) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "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) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff 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" VARCHAR
);

Workforce Management Information February 2019

@ukgov.workforce_management_information_defra.workforce_management_information_february_2019
  • 43.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  -- Main, Parent Or Sponsoring Department,
  "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 Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "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) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "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) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff 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" VARCHAR
);

Workforce Management Information February 2020 Revised

@ukgov.workforce_management_information_defra.workforce_management_information_february_2020_revised
  • 34.94 kB
  • 19 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_february_2020_revised (
  "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 January 2019

@ukgov.workforce_management_information_defra.workforce_management_information_january_2019
  • 42.93 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  -- Main, Parent Or Sponsoring Department,
  "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 Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "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) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "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) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff 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" VARCHAR
);

Workforce Management Information January 2020

@ukgov.workforce_management_information_defra.workforce_management_information_january_2020
  • 38.86 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  -- 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" 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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" DOUBLE  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" DOUBLE  -- Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication)
);

Workforce Management Information July 2019

@ukgov.workforce_management_information_defra.workforce_management_information_july_2019
  • 34.02 kB
  • 50 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_july_2019 (
  "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 July 2020

@ukgov.workforce_management_information_defra.workforce_management_information_july_2020
  • 33.86 kB
  • 19 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_july_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 June 2019

@ukgov.workforce_management_information_defra.workforce_management_information_june_2019
  • 34.08 kB
  • 50 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_june_2019 (
  "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 June 2020

@ukgov.workforce_management_information_defra.workforce_management_information_june_2020
  • 34.27 kB
  • 19 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_june_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 - March 2017

@ukgov.workforce_management_information_defra.workforce_management_information_march_2017
  • 44.48 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  -- Main, Parent Or Sponsoring Department,
  "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 Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "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) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "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) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff 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" VARCHAR,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

Workforce Management Information - March 2018

@ukgov.workforce_management_information_defra.workforce_management_information_march_2018
  • 42.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  -- Main, Parent Or Sponsoring Department,
  "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 Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "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) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "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) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff 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" VARCHAR
);

Workforce Management Information March 2019

@ukgov.workforce_management_information_defra.workforce_management_information_march_2019
  • 45.35 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  -- Main, Parent Or Sponsoring Department,
  "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 Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "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) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "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) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff 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" VARCHAR
);

Workforce Management Information March 2020

@ukgov.workforce_management_information_defra.workforce_management_information_march_2020
  • 34.33 kB
  • 19 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_march_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 May 2019

@ukgov.workforce_management_information_defra.workforce_management_information_may_2019
  • 34.08 kB
  • 50 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_may_2019 (
  "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 May 2020

@ukgov.workforce_management_information_defra.workforce_management_information_may_2020
  • 34.46 kB
  • 19 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_may_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 November 2018

@ukgov.workforce_management_information_defra.workforce_management_information_november_2018
  • 43.3 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  -- Main, Parent Or Sponsoring Department,
  "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 Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "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) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" VARCHAR  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "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) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" VARCHAR  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff 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" VARCHAR
);

Workforce Management Information November 2019

@ukgov.workforce_management_information_defra.workforce_management_information_november_2019
  • 39.2 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  -- Main, Parent Or Sponsoring Department:,
  "payroll_h_c_aa_ao" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Agency (Clerical / Admin) H/C,
  "agency_clerical_admin_fte" DOUBLE  -- Agency (Clerical / Admin) FTE,
  "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 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" 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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" DOUBLE  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" DOUBLE  -- Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication),
  "month" VARCHAR
);

Workforce Management Information November 2020

@ukgov.workforce_management_information_defra.workforce_management_information_november_2020
  • 34.74 kB
  • 440 rows
  • 42 columns
Loading... 
CREATE TABLE workforce_management_information_november_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 October 2019

@ukgov.workforce_management_information_defra.workforce_management_information_october_2019
  • 39.63 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  -- 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" 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 Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" DOUBLE  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" DOUBLE  -- Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication),
  "month" VARCHAR
);

Share link

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