Workforce Management Information - Ministry Of Justice
Ministry of Justice
@ukgov.workforce_management_information_ministry_of_justice
Ministry of Justice
@ukgov.workforce_management_information_ministry_of_justice
CREATE TABLE workforce_management_information_ministry_of_justice (
"year" BIGINT,
"month" VARCHAR,
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff_ao_aa_headcount" BIGINT,
"payroll_staff_ao_aa_full_time_equivalent" BIGINT,
"payroll_staff_eo_headcount" BIGINT,
"payroll_staff_eo_full_time_equivalent" BIGINT,
"payroll_staff_seo_heo_headcount" BIGINT,
"payroll_staff_seo_heo_full_time_equivalent" BIGINT,
"payroll_staff_grade_6_7_headcount" BIGINT,
"payroll_staff_grade_6_7_full_time_equivalent" BIGINT,
"payroll_staff_scs_headcount" BIGINT,
"payroll_staff_scs_full_time_equivalent" BIGINT,
"payroll_staff_other_unknown_unspecified_headcount" BIGINT,
"payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT,
"payroll_staff_total_headcount" BIGINT,
"payroll_staff_total_full_time_equivalent" BIGINT,
"non_payroll_staff_agency_staff_headcount" BIGINT,
"non_payroll_staff_agency_staff_full_time_equivalent" BIGINT,
"non_payroll_staff_interim_managers_headcount" BIGINT,
"non_payroll_staff_interim_managers_full_time_equivalent" BIGINT,
"non_payroll_staff_specialist_contractors_headcount" BIGINT,
"non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
"non_payroll_staff_consultants_consultancy_headcount" BIGINT,
"non_payroll_staff_consultants_consultancy_full_time_equivalent" BIGINT,
"non_payroll_staff_total_headcount" BIGINT,
"non_payroll_staff_total_full_time_equivalent" BIGINT,
"grand_total_workforce_numbers_headcount" BIGINT,
"grand_total_workforce_numbers_full_time_equivalent" BIGINT,
"payroll_staff_costs_salary" BIGINT,
"payroll_staff_costs_allowances" BIGINT,
"payroll_staff_costs_non_consolidated_performance_payments" BIGINT,
"payroll_staff_costs_overtime" BIGINT,
"payroll_staff_costs_employer_pension_contributions" BIGINT,
"payroll_staff_costs_employer_national_insurance_contributions" BIGINT,
"payroll_staff_costs_total_paybill" BIGINT,
"non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" BIGINT,
"non_payroll_staff_costs_consultants_consultancy" BIGINT,
"non_payroll_staff_costs_total_staff_costs" BIGINT,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" BIGINT,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.