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

42.03 kB
7 rows
41 columns

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