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

May 2020 FCO Workforce Management Information

@ukgov.fco_workforce_management_information.may_2020_fco_workforce_management_information

41.04 KB
7 rows
41 columns


CREATE TABLE may_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
);