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.04 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_maximum" BIGINT,
  "generic_job_title" VARCHAR
);

Senior Staff: June 2022

@ukgov.nio_organogram_of_staff_roles_salaries_june.senior_staff_june_2022

15.1 KB
17 rows
18 columns


CREATE TABLE senior_staff_june_2022 (
  "post_unique_reference" VARCHAR,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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,
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT,
  "actual_pay_ceiling" BIGINT,
  "total_pay" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);