Baselight
Sign In

FCO Workforce Management Information

Foreign and Commonwealth Office

@ukgov.fco_workforce_management_information

Loading...
Loading...

About this Dataset

FCO Workforce Management Information

On 1 September the Foreign and Commonwealth Office (FCO) merged with the Department for International Development (DFID) to form Foreign, Commonwealth and Development Office. These data gives details of the workforce management information data for the Foreign and Commonwealth Office. These figures are not official statistics. They are internal workforce management information published in the interests of transparency.
Publisher name: Foreign and Commonwealth Office
Last updated: 2022-07-01T04:02:42Z

Tables

April 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.april_2020_fco_workforce_management_information
  • 42.92 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE april_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

August 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.august_2020_fco_workforce_management_information
  • 42.01 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE august_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" DOUBLE,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

December 2019 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.december_2019_fco_workforce_management_information
  • 42.23 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE december_2019_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information

@ukgov.fco_workforce_management_information.fco_workforce_management_information
  • 42.26 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information April 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_april_2019
  • 43.47 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_april_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information August 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_august_2019
  • 41.83 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_august_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information December 2018

@ukgov.fco_workforce_management_information.fco_workforce_management_information_december_2018
  • 42.2 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_december_2018 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" DOUBLE,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" DOUBLE  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information Feb 2017

@ukgov.fco_workforce_management_information.fco_workforce_management_information_feb_2017
  • 42.31 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_feb_2017 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" DOUBLE,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" DOUBLE  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information February 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_february_2019
  • 42.19 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_february_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information January 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_january_2019
  • 42.02 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_january_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information July 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_july_2019
  • 42.18 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_july_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information June 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_june_2019
  • 42.2 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_june_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information March 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_march_2019
  • 42.2 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_march_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information November 2018

@ukgov.fco_workforce_management_information.fco_workforce_management_information_november_2018
  • 42.19 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_november_2018 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information November 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_november_2019
  • 43.62 kB
  • 7 rows
  • 42 columns
Loading... 
CREATE TABLE fco_workforce_management_information_november_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

FCO Workforce Management Information October 2018

@ukgov.fco_workforce_management_information.fco_workforce_management_information_october_2018
  • 42.21 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_october_2018 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" DOUBLE,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" DOUBLE  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Management Information October 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_october_2019
  • 43.16 kB
  • 7 rows
  • 42 columns
Loading... 
CREATE TABLE fco_workforce_management_information_october_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" DOUBLE,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

FCO Workforce Management Information September 2018

@ukgov.fco_workforce_management_information.fco_workforce_management_information_september_2018
  • 41.81 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_management_information_september_2018 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" DOUBLE,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" DOUBLE  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

FCO Workforce Managment Information May 2019

@ukgov.fco_workforce_management_information.fco_workforce_managment_information_may_2019
  • 42.19 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE fco_workforce_managment_information_may_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

February 2020 FCO Workforce Information Management

@ukgov.fco_workforce_management_information.february_2020_fco_workforce_information_management
  • 42.26 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE february_2020_fco_workforce_information_management (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

February 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.february_2020_fco_workforce_management_information
  • 42.26 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE february_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

January 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.january_2020_fco_workforce_management_information
  • 42.21 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE january_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

July 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.july_2020_fco_workforce_management_information
  • 42.02 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE july_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" DOUBLE,
  "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" DOUBLE,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

June 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.june_2020_fco_workforce_management_information
  • 42.03 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE june_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" DOUBLE,
  "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" DOUBLE,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

March 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.march_2020_fco_workforce_management_information
  • 42.29 kB
  • 7 rows
  • 41 columns
Loading... 
CREATE TABLE march_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "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_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" DOUBLE,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

Share link

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