Baselight
Sign In

CPS Organograms Of Staff Roles & Salaries

Crown Prosecution Service

@ukgov.organogram_crown_prosecution_service

Loading...
Loading...

About this Dataset

CPS Organograms 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: Crown Prosecution Service
Last updated: 2024-09-07T04:00:05Z

Tables

Crown Prosecution Service Organogram March 2015

@ukgov.organogram_crown_prosecution_service.crown_prosecution_service_organogram_march_2015
  • 34.75 kB
  • 29,999 rows
  • 42 columns
Loading... 
CREATE TABLE crown_prosecution_service_organogram_march_2015 (
  "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" DOUBLE  -- Salary Cost Of Reports (ś),
  "fte" VARCHAR,
  "actual_pay_floor" VARCHAR  -- Actual Pay Floor (ś),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (ś),
  "total_pay" VARCHAR  -- Total Pay (ś),
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE  -- Valid?,
  "a_has_errors" VARCHAR  -- A Has Errors?,
  "b_has_errors" VARCHAR  -- B Has Errors?,
  "c_has_errors" VARCHAR  -- C Has Errors?,
  "d_has_errors" VARCHAR  -- D Has Errors?,
  "e_has_errors" VARCHAR  -- E Has Errors?,
  "f_has_errors" VARCHAR  -- F Has Errors?,
  "g_has_errors" VARCHAR  -- G Has Errors?,
  "h_has_errors" VARCHAR  -- H Has Errors?,
  "i_has_errors" VARCHAR  -- I Has Errors?,
  "j_has_errors" VARCHAR  -- J Has Errors?,
  "k_has_errors" VARCHAR  -- K Has Errors?,
  "l_has_errors" VARCHAR  -- L Has Errors?,
  "m_has_errors" VARCHAR  -- M Has Errors?,
  "n_has_errors" VARCHAR  -- N Has Errors?,
  "p_has_errors" VARCHAR  -- P Has Errors?,
  "q_has_errors" VARCHAR  -- Q Has Errors?,
  "row_has_errors" VARCHAR  -- Row Has Errors?,
  "valid_as_number" DOUBLE,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "a_valid" VARCHAR  -- A Valid?,
  "j_valid" VARCHAR  -- J Valid?,
  "text_value" VARCHAR,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

2020-03-31 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2020_03_31_organogram_junior
  • 18.35 kB
  • 1,113 rows
  • 10 columns
Loading... 
CREATE TABLE n_2020_03_31_organogram_junior (
  "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
);

2020-03-31 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_2020_03_31_organogram_senior
  • 25.86 kB
  • 93 rows
  • 19 columns
Loading... 
CREATE TABLE n_2020_03_31_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2021-03-31 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2021_03_31_organogram_junior
  • 19.03 kB
  • 1,205 rows
  • 10 columns
Loading... 
CREATE TABLE n_2021_03_31_organogram_junior (
  "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
);

2021-03-31 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_2021_03_31_organogram_senior
  • 24.48 kB
  • 86 rows
  • 19 columns
Loading... 
CREATE TABLE n_2021_03_31_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2021-09-30 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2021_09_30_organogram_junior
  • 20.05 kB
  • 1,216 rows
  • 11 columns
Loading... 
CREATE TABLE n_2021_09_30_organogram_junior (
  "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,
  "office_region" VARCHAR
);

2021-09-30 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_2021_09_30_organogram_senior
  • 25.48 kB
  • 86 rows
  • 20 columns
Loading... 
CREATE TABLE n_2021_09_30_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2022-03-31 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2022_03_31_organogram_junior
  • 20.91 kB
  • 1,457 rows
  • 11 columns
Loading... 
CREATE TABLE n_2022_03_31_organogram_junior (
  "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,
  "office_region" VARCHAR
);

2022-03-31 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_2022_03_31_organogram_senior
  • 25.47 kB
  • 86 rows
  • 20 columns
Loading... 
CREATE TABLE n_2022_03_31_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2022-09-30 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2022_09_30_organogram_junior
  • 19.27 kB
  • 1,500 rows
  • 11 columns
Loading... 
CREATE TABLE n_2022_09_30_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2022-09-30 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_2022_09_30_organogram_senior
  • 25.61 kB
  • 91 rows
  • 20 columns
Loading... 
CREATE TABLE n_2022_09_30_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2023-03-31 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2023_03_31_organogram_junior
  • 19.54 kB
  • 1,554 rows
  • 11 columns
Loading... 
CREATE TABLE n_2023_03_31_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2023-03-31 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_2023_03_31_organogram_senior
  • 26.32 kB
  • 95 rows
  • 20 columns
Loading... 
CREATE TABLE n_2023_03_31_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2023-09-30 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2023_09_30_organogram_junior
  • 22.15 kB
  • 1,610 rows
  • 11 columns
Loading... 
CREATE TABLE n_2023_09_30_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2023-09-30 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_2023_09_30_organogram_senior
  • 26.29 kB
  • 100 rows
  • 20 columns
Loading... 
CREATE TABLE n_2023_09_30_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2024-03-31 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2024_03_31_organogram_junior
  • 21.07 kB
  • 1,607 rows
  • 11 columns
Loading... 
CREATE TABLE n_2024_03_31_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2024-03-31 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_2024_03_31_organogram_senior
  • 26.31 kB
  • 100 rows
  • 20 columns
Loading... 
CREATE TABLE n_2024_03_31_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

30/09/2016 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2016_organogram_junior
  • 17.34 kB
  • 922 rows
  • 10 columns
Loading... 
CREATE TABLE n_30_09_2016_organogram_junior (
  "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
);

30/09/2016 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2016_organogram_senior
  • 23.41 kB
  • 71 rows
  • 19 columns
Loading... 
CREATE TABLE n_30_09_2016_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE  -- Valid?
);

30/09/2017 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2017_organogram_junior
  • 17.71 kB
  • 998 rows
  • 10 columns
Loading... 
CREATE TABLE n_30_09_2017_organogram_junior (
  "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
);

30/09/2017 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2017_organogram_senior
  • 23.7 kB
  • 85 rows
  • 19 columns
Loading... 
CREATE TABLE n_30_09_2017_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" BIGINT,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE  -- Valid?
);

30/09/2018 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2018_organogram_junior
  • 14.89 kB
  • 582 rows
  • 10 columns
Loading... 
CREATE TABLE n_30_09_2018_organogram_junior (
  "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
);

30/09/2018 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2018_organogram_senior
  • 23.84 kB
  • 90 rows
  • 19 columns
Loading... 
CREATE TABLE n_30_09_2018_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE  -- Valid?
);

30/09/2019 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2019_organogram_junior
  • 18.94 kB
  • 1,121 rows
  • 10 columns
Loading... 
CREATE TABLE n_30_09_2019_organogram_junior (
  "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
);

30/09/2019 Organogram (Senior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2019_organogram_senior
  • 27.7 kB
  • 99 rows
  • 19 columns
Loading... 
CREATE TABLE n_30_09_2019_organogram_senior (
  "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" BIGINT  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT  -- Actual Pay Floor (£),
  "actual_pay_ceiling" BIGINT  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

Share link

Anyone who has the link will be able to view this.