About this Dataset

NIO Organogram Of Staff Roles & Salaries: June 2022

Organogram (organisation chart) showing all staff roles. Names and salaries are also listed for the Senior Civil Servants. The published data is validated and released in CSV format and OGL-licensed for reuse. For more information about this series, see: http://guidance.data.gov.uk/organogram-data.html
Publisher name: Northern Ireland Office
Last updated: 2024-06-14T04:02:59Z

Tables

Junior Staff: June 2022

@ukgov.nio_organogram_of_staff_roles_salaries_june.junior_staff_june_2022

8.23 kB
185 rows
8 columns

CREATE TABLE junior_staff_june_2022 (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT  -- Payscale Minimum (£),
  "payscale_maximum" BIGINT  -- Payscale Maximum (£),
  "generic_job_title" VARCHAR
);

Senior Staff: June 2022

@ukgov.nio_organogram_of_staff_roles_salaries_june.senior_staff_june_2022

15.46 kB
17 rows
18 columns

CREATE TABLE senior_staff_june_2022 (
  "post_unique_reference" VARCHAR,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR  -- Grade (or Equivalent),
  "job_title" VARCHAR,
  "job_team_function" VARCHAR,
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "contact_phone" VARCHAR,
  "contact_e_mail" VARCHAR,
  "reports_to_senior_post" VARCHAR,
  "salary_cost_of_reports" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "total_pay" VARCHAR  -- Total Pay (£),
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);