About this Dataset

BEIS: Workforce Management Information

Documents relating to workforce management information (WMI) summary data for the Department for Business, Energy and Industrial Strategy (BEIS). This data covers: payroll staff by grade non-payroll staff by type headcount staff numbers full-time equivalent staff numbers staff costs April, May, and July 2020 were republished on 23 November 2020 to correct a calculation error
Publisher name: Department for Business, Energy and Industrial Strategy
Last updated: 2024-06-14T04:01:56Z

Tables

BEIS Headcount And Payroll Data For April 2019

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_april_2019

32.59 kB
16 rows
41 columns

CREATE TABLE beis_headcount_and_payroll_data_for_april_2019 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "ao_aa" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "eo" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "seo_heo" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "scs" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "other_unknown_or_unspecified" VARCHAR  -- Other, Unknown, Or Unspecified,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "agency_staff_clerical_admin" VARCHAR  -- Agency Staff (clerical/admin),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "total" VARCHAR,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total" VARCHAR,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" VARCHAR  -- Total Monthly Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" VARCHAR  -- Total Non-payroll (CCL) Staff Costs,
  "total_costs" VARCHAR,
  "unnamed_40" VARCHAR  -- Unnamed: 40
);

BEIS Headcount And Payroll Data For August 2022

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_august_2022

43.46 kB
15 rows
46 columns

CREATE TABLE beis_headcount_and_payroll_data_for_august_2022 (
  "year_month_organisation_name_organisation_type_main_pa_eca2c681" VARCHAR  -- Year,Month,Organisation Name,Organisation Type,"Main , Parent Or Sponsoring Department",Payroll Staff,
  "n__ao_aa" VARCHAR  -- AO/AA,
  "n__headcount_payroll_staff" VARCHAR  -- Headcount,Payroll Staff,
  "n__ao_aa_1" VARCHAR  -- AO/AA.1,
  "n__full_time_equivalent_payroll_staff" VARCHAR  -- Full-Time Equivalent,Payroll Staff,
  "n__eo" VARCHAR  -- EO,
  "n__headcount_payroll_staff_1" VARCHAR  -- Headcount,Payroll Staff.1,
  "n__eo_1" VARCHAR  -- EO.1,
  "n__full_time_equivalent_payroll_staff_1" VARCHAR  -- Full-Time Equivalent,Payroll Staff.1,
  "n__seo_heo" VARCHAR  -- SEO/HEO,
  "n__headcount_payroll_staff_2" VARCHAR  -- Headcount,Payroll Staff.2,
  "n__seo_heo_1" VARCHAR  -- SEO/HEO.1,
  "n__full_time_equivalent_payroll_staff_2" VARCHAR  -- Full-Time Equivalent,Payroll Staff.2,
  "n__grade_6_7" VARCHAR  -- Grade 6/7,
  "n__headcount_payroll_staff_3" VARCHAR  -- Headcount,Payroll Staff.3,
  "n__grade_6_7_1" VARCHAR  -- Grade 6/7.1,
  "n__full_time_equivalent_payroll_staff_3" VARCHAR  -- Full-Time Equivalent,Payroll Staff.3,
  "n__scs" VARCHAR  -- SCS,
  "n__headcount_payroll_staff_4" VARCHAR  -- Headcount,Payroll Staff.4,
  "n__scs_1" VARCHAR  -- SCS.1,
  "n__full_time_equivalent_payroll_staff_dae313" VARCHAR  -- Full-Time Equivalent,"Payroll Staff,
  "n__other_unknown_unspecified" VARCHAR  -- Other, Unknown, Unspecified,
  "n__headcount_payroll_staff_dd2868" VARCHAR  -- Headcount","Payroll Staff,
  "n__other_unknown_unspecified_1" VARCHAR  -- Other, Unknown, Unspecified.1,
  "n__full_time_equivalent_payroll_staff_total" VARCHAR  -- Full-Time Equivalent","Payroll Staff, Total,
  "n__headcount_payroll_staff_total" VARCHAR  -- Headcount","Payroll Staff, Total,
  "n__full_time_equivalent_non_payroll_staff_admin_and_clerical" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Admin And Clerical,
  "n__headcount_non_payroll_staff_admin_and_clerical" VARCHAR  -- Headcount","Non-payroll Staff, Admin And Clerical,
  "n__full_time_equivalent_non_payroll_staff_interim_mana_80f03fe8" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Interim Managers, Specialist Contractors & Medical,
  "n__headcount_non_payroll_staff_interim_managers_specia_f6c3b61e" VARCHAR  -- Headcount","Non-payroll Staff, Interim Managers, Specialist Contractors & Medical,
  "n__full_time_equivalent_non_payroll_staff_other_contin_794ee171" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Other Contingent Labour,
  "n__headcount_non_payroll_staff_other_contingent_labour" VARCHAR  -- Headcount","Non-payroll Staff, Other Contingent Labour,
  "n__full_time_equivalent_non_payroll_staff_total_contin_076a015a" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Total Contingent Labour, Headcount","Non-payroll Staff, Total Contingent Labour, Full-Time Equivalent","Non-payroll Staff, Consultancy,
  "n__number_of_contracts_grand_total_workforce_numbers" VARCHAR  -- Number Of Contracts",Grand Total (workforce Numbers),
  "n__headcount_grand_total_workforce_numbers" VARCHAR  -- Headcount,Grand Total (workforce Numbers),
  "n__full_time_equivalent_payroll_staff_costs" VARCHAR  -- Full-Time Equivalent,Payroll Staff Costs,
  "n__salary_payroll_staff_costs" VARCHAR  -- Salary,Payroll Staff Costs,
  "n__allowances_payroll_staff_costs" VARCHAR  -- Allowances,Payroll Staff Costs,
  "n__non_consolidated_performance_payments_payroll_staff_costs" VARCHAR  -- Non-Consolidated Performance Payments,Payroll Staff Costs,
  "n__overtime_payroll_staff_costs" VARCHAR  -- Overtime,Payroll Staff Costs,
  "n__employer_pension_contributions_payroll_staff_costs" VARCHAR  -- Employer Pension Contributions,Payroll Staff Costs,
  "n__employer_national_insurance_contributions_payroll_s_7d731fba" VARCHAR  -- Employer National Insurance Contributions,Payroll Staff Costs,
  "n__total_paybill_non_payroll_staff_costs" VARCHAR  -- Total Paybill,Non-Payroll Staff Costs,
  "n__contingent_labour_non_payroll_staff_costs" VARCHAR  -- Contingent Labour,Non-Payroll Staff Costs,
  "n__consultancy_non_payroll_staff_costs" VARCHAR  -- Consultancy,Non-Payroll Staff Costs,
  "n__total_staff_costs_grand_total_paybill_staffing_payr_1e69f81c" VARCHAR  -- Total Staff Costs,Grand Total Paybill/staffing (payroll And Non-payroll) Costs,Notes
);

BEIS Headcount And Payroll Data For December 2018

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_december_2018

33.46 kB
16 rows
41 columns

CREATE TABLE beis_headcount_and_payroll_data_for_december_2018 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "ao_aa" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "eo" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "seo_heo" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "scs" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "other_unknown_or_unspecified" VARCHAR  -- Other, Unknown, Or Unspecified,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "agency_staff_clerical_admin" VARCHAR  -- Agency Staff (clerical/admin),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "total" VARCHAR,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total" VARCHAR,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" VARCHAR  -- Total Monthly Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" VARCHAR  -- Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/Staffing (payroll And Non-payroll) Costs,
  "notes" VARCHAR
);

BEIS Headcount And Payroll Data For December 2019

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_december_2019

32.82 kB
16 rows
40 columns

CREATE TABLE beis_headcount_and_payroll_data_for_december_2019 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "ao_aa" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "eo" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "seo_heo" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "scs" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "other_fast_streamers_beis_paid_unknown_or_unspecified" VARCHAR  -- Other,Fast Streamers -BEIS Paid, Unknown, Or Unspecified,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "agency_staff_clerical_admin" VARCHAR  -- Agency Staff (clerical/admin),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "total" VARCHAR,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total" VARCHAR,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" VARCHAR  -- Total Monthly Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" VARCHAR  -- Total Non-payroll (CCL) Staff Costs,
  "total_costs" VARCHAR
);

BEIS Headcount And Payroll Data For February 2019

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_february_2019

32.72 kB
16 rows
41 columns

CREATE TABLE beis_headcount_and_payroll_data_for_february_2019 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "ao_aa" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "eo" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "seo_heo" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "scs" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "other_unknown_or_unspecified" VARCHAR  -- Other, Unknown, Or Unspecified,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "agency_staff_clerical_admin" VARCHAR  -- Agency Staff (clerical/admin),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "total" VARCHAR,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total" VARCHAR,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" VARCHAR  -- Total Monthly Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" VARCHAR  -- Total Non-payroll (CCL) Staff Costs,
  "total_costs" VARCHAR,
  "unnamed_40" VARCHAR  -- Unnamed: 40
);

BEIS Headcount And Payroll Data For January 2019

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_january_2019

33.4 kB
16 rows
42 columns

CREATE TABLE beis_headcount_and_payroll_data_for_january_2019 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "ao_aa" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "eo" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "seo_heo" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "scs" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "other_unknown_or_unspecified" VARCHAR  -- Other, Unknown, Or Unspecified,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "agency_staff_clerical_admin" VARCHAR  -- Agency Staff (clerical/admin),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "total" VARCHAR,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total" VARCHAR,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" VARCHAR  -- Total Monthly Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" VARCHAR  -- Total Non-payroll (CCL) Staff Costs,
  "total_costs" VARCHAR,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

BEIS Headcount And Payroll Data For July 2023

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_july_2023

42.21 kB
15 rows
46 columns

CREATE TABLE beis_headcount_and_payroll_data_for_july_2023 (
  "year_month_organisation_name_organisation_type_main_pa_eca2c681" VARCHAR  -- Year,Month,Organisation Name,Organisation Type,"Main , Parent Or Sponsoring Department",Payroll Staff,
  "n__ao_aa" VARCHAR  -- AO/AA,
  "n__headcount_payroll_staff" VARCHAR  -- Headcount,Payroll Staff,
  "n__ao_aa_1" VARCHAR  -- AO/AA.1,
  "n__full_time_equivalent_payroll_staff" VARCHAR  -- Full-Time Equivalent,Payroll Staff,
  "n__eo" VARCHAR  -- EO,
  "n__headcount_payroll_staff_1" VARCHAR  -- Headcount,Payroll Staff.1,
  "n__eo_1" VARCHAR  -- EO.1,
  "n__full_time_equivalent_payroll_staff_1" VARCHAR  -- Full-Time Equivalent,Payroll Staff.1,
  "n__seo_heo" VARCHAR  -- SEO/HEO,
  "n__headcount_payroll_staff_2" VARCHAR  -- Headcount,Payroll Staff.2,
  "n__seo_heo_1" VARCHAR  -- SEO/HEO.1,
  "n__full_time_equivalent_payroll_staff_2" VARCHAR  -- Full-Time Equivalent,Payroll Staff.2,
  "n__grade_6_7" VARCHAR  -- Grade 6/7,
  "n__headcount_payroll_staff_3" VARCHAR  -- Headcount,Payroll Staff.3,
  "n__grade_6_7_1" VARCHAR  -- Grade 6/7.1,
  "n__full_time_equivalent_payroll_staff_3" VARCHAR  -- Full-Time Equivalent,Payroll Staff.3,
  "n__scs" VARCHAR  -- SCS,
  "n__headcount_payroll_staff_4" VARCHAR  -- Headcount,Payroll Staff.4,
  "n__scs_1" VARCHAR  -- SCS.1,
  "n__full_time_equivalent_payroll_staff_dae313" VARCHAR  -- Full-Time Equivalent,"Payroll Staff,
  "n__other_unknown_unspecified" VARCHAR  -- Other, Unknown, Unspecified,
  "n__headcount_payroll_staff_dd2868" VARCHAR  -- Headcount","Payroll Staff,
  "n__other_unknown_unspecified_1" VARCHAR  -- Other, Unknown, Unspecified.1,
  "n__full_time_equivalent_payroll_staff_total" VARCHAR  -- Full-Time Equivalent","Payroll Staff, Total,
  "n__headcount_payroll_staff_total" VARCHAR  -- Headcount","Payroll Staff, Total,
  "n__full_time_equivalent_non_payroll_staff_admin_and_clerical" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Admin And Clerical,
  "n__headcount_non_payroll_staff_admin_and_clerical" VARCHAR  -- Headcount","Non-payroll Staff, Admin And Clerical,
  "n__full_time_equivalent_non_payroll_staff_interim_mana_80f03fe8" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Interim Managers, Specialist Contractors & Medical,
  "n__headcount_non_payroll_staff_interim_managers_specia_f6c3b61e" VARCHAR  -- Headcount","Non-payroll Staff, Interim Managers, Specialist Contractors & Medical,
  "n__full_time_equivalent_non_payroll_staff_other_contin_794ee171" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Other Contingent Labour,
  "n__headcount_non_payroll_staff_other_contingent_labour" VARCHAR  -- Headcount","Non-payroll Staff, Other Contingent Labour,
  "n__full_time_equivalent_non_payroll_staff_total_contin_076a015a" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Total Contingent Labour, Headcount","Non-payroll Staff, Total Contingent Labour, Full-Time Equivalent","Non-payroll Staff, Consultancy,
  "n__number_of_contracts_grand_total_workforce_numbers" VARCHAR  -- Number Of Contracts",Grand Total (workforce Numbers),
  "n__headcount_grand_total_workforce_numbers" VARCHAR  -- Headcount,Grand Total (workforce Numbers),
  "n__full_time_equivalent_payroll_staff_costs" VARCHAR  -- Full-Time Equivalent,Payroll Staff Costs,
  "n__salary_payroll_staff_costs" VARCHAR  -- Salary,Payroll Staff Costs,
  "n__allowances_payroll_staff_costs" VARCHAR  -- Allowances,Payroll Staff Costs,
  "n__non_consolidated_performance_payments_payroll_staff_costs" VARCHAR  -- Non-Consolidated Performance Payments,Payroll Staff Costs,
  "n__overtime_payroll_staff_costs" VARCHAR  -- Overtime,Payroll Staff Costs,
  "n__employer_pension_contributions_payroll_staff_costs" VARCHAR  -- Employer Pension Contributions,Payroll Staff Costs,
  "n__employer_national_insurance_contributions_payroll_s_7d731fba" VARCHAR  -- Employer National Insurance Contributions,Payroll Staff Costs,
  "n__total_paybill_non_payroll_staff_costs" VARCHAR  -- Total Paybill,Non-Payroll Staff Costs,
  "n__contingent_labour_non_payroll_staff_costs" VARCHAR  -- Contingent Labour,Non-Payroll Staff Costs,
  "n__consultancy_non_payroll_staff_costs" VARCHAR  -- Consultancy,Non-Payroll Staff Costs,
  "n__total_staff_costs_grand_total_paybill_staffing_payr_e3520fba" VARCHAR  -- Total Staff Costs,Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
);

BEIS Headcount And Payroll Data For June 2019

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_june_2019

33.48 kB
16 rows
41 columns

CREATE TABLE beis_headcount_and_payroll_data_for_june_2019 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "ao_aa" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "eo" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "seo_heo" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "scs" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "other_unknown_or_unspecified" VARCHAR  -- Other, Unknown, Or Unspecified,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "agency_staff_clerical_admin" VARCHAR  -- Agency Staff (clerical/admin),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "total" VARCHAR,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total" VARCHAR,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" VARCHAR  -- Total Monthly Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" VARCHAR  -- Total Non-payroll (CCL) Staff Costs,
  "total_costs" VARCHAR,
  "unnamed_40" VARCHAR  -- Unnamed: 40
);

BEIS Headcount And Payroll Data For June 2023

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_june_2023

42.28 kB
15 rows
46 columns

CREATE TABLE beis_headcount_and_payroll_data_for_june_2023 (
  "year_month_organisation_name_organisation_type_main_pa_eca2c681" VARCHAR  -- Year,Month,Organisation Name,Organisation Type,"Main , Parent Or Sponsoring Department",Payroll Staff,
  "n__ao_aa" VARCHAR  -- AO/AA,
  "n__headcount_payroll_staff" VARCHAR  -- Headcount,Payroll Staff,
  "n__ao_aa_1" VARCHAR  -- AO/AA.1,
  "n__full_time_equivalent_payroll_staff" VARCHAR  -- Full-Time Equivalent,Payroll Staff,
  "n__eo" VARCHAR  -- EO,
  "n__headcount_payroll_staff_1" VARCHAR  -- Headcount,Payroll Staff.1,
  "n__eo_1" VARCHAR  -- EO.1,
  "n__full_time_equivalent_payroll_staff_1" VARCHAR  -- Full-Time Equivalent,Payroll Staff.1,
  "n__seo_heo" VARCHAR  -- SEO/HEO,
  "n__headcount_payroll_staff_2" VARCHAR  -- Headcount,Payroll Staff.2,
  "n__seo_heo_1" VARCHAR  -- SEO/HEO.1,
  "n__full_time_equivalent_payroll_staff_2" VARCHAR  -- Full-Time Equivalent,Payroll Staff.2,
  "n__grade_6_7" VARCHAR  -- Grade 6/7,
  "n__headcount_payroll_staff_3" VARCHAR  -- Headcount,Payroll Staff.3,
  "n__grade_6_7_1" VARCHAR  -- Grade 6/7.1,
  "n__full_time_equivalent_payroll_staff_3" VARCHAR  -- Full-Time Equivalent,Payroll Staff.3,
  "n__scs" VARCHAR  -- SCS,
  "n__headcount_payroll_staff_4" VARCHAR  -- Headcount,Payroll Staff.4,
  "n__scs_1" VARCHAR  -- SCS.1,
  "n__full_time_equivalent_payroll_staff_dae313" VARCHAR  -- Full-Time Equivalent,"Payroll Staff,
  "n__other_unknown_unspecified" VARCHAR  -- Other, Unknown, Unspecified,
  "n__headcount_payroll_staff_dd2868" VARCHAR  -- Headcount","Payroll Staff,
  "n__other_unknown_unspecified_1" VARCHAR  -- Other, Unknown, Unspecified.1,
  "n__full_time_equivalent_payroll_staff_total" VARCHAR  -- Full-Time Equivalent","Payroll Staff, Total,
  "n__headcount_payroll_staff_total" VARCHAR  -- Headcount","Payroll Staff, Total,
  "n__full_time_equivalent_non_payroll_staff_admin_and_clerical" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Admin And Clerical,
  "n__headcount_non_payroll_staff_admin_and_clerical" VARCHAR  -- Headcount","Non-payroll Staff, Admin And Clerical,
  "n__full_time_equivalent_non_payroll_staff_interim_mana_80f03fe8" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Interim Managers, Specialist Contractors & Medical,
  "n__headcount_non_payroll_staff_interim_managers_specia_f6c3b61e" VARCHAR  -- Headcount","Non-payroll Staff, Interim Managers, Specialist Contractors & Medical,
  "n__full_time_equivalent_non_payroll_staff_other_contin_794ee171" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Other Contingent Labour,
  "n__headcount_non_payroll_staff_other_contingent_labour" VARCHAR  -- Headcount","Non-payroll Staff, Other Contingent Labour,
  "n__full_time_equivalent_non_payroll_staff_total_contin_076a015a" VARCHAR  -- Full-Time Equivalent","Non-payroll Staff, Total Contingent Labour, Headcount","Non-payroll Staff, Total Contingent Labour, Full-Time Equivalent","Non-payroll Staff, Consultancy,
  "n__number_of_contracts_grand_total_workforce_numbers" VARCHAR  -- Number Of Contracts",Grand Total (workforce Numbers),
  "n__headcount_grand_total_workforce_numbers" VARCHAR  -- Headcount,Grand Total (workforce Numbers),
  "n__full_time_equivalent_payroll_staff_costs" VARCHAR  -- Full-Time Equivalent,Payroll Staff Costs,
  "n__salary_payroll_staff_costs" VARCHAR  -- Salary,Payroll Staff Costs,
  "n__allowances_payroll_staff_costs" VARCHAR  -- Allowances,Payroll Staff Costs,
  "n__non_consolidated_performance_payments_payroll_staff_costs" VARCHAR  -- Non-Consolidated Performance Payments,Payroll Staff Costs,
  "n__overtime_payroll_staff_costs" VARCHAR  -- Overtime,Payroll Staff Costs,
  "n__employer_pension_contributions_payroll_staff_costs" VARCHAR  -- Employer Pension Contributions,Payroll Staff Costs,
  "n__employer_national_insurance_contributions_payroll_s_7d731fba" VARCHAR  -- Employer National Insurance Contributions,Payroll Staff Costs,
  "n__total_paybill_non_payroll_staff_costs" VARCHAR  -- Total Paybill,Non-Payroll Staff Costs,
  "n__contingent_labour_non_payroll_staff_costs" VARCHAR  -- Contingent Labour,Non-Payroll Staff Costs,
  "n__consultancy_non_payroll_staff_costs" VARCHAR  -- Consultancy,Non-Payroll Staff Costs,
  "n__total_staff_costs_grand_total_paybill_staffing_payr_e3520fba" VARCHAR  -- Total Staff Costs,Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
);

BEIS Headcount And Payroll Data For March 2019

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_march_2019

32.57 kB
15 rows
41 columns

CREATE TABLE beis_headcount_and_payroll_data_for_march_2019 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "ao_aa" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "eo" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "seo_heo" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "scs" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "other_unknown_or_unspecified" VARCHAR  -- Other, Unknown, Or Unspecified,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "agency_staff_clerical_admin" VARCHAR  -- Agency Staff (clerical/admin),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "total" VARCHAR,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total" VARCHAR,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" VARCHAR  -- Total Monthly Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" VARCHAR  -- Total Non-payroll (CCL) Staff Costs,
  "total_costs" VARCHAR,
  "unnamed_40" VARCHAR  -- Unnamed: 40
);

BEIS Headcount And Payroll Data For May 2019

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_may_2019

34.34 kB
16 rows
42 columns

CREATE TABLE beis_headcount_and_payroll_data_for_may_2019 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "ao_aa" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "eo" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "seo_heo" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "scs" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "other_unknown_or_unspecified" VARCHAR  -- Other, Unknown, Or Unspecified,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "agency_staff_clerical_admin" VARCHAR  -- Agency Staff (clerical/admin),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "total" VARCHAR,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total" VARCHAR,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" VARCHAR  -- Total Monthly Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" VARCHAR  -- Total Non-payroll (CCL) Staff Costs,
  "total_costs" VARCHAR,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

BEIS Headcount And Payroll Data For November 2018

@ukgov.beis_workforce_management_information.beis_headcount_and_payroll_data_for_november_2018

33.65 kB
16 rows
41 columns

CREATE TABLE beis_headcount_and_payroll_data_for_november_2018 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "ao_aa" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "eo" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "seo_heo" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "scs" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "other_unknown_or_unspecified" VARCHAR  -- Other, Unknown, Or Unspecified,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "agency_staff_clerical_admin" VARCHAR  -- Agency Staff (clerical/admin),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "total" VARCHAR,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total" VARCHAR,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_monthly_cost_of_contingent_labour_agency_clerica_24fed7a0" VARCHAR  -- Total Monthly Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "total_monthly_cost_of_consultants_consultancy" VARCHAR  -- Total Monthly Cost Of Consultants/ Consultancy,
  "total_non_payroll_ccl_staff_costs" VARCHAR  -- Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/Staffing (payroll And Non-payroll) Costs,
  "unnamed_40" VARCHAR  -- Unnamed: 40
);

BEIS: Workforce Management Information

@ukgov.beis_workforce_management_information.beis_workforce_management_information

33.21 kB
25 rows
41 columns

CREATE TABLE beis_workforce_management_information (
  "aug_18" VARCHAR,
  "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
);