About this Dataset

Organogram Of CMA Staff Roles And 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. The published data is validated and released in CSV format and OGL-licensed for reuse.
Publisher name: Competition and Markets Authority
Last updated: 2024-06-14T04:02:59Z

Tables

2022-02-11 Organogram (Junior)

@ukgov.organogram_of_cma_staff_roles_and_salaries.n_2022_02_11_organogram_junior

10.97 KB
318 rows
11 columns


CREATE TABLE n_2022_02_11_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-02-11 Organogram (Senior)

@ukgov.organogram_of_cma_staff_roles_and_salaries.n_2022_02_11_organogram_senior

25.97 KB
131 rows
20 columns


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

2022-05-11 Organogram (Junior)

@ukgov.organogram_of_cma_staff_roles_and_salaries.n_2022_05_11_organogram_junior

11.04 KB
326 rows
11 columns


CREATE TABLE n_2022_05_11_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-05-11 Organogram (Senior)

@ukgov.organogram_of_cma_staff_roles_and_salaries.n_2022_05_11_organogram_senior

26.43 KB
138 rows
20 columns


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

2022-08-08 Organogram (Junior)

@ukgov.organogram_of_cma_staff_roles_and_salaries.n_2022_08_08_organogram_junior

10.92 KB
307 rows
11 columns


CREATE TABLE n_2022_08_08_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-08-08 Organogram (Senior)

@ukgov.organogram_of_cma_staff_roles_and_salaries.n_2022_08_08_organogram_senior

26.22 KB
132 rows
20 columns


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