About this Dataset

Organogram Of Staff Roles And Salaries For IfATE June 2023

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-08-30T04:00:02Z

Tables

2023-07-31 Organogram (Junior)

@ukgov.organogram_of_staff_roles.n_2023_07_31_organogram_junior

10.35 KB
134 rows
11 columns


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

2023-07-31 Organogram (Senior)

@ukgov.organogram_of_staff_roles.n_2023_07_31_organogram_senior

16.14 KB
17 rows
20 columns


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