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: Joint Nature Conservation Committee
Last updated: 2024-09-14T15:10:17Z

Tables

Table 2

@ukgov.organogram_joint_nature_conservation_committee.table_2

9.12 kB
30 rows
10 columns

CREATE TABLE table_2 (
  "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
);

Table 3

@ukgov.organogram_joint_nature_conservation_committee.table_3

14.77 kB
3 rows
18 columns

CREATE TABLE table_3 (
  "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" VARCHAR  -- Salary Cost Of Reports (£),
  "fte" BIGINT,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "total_pay" VARCHAR  -- Total Pay (£),
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR
);