Organogram Of Staff Roles & Salaries
NHS Blood and Transplant
@ukgov.organogram_nhs_blood_and_transplant
NHS Blood and Transplant
@ukgov.organogram_nhs_blood_and_transplant
CREATE TABLE n_2019_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_2019_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2019_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_2019_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2020_07_15_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_07_15_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2022_11_25_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_2022_11_25_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2022_12_15_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_2022_12_15_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2023_04_21_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_2023_04_21_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2023_07_06_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_2023_07_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2023_10_17_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_2023_10_17_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2024_01_24_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" BIGINT,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR
);
CREATE TABLE n_2024_01_24_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2024_03_27_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_2024_03_27_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2024_07_12_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_2024_07_12_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2024_10_17_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_2024_10_17_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" BIGINT,
"actual_pay_ceiling" BIGINT,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
CREATE TABLE n_2025_01_16_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
);
Anyone who has the link will be able to view this.