Baselight
Sign In

BEIS Organogram Of Staff Roles & Salaries

Department for Business, Energy and Industrial Strategy

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e

Loading...
Loading...

About this Dataset

BEIS 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. Snapshots are published on 31st January, 30th April, 31st July and 31st October. 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. Note for data from March 2023: Staff are still reported as BEIS until the transfer of function order has been complete and employees have moved to DBaT, DSIT and DESNZ payroll systems
Publisher name: Department for Business, Energy and Industrial Strategy
Last updated: 2024-09-11T01:46:45Z

Tables

BEIS Organogram Of Staff Roles & Salaries

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.beis_organogram_of_staff_roles_salaries
  • 18.32 kB
  • 55 rows
  • 19 columns
Loading... 
CREATE TABLE beis_organogram_of_staff_roles_salaries (
  "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" 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?
);

2019-06-06 Organogram (Senior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2019_06_06_organogram_senior
  • 21.48 kB
  • 267 rows
  • 19 columns
Loading... 
CREATE TABLE n_2019_06_06_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,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2019-12-06 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2019_12_06_organogram_junior
  • 22.43 kB
  • 6,999 rows
  • 24 columns
Loading... 
CREATE TABLE n_2019_12_06_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" DOUBLE,
  "grade" VARCHAR,
  "payscale_minimum" DOUBLE  -- Payscale Minimum (Ł),
  "payscale_maximum" DOUBLE  -- Payscale Maximum (Ł),
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR,
  "valid" BIGINT  -- Valid?,
  "column_a_valid" BOOLEAN,
  "column_b_valid" BOOLEAN,
  "column_c_valid" BOOLEAN,
  "column_d_valid" BOOLEAN,
  "column_e_valid" BOOLEAN,
  "column_f_valid" BOOLEAN,
  "column_g_valid" BOOLEAN,
  "column_h_valid" BOOLEAN,
  "column_i_valid" BOOLEAN,
  "column_j_valid" BOOLEAN,
  "row_blank" BOOLEAN  -- Row Blank?,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "this_sheet_valid" VARCHAR  -- This Sheet Valid?
);

2019-12-06 Organogram (Senior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2019_12_06_organogram_senior
  • 37.03 kB
  • 1,999 rows
  • 43 columns
Loading... 
CREATE TABLE n_2019_12_06_organogram_senior (
  "post_unique_reference" DOUBLE,
  "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" DOUBLE,
  "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" BIGINT  -- Valid?,
  "column_a_invalid" BOOLEAN,
  "column_b_invalid" BOOLEAN,
  "column_c_invalid" BOOLEAN,
  "column_d_invalid" BOOLEAN,
  "column_e_invalid" BOOLEAN,
  "column_f_invalid" BOOLEAN,
  "column_g_invalid" BOOLEAN,
  "column_h_invalid" BOOLEAN,
  "column_i_invalid" BOOLEAN,
  "column_j_invalid" BOOLEAN,
  "column_k_invalid" BOOLEAN,
  "column_l_invalid" BOOLEAN,
  "column_m_invalid" BOOLEAN,
  "column_n_invalid" BOOLEAN,
  "column_o_invalid" BOOLEAN,
  "column_p_invalid" BOOLEAN,
  "column_q_invalid" BOOLEAN,
  "row_has_errors" BOOLEAN  -- Row Has Errors?,
  "valid_as_number" BIGINT,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "a_valid" BOOLEAN  -- A Valid?,
  "j_valid" BOOLEAN  -- J Valid?,
  "text_value" BIGINT,
  "unnamed_42" VARCHAR  -- Unnamed: 42
);

2020-03-31 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2020_03_31_organogram_junior
  • 15 kB
  • 526 rows
  • 10 columns
Loading... 
CREATE TABLE n_2020_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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_department_for_business_energy_and_industri_13bd193e.n_2020_03_31_organogram_senior
  • 22.48 kB
  • 252 rows
  • 19 columns
Loading... 
CREATE TABLE n_2020_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" VARCHAR  -- 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,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2020-09-30 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2020_09_30_organogram_junior
  • 15.18 kB
  • 573 rows
  • 10 columns
Loading... 
CREATE TABLE n_2020_09_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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-09-30 Organogram (Senior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2020_09_30_organogram_senior
  • 22.81 kB
  • 271 rows
  • 19 columns
Loading... 
CREATE TABLE n_2020_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" VARCHAR  -- 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,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2021-03-31 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2021_03_31_organogram_junior
  • 15.55 kB
  • 586 rows
  • 10 columns
Loading... 
CREATE TABLE n_2021_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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_department_for_business_energy_and_industri_13bd193e.n_2021_03_31_organogram_senior
  • 24.05 kB
  • 325 rows
  • 19 columns
Loading... 
CREATE TABLE n_2021_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" VARCHAR  -- 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,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2021-06-30 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2021_06_30_organogram_junior
  • 15.95 kB
  • 591 rows
  • 10 columns
Loading... 
CREATE TABLE n_2021_06_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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-06-30 Organogram (Senior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2021_06_30_organogram_senior
  • 24.32 kB
  • 325 rows
  • 19 columns
Loading... 
CREATE TABLE n_2021_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" VARCHAR  -- 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,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2021-09-30 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2021_09_30_organogram_junior
  • 15.87 kB
  • 584 rows
  • 10 columns
Loading... 
CREATE TABLE n_2021_09_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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-09-30 Organogram (Senior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2021_09_30_organogram_senior
  • 24.68 kB
  • 328 rows
  • 19 columns
Loading... 
CREATE TABLE n_2021_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" VARCHAR  -- 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,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2021-12-31 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2021_12_31_organogram_junior
  • 17.88 kB
  • 803 rows
  • 11 columns
Loading... 
CREATE TABLE n_2021_12_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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-12-31 Organogram (Senior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2021_12_31_organogram_senior
  • 25.51 kB
  • 325 rows
  • 20 columns
Loading... 
CREATE TABLE n_2021_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" VARCHAR  -- 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-03-31 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2022_03_31_organogram_junior
  • 17.45 kB
  • 825 rows
  • 11 columns
Loading... 
CREATE TABLE n_2022_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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-03-31 Organogram (Senior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2022_03_31_organogram_senior
  • 25.53 kB
  • 334 rows
  • 20 columns
Loading... 
CREATE TABLE n_2022_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" VARCHAR  -- 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-06-30 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2022_06_30_organogram_junior
  • 17.94 kB
  • 891 rows
  • 11 columns
Loading... 
CREATE TABLE n_2022_06_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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-06-30 Organogram (Senior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2022_06_30_organogram_senior
  • 26.12 kB
  • 331 rows
  • 20 columns
Loading... 
CREATE TABLE n_2022_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" VARCHAR  -- 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-09-23 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2022_09_23_organogram_junior
  • 17.94 kB
  • 891 rows
  • 11 columns
Loading... 
CREATE TABLE n_2022_09_23_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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-23 Organogram (Senior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2022_09_23_organogram_senior
  • 26.12 kB
  • 331 rows
  • 20 columns
Loading... 
CREATE TABLE n_2022_09_23_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" VARCHAR  -- 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-12-31 Organogram (Junior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2022_12_31_organogram_junior
  • 18.37 kB
  • 1,022 rows
  • 11 columns
Loading... 
CREATE TABLE n_2022_12_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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-12-31 Organogram (Senior)

@ukgov.organogram_department_for_business_energy_and_industri_13bd193e.n_2022_12_31_organogram_senior
  • 26.07 kB
  • 337 rows
  • 20 columns
Loading... 
CREATE TABLE n_2022_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" VARCHAR  -- 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_department_for_business_energy_and_industri_13bd193e.n_2023_03_31_organogram_junior
  • 17.6 kB
  • 944 rows
  • 11 columns
Loading... 
CREATE TABLE n_2023_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "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
);

Share link

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