Workforce Management Information - Cabinet Office
Cabinet Office
@ukgov.workforce_management_information_cabinet_office
Cabinet Office
@ukgov.workforce_management_information_cabinet_office
Monthly management information on staff numbers and paybill costs in Civil Service departments, their agencies and their executive NDPBs. For workforce numbers, both payroll and non-payroll (contingent labour, including consultants) information is provided, split between full-time equivalents (FTE) and headcount, with payroll staff numbers mapped to standard Civil Service grades. For costs, payroll paybill information is broken down into its component parts i.e. salaries, allowances, employers pensions contributions etc. For non-payroll costs, these are split between costs for consultancy and those of other non-payroll workers. Staffing numbers are as at the last day of the month for the reference month. Cost information is that for the reference month. For baseline 2010/11 returns, staffing numbers are as at 31 March 2011, and paybill costs are for the financial year 2010/11.
Publisher name: Cabinet Office
Last updated: 2024-09-14T22:33:50Z
CREATE TABLE workforce_management_information_cabinet_office (
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"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" BIGINT -- 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
);Anyone who has the link will be able to view this.