About this Dataset

Workforce Management Information - Ministry Of Justice

Monthly management information on staff numbers and paybill costs in the Ministry of Justice, its agencies and its 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: Ministry of Justice
Last updated: 2024-09-14T23:46:08Z

Tables

Workforce Management Information - Ministry Of Justice

@ukgov.workforce_management_information_ministry_of_justice.workforce_management_information_ministry_of_justice

44.08 kB
13 rows
43 columns

CREATE TABLE workforce_management_information_ministry_of_justice (
  "year" BIGINT,
  "month" VARCHAR,
  "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; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" BIGINT  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" BIGINT  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" BIGINT  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" BIGINT  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" BIGINT  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" BIGINT  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" BIGINT  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" BIGINT  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" BIGINT  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" BIGINT  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" BIGINT  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" BIGINT  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" BIGINT  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" BIGINT  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" BIGINT  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" BIGINT  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" BIGINT  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" BIGINT  -- Non-payroll Staff; Total; Full-time Equivalent,
  "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" BIGINT  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" BIGINT  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" BIGINT  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" BIGINT  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" BIGINT  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" BIGINT  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" BIGINT  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" BIGINT  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" BIGINT  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" BIGINT  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" BIGINT  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);