BEIS Organogram Of Staff Roles & Salaries
Department for Business, Energy and Industrial Strategy
@ukgov.organogram_department_for_business_energy_and_industri_13bd193e
Department for Business, Energy and Industrial Strategy
@ukgov.organogram_department_for_business_energy_and_industri_13bd193e
CREATE TABLE beis_organogram_of_staff_roles_salaries (
"post_unique_reference" BIGINT,
"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
);
CREATE TABLE n_2019_06_06_organogram_senior (
"post_unique_reference" BIGINT,
"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" VARCHAR,
"actual_pay_ceiling" VARCHAR,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
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_maximum" DOUBLE,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" DOUBLE,
"professional_occupational_group" VARCHAR,
"valid" BIGINT,
"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,
"unnamed_22" VARCHAR,
"this_sheet_valid" VARCHAR
);
CREATE TABLE n_2019_12_06_organogram_senior (
"post_unique_reference" DOUBLE,
"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" DOUBLE,
"actual_pay_floor" VARCHAR,
"actual_pay_ceiling" VARCHAR,
"total_pay" VARCHAR,
"professional_occupational_group" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT,
"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,
"valid_as_number" BIGINT,
"unnamed_38" VARCHAR,
"a_valid" BOOLEAN,
"j_valid" BOOLEAN,
"text_value" BIGINT,
"unnamed_42" VARCHAR
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" DOUBLE,
"professional_occupational_group" VARCHAR
);
CREATE TABLE n_2020_03_31_organogram_senior (
"post_unique_reference" BIGINT,
"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,
"notes" VARCHAR,
"valid" BIGINT
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" DOUBLE,
"professional_occupational_group" VARCHAR
);
CREATE TABLE n_2020_09_30_organogram_senior (
"post_unique_reference" BIGINT,
"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,
"notes" VARCHAR,
"valid" BIGINT
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" DOUBLE,
"professional_occupational_group" VARCHAR
);
CREATE TABLE n_2021_03_31_organogram_senior (
"post_unique_reference" BIGINT,
"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,
"notes" VARCHAR,
"valid" BIGINT
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" DOUBLE,
"professional_occupational_group" VARCHAR
);
CREATE TABLE n_2021_06_30_organogram_senior (
"post_unique_reference" BIGINT,
"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,
"notes" VARCHAR,
"valid" BIGINT
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" DOUBLE,
"professional_occupational_group" VARCHAR
);
CREATE TABLE n_2021_09_30_organogram_senior (
"post_unique_reference" BIGINT,
"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,
"notes" VARCHAR,
"valid" BIGINT
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" DOUBLE,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR
);
CREATE TABLE n_2021_12_31_organogram_senior (
"post_unique_reference" BIGINT,
"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
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR
);
CREATE TABLE n_2022_03_31_organogram_senior (
"post_unique_reference" BIGINT,
"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
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR
);
CREATE TABLE n_2022_06_30_organogram_senior (
"post_unique_reference" BIGINT,
"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
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR
);
CREATE TABLE n_2022_09_23_organogram_senior (
"post_unique_reference" BIGINT,
"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
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR
);
CREATE TABLE n_2022_12_31_organogram_senior (
"post_unique_reference" BIGINT,
"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
);
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_maximum" BIGINT,
"generic_job_title" VARCHAR,
"number_of_posts_in_fte" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR
);
Anyone who has the link will be able to view this.