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
  • 33.94 KB
  • 29999 rows
  • 42 columns
Loading... 

CREATE TABLE crown_prosecution_service_organogram_march_2015 (
  "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" DOUBLE,
  "fte" VARCHAR,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "total_pay" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE,
  "a_has_errors" VARCHAR,
  "b_has_errors" VARCHAR,
  "c_has_errors" VARCHAR,
  "d_has_errors" VARCHAR,
  "e_has_errors" VARCHAR,
  "f_has_errors" VARCHAR,
  "g_has_errors" VARCHAR,
  "h_has_errors" VARCHAR,
  "i_has_errors" VARCHAR,
  "j_has_errors" VARCHAR,
  "k_has_errors" VARCHAR,
  "l_has_errors" VARCHAR,
  "m_has_errors" VARCHAR,
  "n_has_errors" VARCHAR,
  "p_has_errors" VARCHAR,
  "q_has_errors" VARCHAR,
  "row_has_errors" VARCHAR,
  "valid_as_number" DOUBLE,
  "unnamed_37" VARCHAR,
  "a_valid" VARCHAR,
  "j_valid" VARCHAR,
  "text_value" VARCHAR,
  "unnamed_41" VARCHAR
);

2020-03-31 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2020_03_31_organogram_junior
  • 17.92 KB
  • 1113 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_maximum" BIGINT,
  "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.25 KB
  • 93 rows
  • 19 columns
Loading... 

CREATE TABLE n_2020_03_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,
  "notes" VARCHAR,
  "valid" BIGINT
);

2021-03-31 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2021_03_31_organogram_junior
  • 18.58 KB
  • 1205 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_maximum" BIGINT,
  "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
  • 23.91 KB
  • 86 rows
  • 19 columns
Loading... 

CREATE TABLE n_2021_03_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,
  "notes" VARCHAR,
  "valid" BIGINT
);

2021-09-30 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2021_09_30_organogram_junior
  • 19.58 KB
  • 1216 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_maximum" BIGINT,
  "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
  • 24.88 KB
  • 86 rows
  • 20 columns
Loading... 

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

2022-03-31 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2022_03_31_organogram_junior
  • 20.42 KB
  • 1457 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_maximum" BIGINT,
  "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
  • 24.88 KB
  • 86 rows
  • 20 columns
Loading... 

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

2022-09-30 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2022_09_30_organogram_junior
  • 18.82 KB
  • 1500 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_maximum" BIGINT,
  "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.01 KB
  • 91 rows
  • 20 columns
Loading... 

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

2023-03-31 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2023_03_31_organogram_junior
  • 19.09 KB
  • 1554 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_maximum" BIGINT,
  "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
  • 25.71 KB
  • 95 rows
  • 20 columns
Loading... 

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

2023-09-30 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2023_09_30_organogram_junior
  • 21.63 KB
  • 1610 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_maximum" BIGINT,
  "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
  • 25.68 KB
  • 100 rows
  • 20 columns
Loading... 

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

2024-03-31 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_2024_03_31_organogram_junior
  • 20.57 KB
  • 1607 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_maximum" BIGINT,
  "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
  • 25.69 KB
  • 100 rows
  • 20 columns
Loading... 

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

30/09/2016 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2016_organogram_junior
  • 16.94 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_maximum" BIGINT,
  "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
  • 22.86 KB
  • 71 rows
  • 19 columns
Loading... 

CREATE TABLE n_30_09_2016_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,
  "notes" VARCHAR,
  "valid" DOUBLE
);

30/09/2017 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2017_organogram_junior
  • 17.3 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_maximum" BIGINT,
  "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.14 KB
  • 85 rows
  • 19 columns
Loading... 

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

30/09/2018 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2018_organogram_junior
  • 14.54 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_maximum" BIGINT,
  "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.28 KB
  • 90 rows
  • 19 columns
Loading... 

CREATE TABLE n_30_09_2018_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,
  "notes" VARCHAR,
  "valid" DOUBLE
);

30/09/2019 Organogram (Junior)

@ukgov.organogram_crown_prosecution_service.n_30_09_2019_organogram_junior
  • 18.49 KB
  • 1121 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_maximum" BIGINT,
  "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.05 KB
  • 99 rows
  • 19 columns
Loading... 

CREATE TABLE n_30_09_2019_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,
  "notes" VARCHAR,
  "valid" BIGINT
);

Share link

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