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
  • 41.92 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE april_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

August 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.august_2020_fco_workforce_management_information
  • 41.02 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE august_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" 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" 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_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "non_payroll_staff_intermin_managers_headcount" 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_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

December 2019 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.december_2019_fco_workforce_management_information
  • 41.24 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE december_2019_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FCO Workforce Management Information

@ukgov.fco_workforce_management_information.fco_workforce_management_information
  • 41.27 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information (
  "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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

FCO Workforce Management Information April 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_april_2019
  • 42.45 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_april_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FCO Workforce Management Information August 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_august_2019
  • 40.85 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_august_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

FCO Workforce Management Information December 2018

@ukgov.fco_workforce_management_information.fco_workforce_management_information_december_2018
  • 41.21 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_december_2018 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FCO Workforce Management Information Feb 2017

@ukgov.fco_workforce_management_information.fco_workforce_management_information_feb_2017
  • 41.32 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,
  "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_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FCO Workforce Management Information February 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_february_2019
  • 41.2 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_february_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FCO Workforce Management Information January 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_january_2019
  • 41.04 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_january_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

FCO Workforce Management Information July 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_july_2019
  • 41.19 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_july_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FCO Workforce Management Information June 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_june_2019
  • 41.21 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_june_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FCO Workforce Management Information March 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_march_2019
  • 41.21 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_march_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FCO Workforce Management Information November 2018

@ukgov.fco_workforce_management_information.fco_workforce_management_information_november_2018
  • 41.2 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_november_2018 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FCO Workforce Management Information November 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_november_2019
  • 42.59 KB
  • 7 rows
  • 42 columns
Loading... 

CREATE TABLE fco_workforce_management_information_november_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" BIGINT,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR,
  "unnamed_41" VARCHAR
);

FCO Workforce Management Information October 2018

@ukgov.fco_workforce_management_information.fco_workforce_management_information_october_2018
  • 41.22 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_october_2018 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FCO Workforce Management Information October 2019

@ukgov.fco_workforce_management_information.fco_workforce_management_information_october_2019
  • 42.15 KB
  • 7 rows
  • 42 columns
Loading... 

CREATE TABLE fco_workforce_management_information_october_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR,
  "unnamed_41" VARCHAR
);

FCO Workforce Management Information September 2018

@ukgov.fco_workforce_management_information.fco_workforce_management_information_september_2018
  • 40.83 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_management_information_september_2018 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

FCO Workforce Managment Information May 2019

@ukgov.fco_workforce_management_information.fco_workforce_managment_information_may_2019
  • 41.2 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE fco_workforce_managment_information_may_2019 (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "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_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" DOUBLE,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

February 2020 FCO Workforce Information Management

@ukgov.fco_workforce_management_information.february_2020_fco_workforce_information_management
  • 41.26 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE february_2020_fco_workforce_information_management (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" BIGINT,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

February 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.february_2020_fco_workforce_management_information
  • 41.26 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE february_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" BIGINT,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

January 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.january_2020_fco_workforce_management_information
  • 41.22 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE january_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" BIGINT,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

July 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.july_2020_fco_workforce_management_information
  • 41.03 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE july_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" 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" 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_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "non_payroll_staff_intermin_managers_headcount" 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_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

June 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.june_2020_fco_workforce_management_information
  • 41.04 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE june_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" 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" 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_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "non_payroll_staff_intermin_managers_headcount" 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_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR,
  "comments" VARCHAR
);

March 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.march_2020_fco_workforce_management_information
  • 41.3 KB
  • 7 rows
  • 41 columns
Loading... 

CREATE TABLE march_2020_fco_workforce_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" 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_or_unspecified_headcount" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE,
  "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_full_time_equivalent" BIGINT,
  "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_consultants_consultancy" DOUBLE,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

Share link

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