UKAEA Organogram Of Staff Roles & Salaries
United Kingdom Atomic Energy Authority
@ukgov.organogram_united_kingdom_atomic_energy_authority
United Kingdom Atomic Energy Authority
@ukgov.organogram_united_kingdom_atomic_energy_authority
CREATE TABLE ukaea_organogram_senior_posts_30_09_16 (
"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 ukaea_organogram_senior_posts_30_09_17 (
"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 ukaea_organogram_senior_posts_31_03_11 (
"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" VARCHAR
);
CREATE TABLE ukaea_organogram_senior_posts_31_03_12 (
"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 ukaea_organogram_senior_posts_31_03_13 (
"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 ukaea_organogram_senior_posts_31_03_14 (
"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 ukaea_organogram_senior_posts_31_03_15 (
"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 ukaea_organogram_senior_posts_31_03_16 (
"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 ukaea_organogram_senior_posts_31_03_17 (
"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 ukaea_organogram_senior_posts_31_03_18 (
"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" BIGINT,
"fte" DOUBLE,
"actual_pay_floor" VARCHAR,
"actual_pay_ceiling" VARCHAR,
"unnamed_15" VARCHAR,
"professional_occupational_group" VARCHAR,
"notes" VARCHAR,
"valid" BIGINT
);
Anyone who has the link will be able to view this.