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.36 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_maximum" BIGINT,
  "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.17 KB
18 rows
20 columns


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