Name: Organogram Of Staff Roles And Salaries For IfATE
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Organogram Of Staff Roles And Salaries For IfATE

Organisation (Organisation Chart) showing all staff roles. Names and Salaries are also listed for the Senior Civil Servants
Publisher name: Institute for Apprenticeships and Technical Education
Last updated: 2023-05-26T04:25:19Z

Tables

2023-05-25 Organogram (Junior)

@ukgov.organogram_may_2023.n_2023_05_25_organogram_junior

10.61 kB
132 rows
11 columns

CREATE TABLE n_2023_05_25_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
);

2023-05-25 Organogram (Senior)

@ukgov.organogram_may_2023.n_2023_05_25_organogram_senior

16.56 kB
18 rows
20 columns

CREATE TABLE n_2023_05_25_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" 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?
);