Workforce Management Information - HM Revenue & Customs And Valuation Office Agency
HM Revenue and Customs
@ukgov.workforce_management_information_hmrc_voa
HM Revenue and Customs
@ukgov.workforce_management_information_hmrc_voa
CREATE TABLE workforce_management_information_hm_revenue_customs_an_810f58c1 (
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_28" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE workforce_management_information_for_may_2019 (
"may_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_november_2020 (
"nov_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_may_2021 (
"may_21" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_march_2022 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_30" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_january_2020 (
"jan_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_december_2024 (
"year" BIGINT,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" BIGINT,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" BIGINT,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" BIGINT,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" BIGINT,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" BIGINT,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" BIGINT,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT,
"payroll_staff_total_headcount" BIGINT,
"payroll_staff_total_full_time_equivalent" BIGINT,
"non_payroll_staff_admin_and_clerical_headcount" BIGINT,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" BIGINT,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" BIGINT,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" BIGINT,
"non_payroll_staff_other_contingent_labour_headcount" BIGINT,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" BIGINT,
"non_payroll_staff_total_contingent_labour_headcount" BIGINT,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" BIGINT,
"non_payroll_staff_consultancy_number_of_contracts" BIGINT,
"grand_total_workforce_numbers_headcount" BIGINT,
"grand_total_workforce_numbers_full_time_equivalent" BIGINT,
"payroll_staff_costs_salary" VARCHAR,
"payroll_staff_costs_allowances" VARCHAR,
"payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
"payroll_staff_costs_overtime" VARCHAR,
"payroll_staff_costs_employer_pension_contributions" VARCHAR,
"payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
"payroll_staff_costs_total_paybill" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_october_2024 (
"year" BIGINT,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" BIGINT,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" BIGINT,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" BIGINT,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" BIGINT,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" BIGINT,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" BIGINT,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT,
"payroll_staff_total_headcount" BIGINT,
"payroll_staff_total_full_time_equivalent" BIGINT,
"non_payroll_staff_admin_and_clerical_headcount" BIGINT,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" BIGINT,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" BIGINT,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" BIGINT,
"non_payroll_staff_other_contingent_labour_headcount" BIGINT,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" BIGINT,
"non_payroll_staff_total_contingent_labour_headcount" BIGINT,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" BIGINT,
"non_payroll_staff_consultancy_number_of_contracts" BIGINT,
"grand_total_workforce_numbers_headcount" BIGINT,
"grand_total_workforce_numbers_full_time_equivalent" BIGINT,
"payroll_staff_costs_salary" VARCHAR,
"payroll_staff_costs_allowances" VARCHAR,
"payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
"payroll_staff_costs_overtime" VARCHAR,
"payroll_staff_costs_employer_pension_contributions" VARCHAR,
"payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
"payroll_staff_costs_total_paybill" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_may_2020 (
"may_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_april_2020 (
"apr_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_june_2020 (
"jun_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_september_2021 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_30" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"comments_nb_published_alongside_your_row_of_information" VARCHAR
);
CREATE TABLE workforce_management_information_for_august_2024 (
"year" BIGINT,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" BIGINT,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" BIGINT,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" BIGINT,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" BIGINT,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" BIGINT,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" BIGINT,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT,
"payroll_staff_total_headcount" BIGINT,
"payroll_staff_total_full_time_equivalent" BIGINT,
"non_payroll_staff_admin_and_clerical_headcount" BIGINT,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" BIGINT,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" BIGINT,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" BIGINT,
"non_payroll_staff_other_contingent_labour_headcount" BIGINT,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" BIGINT,
"non_payroll_staff_total_contingent_labour_headcount" BIGINT,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" BIGINT,
"non_payroll_staff_consultancy_number_of_contracts" BIGINT,
"grand_total_workforce_numbers_headcount" BIGINT,
"grand_total_workforce_numbers_full_time_equivalent" BIGINT,
"payroll_staff_costs_salary" VARCHAR,
"payroll_staff_costs_allowances" VARCHAR,
"payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
"payroll_staff_costs_overtime" VARCHAR,
"payroll_staff_costs_employer_pension_contributions" VARCHAR,
"payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
"payroll_staff_costs_total_paybill" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_april_2021 (
"apr_21" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_december_2020 (
"nov_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_september_2019 (
"sep_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_july_2019 (
"jul_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_march_2020 (
"mar_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_july_2022 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" DOUBLE,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" DOUBLE,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" DOUBLE,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" DOUBLE,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" DOUBLE,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" DOUBLE,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE,
"payroll_staff_total_headcount" DOUBLE,
"payroll_staff_total_full_time_equivalent" DOUBLE,
"non_payroll_staff_admin_and_clerical_headcount" DOUBLE,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" DOUBLE,
"non_payroll_staff_other_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_total_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_consultancy_number_of_contracts" DOUBLE,
"grand_total_workforce_numbers_headcount" DOUBLE,
"grand_total_workforce_numbers_full_time_equivalent" DOUBLE,
"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" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR
);
CREATE TABLE workforce_management_information_for_may_2022 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" DOUBLE,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" DOUBLE,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" DOUBLE,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" DOUBLE,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" DOUBLE,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" DOUBLE,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE,
"payroll_staff_total_headcount" DOUBLE,
"payroll_staff_total_full_time_equivalent" DOUBLE,
"non_payroll_staff_admin_and_clerical_headcount" DOUBLE,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" DOUBLE,
"non_payroll_staff_other_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_total_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_consultancy_number_of_contracts" DOUBLE,
"grand_total_workforce_numbers_headcount" DOUBLE,
"grand_total_workforce_numbers_full_time_equivalent" DOUBLE,
"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" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR
);
CREATE TABLE workforce_management_information_for_january_2021 (
"jan_21" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_february_2019 (
"feb_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_september_2020 (
"sep_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_december_2019 (
"dec_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_june_2021 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_30" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"comments_nb_published_alongside_your_row_of_information" VARCHAR
);
CREATE TABLE workforce_management_information_for_february_2020 (
"feb_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_june_2019 (
"jun_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_august_2019 (
"aug_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_august_2022 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" DOUBLE,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" DOUBLE,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" DOUBLE,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" DOUBLE,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" DOUBLE,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" DOUBLE,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE,
"payroll_staff_total_headcount" DOUBLE,
"payroll_staff_total_full_time_equivalent" DOUBLE,
"non_payroll_staff_admin_and_clerical_headcount" DOUBLE,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" DOUBLE,
"non_payroll_staff_other_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_total_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_consultancy_number_of_contracts" DOUBLE,
"grand_total_workforce_numbers_headcount" DOUBLE,
"grand_total_workforce_numbers_full_time_equivalent" DOUBLE,
"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" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR
);
CREATE TABLE workforce_management_information_for_august_2020 (
"aug_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_november_2019 (
"nov_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_october_2019 (
"oct_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_september_2024 (
"year" BIGINT,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" BIGINT,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" BIGINT,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" BIGINT,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" BIGINT,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" BIGINT,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" BIGINT,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT,
"payroll_staff_total_headcount" BIGINT,
"payroll_staff_total_full_time_equivalent" BIGINT,
"non_payroll_staff_admin_and_clerical_headcount" BIGINT,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" BIGINT,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" BIGINT,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" BIGINT,
"non_payroll_staff_other_contingent_labour_headcount" BIGINT,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" BIGINT,
"non_payroll_staff_total_contingent_labour_headcount" BIGINT,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" BIGINT,
"non_payroll_staff_consultancy_number_of_contracts" BIGINT,
"grand_total_workforce_numbers_headcount" BIGINT,
"grand_total_workforce_numbers_full_time_equivalent" BIGINT,
"payroll_staff_costs_salary" VARCHAR,
"payroll_staff_costs_allowances" VARCHAR,
"payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
"payroll_staff_costs_overtime" VARCHAR,
"payroll_staff_costs_employer_pension_contributions" VARCHAR,
"payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
"payroll_staff_costs_total_paybill" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_october_2021 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_30" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_january_2019 (
"jan_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_july_2021 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_30" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"comments_nb_published_alongside_your_row_of_information" VARCHAR
);
CREATE TABLE workforce_management_information_for_february_2022 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_30" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_december_2021 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_30" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_october_2020 (
"oct_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_september_2022 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" DOUBLE,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" DOUBLE,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" DOUBLE,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" DOUBLE,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" DOUBLE,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" DOUBLE,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE,
"payroll_staff_total_headcount" DOUBLE,
"payroll_staff_total_full_time_equivalent" DOUBLE,
"non_payroll_staff_admin_and_clerical_headcount" DOUBLE,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" DOUBLE,
"non_payroll_staff_other_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_total_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_consultancy_number_of_contracts" DOUBLE,
"grand_total_workforce_numbers_headcount" DOUBLE,
"grand_total_workforce_numbers_full_time_equivalent" DOUBLE,
"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" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR
);
CREATE TABLE workforce_management_information_for_january_2022 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_30" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_december_2018 (
"dec_18" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_april_2022 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" DOUBLE,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" DOUBLE,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" DOUBLE,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" DOUBLE,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" DOUBLE,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" DOUBLE,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE,
"payroll_staff_total_headcount" DOUBLE,
"payroll_staff_total_full_time_equivalent" DOUBLE,
"non_payroll_staff_admin_and_clerical_headcount" DOUBLE,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" DOUBLE,
"non_payroll_staff_other_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_total_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_consultancy_number_of_contracts" DOUBLE,
"grand_total_workforce_numbers_headcount" DOUBLE,
"grand_total_workforce_numbers_full_time_equivalent" DOUBLE,
"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" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR
);
CREATE TABLE workforce_management_information_for_november_2021 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_30" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_july_2020 (
"jul_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_march_2019 (
"mar_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_august_2021 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_30" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"comments_nb_published_alongside_your_row_of_information" VARCHAR
);
CREATE TABLE workforce_management_information_for_march_2021 (
"mar_21" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_february_2021 (
"feb_21" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_april_2019 (
"apr_19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR
);
CREATE TABLE workforce_management_information_for_july_2024 (
"year" BIGINT,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" BIGINT,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" BIGINT,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" BIGINT,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" BIGINT,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" BIGINT,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" BIGINT,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT,
"payroll_staff_total_headcount" BIGINT,
"payroll_staff_total_full_time_equivalent" BIGINT,
"non_payroll_staff_admin_and_clerical_headcount" BIGINT,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" BIGINT,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" BIGINT,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" BIGINT,
"non_payroll_staff_other_contingent_labour_headcount" BIGINT,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" BIGINT,
"non_payroll_staff_total_contingent_labour_headcount" BIGINT,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" BIGINT,
"non_payroll_staff_consultancy_number_of_contracts" BIGINT,
"grand_total_workforce_numbers_headcount" BIGINT,
"grand_total_workforce_numbers_full_time_equivalent" BIGINT,
"payroll_staff_costs_salary" VARCHAR,
"payroll_staff_costs_allowances" VARCHAR,
"payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
"payroll_staff_costs_overtime" VARCHAR,
"payroll_staff_costs_employer_pension_contributions" VARCHAR,
"payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
"payroll_staff_costs_total_paybill" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR
);
CREATE TABLE workforce_management_information_for_june_2022 (
"year" DOUBLE,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" DOUBLE,
"payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
"payroll_staff_eo_headcount" DOUBLE,
"payroll_staff_eo_full_time_equivalent" DOUBLE,
"payroll_staff_seo_heo_headcount" DOUBLE,
"payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
"payroll_staff_grade_6_7_headcount" DOUBLE,
"payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
"payroll_staff_scs_headcount" DOUBLE,
"payroll_staff_scs_full_time_equivalent" DOUBLE,
"payroll_staff_other_unknown_unspecified_headcount" DOUBLE,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE,
"payroll_staff_total_headcount" DOUBLE,
"payroll_staff_total_full_time_equivalent" DOUBLE,
"non_payroll_staff_admin_and_clerical_headcount" DOUBLE,
"non_payroll_staff_admin_and_clerical_full_time_equivalent" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_3714f708" DOUBLE,
"non_payroll_staff_interim_managers_specialist_contract_4752efd2" DOUBLE,
"non_payroll_staff_other_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_other_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_total_contingent_labour_headcount" DOUBLE,
"non_payroll_staff_total_contingent_labour_full_time_equivalent" DOUBLE,
"non_payroll_staff_consultancy_number_of_contracts" DOUBLE,
"grand_total_workforce_numbers_headcount" DOUBLE,
"grand_total_workforce_numbers_full_time_equivalent" DOUBLE,
"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" VARCHAR,
"non_payroll_staff_costs_contingent_labour" VARCHAR,
"non_payroll_staff_costs_consultancy" VARCHAR,
"non_payroll_staff_costs_total_staff_costs" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR
);
Anyone who has the link will be able to view this.