About this Dataset

Organogram Of Staff Roles And Salaries For Institute For Apprenticeships And Technical Education June 2022

Organogram (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: 2022-08-16T14:20:22Z

Tables

2022-08-11 Organogram (Junior)

@ukgov.dataset_1.n_2022_08_11_organogram_junior

10.59 KB
113 rows
11 columns


CREATE TABLE n_2022_08_11_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2022-08-11 Organogram (Senior)

@ukgov.dataset_1.n_2022_08_11_organogram_senior

16.31 KB
17 rows
20 columns


CREATE TABLE n_2022_08_11_organogram_senior (
  "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,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);