About this Dataset

Organogram Of Staff Roles & Salaries

Organogram (organisation chart) showing all staff roles. Names and salaries are also listed for the Senior Civil Servants. Organogram data is released by all central government departments and their agencies. 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: National Institute for Health and Care Excellence
Last updated: 2024-09-14T08:54:58Z

Tables

2018/19 Organogram Data (Junior)

@ukgov.organogram_national_institute_for_health_and_care_excellence.n_2018_19_organogram_data_junior

13.97 kB
347 rows
10 columns

CREATE TABLE n_2018_19_organogram_data_junior (
  "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,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR
);

2018/19 Organogram Data (Senior)

@ukgov.organogram_national_institute_for_health_and_care_excellence.n_2018_19_organogram_data_senior

18.64 kB
25 rows
19 columns

CREATE TABLE n_2018_19_organogram_data_senior (
  "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 (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2022-09-30 Organogram (Junior)

@ukgov.organogram_national_institute_for_health_and_care_excellence.n_2022_09_30_organogram_junior

17.75 kB
429 rows
11 columns

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

2022-09-30 Organogram (Senior)

@ukgov.organogram_national_institute_for_health_and_care_excellence.n_2022_09_30_organogram_senior

20.25 kB
25 rows
20 columns

CREATE TABLE n_2022_09_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "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 (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);