About this Dataset

Organogram Of Staff Roles & Salaries

Organogram (organisation chart) showing all staff roles. Names and salaries are also listed for the Senior Civil Servants. Organogram data is released by all central government departments and their agencies since 2010. Snapshots for 31st March and 30th September are published by 6th June and 6th December each year. The published data is validated and released in CSV format and OGL-licensed for reuse. For more information about this series, see: http://guidance.data.gov.uk/organogram-data.html
Publisher name: Animal and Plant Health Agency
Last updated: 2024-09-14T09:26:57Z

Tables

2021-08-09 Organogram (Junior)

@ukgov.organogram_animal_and_plant_health_agency.n_2021_08_09_organogram_junior

9.02 KB
33 rows
10 columns


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

2021-08-09 Organogram (Senior)

@ukgov.organogram_animal_and_plant_health_agency.n_2021_08_09_organogram_senior

14.51 KB
6 rows
19 columns


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

31 March 2019 Organogram (Junior)

@ukgov.organogram_animal_and_plant_health_agency.n_31_march_2019_organogram_junior

9.9 KB
212 rows
10 columns


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

31 March 2019 Organogram (Senior)

@ukgov.organogram_animal_and_plant_health_agency.n_31_march_2019_organogram_senior

14.28 KB
6 rows
19 columns


CREATE TABLE n_31_march_2019_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

Organogram Of Staff Roles & Salaries

@ukgov.organogram_animal_and_plant_health_agency.organogram_of_staff_roles_salaries

9.79 KB
152 rows
10 columns


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