Baselight
Sign In

MOD-Organogram Of Staff Roles & Salaries-Dstl

Defence Science and Technology Laboratory

@ukgov.organogram_defence_science_and_technology_laboratory

Loading...
Loading...

About this Dataset

MOD-Organogram Of Staff Roles & Salaries-Dstl

Organogram (organisation chart) showing all staff roles. Names and salaries are also listed for the Senior Civil Servants 2* and above. Organogram data has been released by all central government departments and their agencies since 2010. Snapshots are published quarterly for datasets from 31st March; 30th June; 30th September and 31st 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: Defence Science and Technology Laboratory
Last updated: 2025-04-30T04:00:12Z

Tables

MOD-Organogram Of Staff Roles & Salaries-Dstl

@ukgov.organogram_defence_science_and_technology_laboratory.mod_organogram_of_staff_roles_salaries_dstl
  • 9.85 kB
  • 113 rows
  • 10 columns
Loading... 
CREATE TABLE mod_organogram_of_staff_roles_salaries_dstl (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "payscale_minimum" BIGINT  -- Payscale Minimum (£),
  "payscale_maximum" BIGINT  -- Payscale Maximum (£),
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR
);

2022-06-30 Organogram (Junior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2022_06_30_organogram_junior
  • 12.05 kB
  • 334 rows
  • 11 columns
Loading... 
CREATE TABLE n_2022_06_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "grade" DOUBLE,
  "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-06-30 Organogram (Senior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2022_06_30_organogram_senior
  • 15.17 kB
  • 11 rows
  • 20 columns
Loading... 
CREATE TABLE n_2022_06_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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2022-10-29 Organogram (Junior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2022_10_29_organogram_junior
  • 12.12 kB
  • 333 rows
  • 11 columns
Loading... 
CREATE TABLE n_2022_10_29_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "grade" DOUBLE,
  "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-10-29 Organogram (Senior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2022_10_29_organogram_senior
  • 15.09 kB
  • 11 rows
  • 20 columns
Loading... 
CREATE TABLE n_2022_10_29_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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2023-01-31 Organogram (Junior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2023_01_31_organogram_junior
  • 12 kB
  • 322 rows
  • 11 columns
Loading... 
CREATE TABLE n_2023_01_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "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-01-31 Organogram (Senior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2023_01_31_organogram_senior
  • 15.13 kB
  • 10 rows
  • 20 columns
Loading... 
CREATE TABLE n_2023_01_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- 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_defence_science_and_technology_laboratory.n_2023_03_31_organogram_junior
  • 12.02 kB
  • 328 rows
  • 11 columns
Loading... 
CREATE TABLE n_2023_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "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_defence_science_and_technology_laboratory.n_2023_03_31_organogram_senior
  • 15.11 kB
  • 10 rows
  • 20 columns
Loading... 
CREATE TABLE n_2023_03_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2023-06-30 Organogram (Junior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2023_06_30_organogram_junior
  • 11.06 kB
  • 171 rows
  • 11 columns
Loading... 
CREATE TABLE n_2023_06_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "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-06-30 Organogram (Senior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2023_06_30_organogram_senior
  • 14.94 kB
  • 5 rows
  • 20 columns
Loading... 
CREATE TABLE n_2023_06_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- 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_defence_science_and_technology_laboratory.n_2023_09_30_organogram_junior
  • 11.91 kB
  • 331 rows
  • 11 columns
Loading... 
CREATE TABLE n_2023_09_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "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_defence_science_and_technology_laboratory.n_2023_09_30_organogram_senior
  • 15.01 kB
  • 5 rows
  • 20 columns
Loading... 
CREATE TABLE n_2023_09_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2023-12-31 Organogram (Junior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2023_12_31_organogram_junior
  • 11.05 kB
  • 174 rows
  • 11 columns
Loading... 
CREATE TABLE n_2023_12_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "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-12-31 Organogram (Senior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2023_12_31_organogram_senior
  • 15.11 kB
  • 5 rows
  • 20 columns
Loading... 
CREATE TABLE n_2023_12_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- 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_defence_science_and_technology_laboratory.n_2024_03_31_organogram_junior
  • 11.13 kB
  • 182 rows
  • 11 columns
Loading... 
CREATE TABLE n_2024_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "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_defence_science_and_technology_laboratory.n_2024_03_31_organogram_senior
  • 15.13 kB
  • 5 rows
  • 20 columns
Loading... 
CREATE TABLE n_2024_03_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2024-06-30 Organogram (Junior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2024_06_30_organogram_junior
  • 10.99 kB
  • 154 rows
  • 11 columns
Loading... 
CREATE TABLE n_2024_06_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "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-06-30 Organogram (Senior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2024_06_30_organogram_senior
  • 15.18 kB
  • 4 rows
  • 20 columns
Loading... 
CREATE TABLE n_2024_06_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2024-09-30 Organogram (Junior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2024_09_30_organogram_junior
  • 11.08 kB
  • 171 rows
  • 11 columns
Loading... 
CREATE TABLE n_2024_09_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "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-09-30 Organogram (Senior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2024_09_30_organogram_senior
  • 15.01 kB
  • 5 rows
  • 20 columns
Loading... 
CREATE TABLE n_2024_09_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2024-12-31 Organogram (Junior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2024_12_31_organogram_junior
  • 11.02 kB
  • 169 rows
  • 11 columns
Loading... 
CREATE TABLE n_2024_12_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "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-12-31 Organogram (Senior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2024_12_31_organogram_senior
  • 15.29 kB
  • 5 rows
  • 20 columns
Loading... 
CREATE TABLE n_2024_12_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2025-03-31 Organogram (Junior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2025_03_31_organogram_junior
  • 11.01 kB
  • 184 rows
  • 11 columns
Loading... 
CREATE TABLE n_2025_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" DOUBLE,
  "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
);

2025-03-31 Organogram (Senior)

@ukgov.organogram_defence_science_and_technology_laboratory.n_2025_03_31_organogram_senior
  • 15.64 kB
  • 6 rows
  • 20 columns
Loading... 
CREATE TABLE n_2025_03_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

Share link

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