Trafford Council

@ukgov.trafford_council_pay_multiple

Table List

2 tables(12.1 KB)

Trafford-pay-multiple-metadata

@ukgov.trafford_council_pay_multiple.trafford_pay_multiple_metadata

4.34 KB
6 rows
2 columns

effectivedate EffectiveDate	date_at_which_the_information_provided_is_true_in_the__ae043ca3 Date At Which The Information Provided Is True, In The ISO International Date Format YYYY-MM-DD.
PayMultipleFactor	Factor that is used to calculate the pay multiple: 'Median', 'Mean', 'Lowest' and 'Highest' remuneration pay. The use of 'Median' and 'Highest' is mandatory, the other factors are optional.
RemunerationValue	Remuneration value in GBP for the pay multiple factor.
Ratio	The ratio is the highest earned remuneration divided by the pay multiple factor. The Transparency Code mandates to show the pay multiple for the median remuneration, i.e Highest:Median. Shown as numeric ratio.
Period	The financial year for which the pay multiple is calculated in the format YYYY/YY.
ModelCalculation	Code from 0 - 4 to specify what factor was used to calculate the ratio, to meet the requirement of www.paycompare.org.uk. 0 = Unreported or otherwise uncertain, 1 = Highest:Median of whole workforce, 2 = Highest:Median of non-chief officers, 3 = Highest:Mean of whole workforce, 4 = Highest:lowest.
OrganisationType	Abbreviation to specify type of public organisation. MBC = Metropolitan Borough Council.


CREATE TABLE trafford_pay_multiple_metadata (
  "effectivedate" VARCHAR,
  "date_at_which_the_information_provided_is_true_in_the__ae043ca3" VARCHAR
);

Trafford Council - Pay Multiple

Table List

Trafford-pay-multiple-metadata

@ukgov.trafford_council_pay_multiple.trafford_pay_multiple_metadata

effectivedate

date_at_which_the_information_provided_is_true_in_the__ae043ca3

Share link