Cambridgeshire County Council - HR Information

CREATE TABLE cambridgeshire_county_council_2016_staff_tiers_1_to_3 (
  "organisation" VARCHAR,
  "effective_date" TIMESTAMP,
  "tier" DOUBLE,
  "exec" VARCHAR,
  "position_name" VARCHAR,
  "temporary_permanent" VARCHAR,
  "grade" VARCHAR,
  "salary_bands" VARCHAR,
  "salary_ceiling" DOUBLE,
  "notes" VARCHAR
);

CREATE TABLE corporate_leadership_team_pay_scales_2014_15 (
  "level" BIGINT,
  "level_description" VARCHAR,
  "chief_executive" VARCHAR,
  "executive_director" VARCHAR,
  "director_a" VARCHAR,
  "director_b" VARCHAR,
  "director_c" VARCHAR,
  "director_d" VARCHAR,
  "director_e" VARCHAR,
  "director_f" VARCHAR
);

CREATE TABLE management_band_pay_scales_2015_16 (
  "spinal_point" VARCHAR,
  "unnamed_1" VARCHAR,
  "mb1" VARCHAR,
  "unnamed_3" VARCHAR,
  "mb2" VARCHAR,
  "unnamed_5" VARCHAR,
  "mb3" VARCHAR,
  "unnamed_7" VARCHAR,
  "mb4" VARCHAR,
  "unnamed_9" VARCHAR,
  "mb5" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "hourly_rate" DOUBLE
);

CREATE TABLE head_of_service_pay_scales_2015_16 (
  "head_of_service" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

CREATE TABLE cambridgeshire_county_council_2022_staff_tiers_1_to_3 (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "tier" BIGINT,
  "position_post_holder_details_are_given_for_posts_with__c2b5e639" VARCHAR,
  "post_holder_only_given_for_roles_with_an_fte_over_150k" VARCHAR,
  "directorate" VARCHAR,
  "fte_salary_in_5k_bands_except_for_roles_with_a_salary__51a4151b" VARCHAR,
  "bottom_of_pay_grade_for_the_position" VARCHAR,
  "top_of_pay_grade_for_the_position" VARCHAR,
  "employment_type" VARCHAR,
  "notes" VARCHAR
);

CREATE TABLE corporate_leadership_team_pay_scales_2015_16 (
  "level" DOUBLE,
  "unnamed_1" VARCHAR,
  "chief_executive" DOUBLE,
  "executive_director" DOUBLE,
  "director" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR
);

CREATE TABLE management_pay_band_scales_2014_15 (
  "spinal_point" VARCHAR,
  "management_band_1" VARCHAR,
  "quartile" VARCHAR,
  "management_band_2" VARCHAR,
  "quartile_1" VARCHAR,
  "management_band_3" VARCHAR,
  "quartile_2" VARCHAR,
  "management_band_4" VARCHAR,
  "quartile_3" VARCHAR,
  "management_band_5" VARCHAR,
  "quartile_4" VARCHAR,
  "hourly_rate" VARCHAR
);

CREATE TABLE table_8 (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "role" VARCHAR,
  "bottom_of_grade" VARCHAR,
  "top_of_grade" VARCHAR,
  "total_remuneration_for_january_december_2020_in_5k_ban_13443543" VARCHAR,
  "notes" VARCHAR
);

CREATE TABLE salary_range_2015_16 (
  "organisation" VARCHAR,
  "effective_date" TIMESTAMP,
  "tier" DOUBLE,
  "exec" VARCHAR,
  "position_name" VARCHAR,
  "temporary_permanent" VARCHAR,
  "grade" VARCHAR,
  "salary_bands" VARCHAR,
  "salary_ceiling" DOUBLE,
  "notes" VARCHAR
);

CREATE TABLE cambridgeshire_county_council_2020_pay_over_50k (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "directorate" VARCHAR,
  "position_post_holder_details_are_given_for_posts_with__78d7177c" VARCHAR,
  "total_remuneration_in_5k_bands_except_for_roles_with_t_490a73ea" VARCHAR,
  "bottom_of_pay_grade" VARCHAR,
  "top_of_the_pay_grade" VARCHAR,
  "employment_term" VARCHAR,
  "notes" VARCHAR
);

CREATE TABLE total_staff_and_fte_2016_2019 (
  "year" BIGINT,
  "number_of_employees" BIGINT,
  "fte" BIGINT
);

CREATE TABLE senior_manager_pay_2014_15 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "exec" VARCHAR,
  "position_name" VARCHAR,
  "team" VARCHAR,
  "grade_name" VARCHAR,
  "salary_range_in_5000_brackets" VARCHAR
);

CREATE TABLE cambridgeshire_county_council_2019_staff_tiers_1_to_3 (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "tier" VARCHAR,
  "position_post_holder_details_are_given_for_posts_with__c2b5e639" VARCHAR,
  "fte_salary_in_5k_bands_except_for_roles_with_fte_salar_43392115" VARCHAR,
  "bottom_of_pay_scale_for_the_position" VARCHAR,
  "top_of_pay_scale_for_the_position" VARCHAR,
  "employment_type" VARCHAR,
  "notes" VARCHAR
);

CREATE TABLE cambridgeshire_county_council_2017_pay_over_50k (
  "organisation" VARCHAR,
  "effective_date" TIMESTAMP,
  "team" VARCHAR,
  "job_title" VARCHAR,
  "employment_term" VARCHAR,
  "employee_s_salary_shown_in_5_000_bands" VARCHAR,
  "bottom_of_the_pay_scale" BIGINT,
  "salary_ceiling" BIGINT
);

CREATE TABLE cambridgeshire_county_council_2017_staff_tiers_1_to_3 (
  "organisation" VARCHAR,
  "effective_date" TIMESTAMP,
  "unnamed_2" BIGINT,
  "directorate" VARCHAR,
  "job_title" VARCHAR,
  "employee_s_salary_shown_in_5_000_bands" VARCHAR,
  "actual_salary_for_posts_paid_over_150_000" DOUBLE,
  "bottom_of_the_pay_scale" BIGINT,
  "salary_ceiling" BIGINT,
  "employment_term" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE table_16 (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "position" VARCHAR,
  "total_remuneration_in_5k_ranges_except_where_total_rem_1a3ce45d" VARCHAR,
  "minimum_salary_for_position" VARCHAR,
  "maximum_salary_for_position" VARCHAR,
  "notes" VARCHAR,
  "shared_roles_with_pcc" VARCHAR
);

CREATE TABLE salary_range_2014_15 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "tier" DOUBLE,
  "exec" VARCHAR,
  "directorate" VARCHAR,
  "position_name" VARCHAR,
  "permanent" VARCHAR,
  "grade" VARCHAR,
  "salary_range_in_5_000_bracket" VARCHAR,
  "band_ceiling" VARCHAR
);

CREATE TABLE cambridgeshire_county_council_2020_staff_tiers_1_to_3 (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "tier" VARCHAR,
  "position_post_holder_details_are_given_for_posts_with__c2b5e639" VARCHAR,
  "directorate" VARCHAR,
  "fte_salary_in_5k_bands_except_for_roles_with_a_salary__51a4151b" VARCHAR,
  "bottom_of_pay_grade_for_the_position" VARCHAR,
  "top_of_pay_grade_for_the_position" VARCHAR,
  "employment_type" VARCHAR,
  "notes" VARCHAR
);

CREATE TABLE cambridgeshire_county_council_2018_pay_over_50k (
  "organisation" VARCHAR,
  "effective_date" TIMESTAMP,
  "position_name" VARCHAR,
  "employment_term" VARCHAR,
  "bottom_of_the_pay_scale" BIGINT,
  "top_of_the_pay_scale" BIGINT,
  "employees_current_salary_range_in_5_000_increments_unl_4030c07e" VARCHAR,
  "notes" VARCHAR
);

CREATE TABLE senior_manager_pay_2015_16 (
  "organisation" VARCHAR,
  "effective_data" TIMESTAMP,
  "directorate" VARCHAR,
  "position_name" VARCHAR,
  "temporary_permanent" VARCHAR,
  "grade_name" VARCHAR,
  "salary_band" VARCHAR,
  "salary_ceiling" BIGINT
);

CREATE TABLE cambridgeshire_county_council_2019_pay_over_50k (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "directorate" VARCHAR,
  "position" VARCHAR,
  "remuneration_in_5k_bands_except_for_roles_with_a_salar_0ce40881" VARCHAR,
  "bottom_of_pay_scale_for_the_position" VARCHAR,
  "top_of_pay_scale_for_the_position" VARCHAR,
  "employment_type" VARCHAR,
  "notes" VARCHAR
);

CREATE TABLE cambridgeshire_county_council_2016_pay_over_50k (
  "organisation" VARCHAR,
  "effective_data" TIMESTAMP,
  "directorate" VARCHAR,
  "position_name" VARCHAR,
  "temporary_permanent" VARCHAR,
  "grade_name" VARCHAR,
  "salary_band" VARCHAR,
  "salary_ceiling" BIGINT
);

CREATE TABLE cambridgeshire_county_council_2018_staff_tiers_1_to_3 (
  "organisation" VARCHAR,
  "effective_date" TIMESTAMP,
  "tier" BIGINT,
  "post" VARCHAR,
  "bottom_of_scale" BIGINT,
  "top_of_scale" BIGINT,
  "employees_current_salary_range_in_5_000_increments_unl_4030c07e" VARCHAR,
  "employment_term" VARCHAR,
  "notes" VARCHAR
);

CREATE TABLE head_of_service_pay_scales_2014_15 (
  "spinal_point" VARCHAR,
  "head_of_service_level_1" DOUBLE,
  "quartile" VARCHAR,
  "head_of_service_level_2" DOUBLE,
  "quartile_1" VARCHAR,
  "head_of_service_level_3" DOUBLE,
  "quartile_2" VARCHAR,
  "hourly_rate" DOUBLE
);

CREATE TABLE cambridgeshire_county_council_2021_staff_tiers_1_to_3 (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "tier" VARCHAR,
  "position_post_holder_details_are_only_given_for_posts__383ac37b" VARCHAR,
  "directorate" VARCHAR,
  "fte_salary_in_5k_bands_except_for_roles_with_an_fte_sa_cb15ff5f" VARCHAR,
  "bottom_of_pay_grade_for_the_position" VARCHAR,
  "top_of_pay_grade_for_the_position" VARCHAR,
  "employment_type" VARCHAR,
  "notes" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR
);