Cambridgeshire County Council - HR Information

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_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 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  -- Employee's Salary (shown In Ł5,000 Bands),
  "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  -- Unnamed: 2,
  "directorate" VARCHAR,
  "job_title" VARCHAR,
  "employee_s_salary_shown_in_5_000_bands" VARCHAR  -- Employee's Salary (shown In Ł5,000 Bands),
  "actual_salary_for_posts_paid_over_150_000" DOUBLE  -- Actual Salary (for Posts Paid Over Ł150,000),
  "bottom_of_the_pay_scale" BIGINT,
  "salary_ceiling" BIGINT,
  "employment_term" VARCHAR,
  "comments" 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  -- Employees Current Salary Range (in Ł5,000 Increments Unless Over Ł150,000),
  "notes" VARCHAR
);

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  -- Employees Current Salary Range (in Ł5,000 Increments Unless Over Ł150,000),
  "employment_term" VARCHAR,
  "notes" VARCHAR
);

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  -- Remuneration In Ł5K Bands (except For Roles With A Salary Of 150,000 And Above),
  "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_2019_staff_tiers_1_to_3 (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "tier" VARCHAR,
  "position_post_holder_details_are_given_for_posts_with__c2b5e639" VARCHAR  -- Position (post Holder Details Are Given For Posts With An FTE Salary Of Above £150,000),
  "fte_salary_in_5k_bands_except_for_roles_with_fte_salar_43392115" VARCHAR  -- FTE Salary In 5K Bands (except For Roles With FTE Salary Of 150,000 Or Above),
  "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_2020_pay_over_50k (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "directorate" VARCHAR,
  "position_post_holder_details_are_given_for_posts_with__78d7177c" VARCHAR  -- Position (post Holder Details Are Given For Posts With Remuneration Above Ł150,000),
  "total_remuneration_in_5k_bands_except_for_roles_with_t_490a73ea" VARCHAR  -- Total Remuneration In Ł5K Bands (except For Roles With Total Remuneration Of 150,000 And Above),
  "bottom_of_pay_grade" VARCHAR,
  "top_of_the_pay_grade" VARCHAR,
  "employment_term" VARCHAR,
  "notes" 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  -- Position (post Holder Details Are Given For Posts With An FTE Salary Of Above £150,000),
  "directorate" VARCHAR,
  "fte_salary_in_5k_bands_except_for_roles_with_a_salary__51a4151b" VARCHAR  -- FTE Salary In £5K Bands (except For Roles With A Salary Of 150,000 And Above),
  "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_2021_staff_tiers_1_to_3 (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "tier" VARCHAR,
  "position_post_holder_details_are_only_given_for_posts__383ac37b" VARCHAR  -- Position (post Holder Details Are Only Given For Posts With An FTE Salary Of Above Ł150,000),
  "directorate" VARCHAR,
  "fte_salary_in_5k_bands_except_for_roles_with_an_fte_sa_cb15ff5f" VARCHAR  -- FTE Salary In Ł5K Bands (except For Roles With An FTE Salary Of Ł150,000 And Above),
  "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: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12
);

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  -- Position (post Holder Details Are Given For Posts With An FTE Salary Of Above £150,000),
  "post_holder_only_given_for_roles_with_an_fte_over_150k" VARCHAR  -- Post Holder (only Given For Roles With An FTE Over 150K),
  "directorate" VARCHAR,
  "fte_salary_in_5k_bands_except_for_roles_with_a_salary__51a4151b" VARCHAR  -- FTE Salary In £5K Bands (except For Roles With A Salary Of 150,000 And Above),
  "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_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 corporate_leadership_team_pay_scales_2015_16 (
  "level" DOUBLE,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "chief_executive" DOUBLE,
  "executive_director" DOUBLE,
  "director" VARCHAR,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

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 head_of_service_pay_scales_2015_16 (
  "head_of_service" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

CREATE TABLE management_band_pay_scales_2015_16 (
  "spinal_point" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "mb1" VARCHAR,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "mb2" VARCHAR,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "mb3" VARCHAR,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "mb4" VARCHAR,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "mb5" VARCHAR,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "hourly_rate" DOUBLE  -- Hourly Rate Ł
);

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 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  -- Salary Range In £5,000 Bracket,
  "band_ceiling" 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 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  -- Salary Range In Ł5000 Brackets
);

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 table_16 (
  "organisation" VARCHAR,
  "publication_date" TIMESTAMP,
  "position" VARCHAR,
  "total_remuneration_in_5k_ranges_except_where_total_rem_1a3ce45d" VARCHAR  -- Total Remuneration In Ł5K Ranges (except Where Total Remuneration Is Over 150K),
  "minimum_salary_for_position" VARCHAR  -- Minimum Salary For Position (Ł),
  "maximum_salary_for_position" VARCHAR  -- Maximum Salary For Position (Ł),
  "notes" VARCHAR,
  "shared_roles_with_pcc" VARCHAR  -- Shared Roles With PCC?
);

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  -- Total Remuneration For January - December 2020 In £5K Bands (except For Roles With Total Remuneration Of 150,000 And Above),
  "notes" VARCHAR
);

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