Name: Pay Multiple And Pay Policy Statement
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Pay Multiple And Pay Policy Statement

Rochdale Borough Council produces an annual Pay Policy Statement under Section 38 of the Localism Act 2011 which includes the policy on pay dispersion.
Publisher name: Rochdale Borough Council
Last updated: 2022-07-01T04:01:03Z

Tables

Table 1

@ukgov.pay_multiple_and_pay_policy_statement.table_1

8.37 kB
1 row
10 columns

CREATE TABLE table_1 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "mean_average_salary" VARCHAR  -- Mean (average) Salary,
  "mode_most_frequently_occurring_salary" VARCHAR  -- Mode (most Frequently Occurring) Salary,
  "median_middle_salary" VARCHAR  -- Median (middle) Salary,
  "lowest_paid_job" VARCHAR,
  "median_pay_ratio" DOUBLE,
  "highest" VARCHAR,
  "median_middle_salary_1" VARCHAR  -- Median (middle) Salary.1
);

Table 2

@ukgov.pay_multiple_and_pay_policy_statement.table_2

7.8 kB
1 row
9 columns

CREATE TABLE table_2 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "mean_average_salary" BIGINT  -- Mean (average) Salary,
  "mode_most_frequently_occurring_salary" BIGINT  -- Mode (most Frequently Occurring) Salary,
  "median_middle_salary" BIGINT  -- Median (middle) Salary,
  "lowest_paid_job" BIGINT,
  "median_pay_ratio" DOUBLE,
  "highest" BIGINT
);