Name: Organogram Of Staff Roles And Salary Scales
Creator: UK Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

Organogram Of Staff Roles And Salary Scales

Publisher name: UK Health Security Agency
Last updated: 2022-11-20T15:20:58Z

Tables

UKHSA 2022-11-18 Organogram (Junior)

@ukgov.ukhsa_organogram_of_staff_roles.ukhsa_2022_11_18_organogram_junior

59.65 kB
5,018 rows
12 columns

CREATE TABLE ukhsa_2022_11_18_organogram_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,
  "office_region" VARCHAR,
  "valid" BIGINT  -- Valid?
);

UKHSA 2022-11-18 Organogram (Senior)

@ukgov.ukhsa_organogram_of_staff_roles.ukhsa_2022_11_18_organogram_senior

25.63 kB
214 rows
20 columns

CREATE TABLE ukhsa_2022_11_18_organogram_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" VARCHAR  -- Actual Pay Floor (Ł),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (Ł),
  "total_pay" VARCHAR  -- Total Pay (Ł),
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);