Payroll Costs And Non-consolidated Pay Data In Cabinet Office
Cabinet Office
@ukgov.cabinet_office_payroll_costs_non_consolidated_pay
Cabinet Office
@ukgov.cabinet_office_payroll_costs_non_consolidated_pay
Monthly management information on staff numbers and paybill costs in Cabinet Office & Non-consolidated Performance Related Pay data for Cabinet Office in respect of the performance year 2010-11
Publisher name: Cabinet Office
Last updated: 2024-09-15T11:01:17Z
CREATE TABLE payroll_costs_and_non_consolidated_pay_data_in_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" DOUBLE,
"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" DOUBLE -- 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
);Anyone who has the link will be able to view this.