Pay Multiples
Leeds City Council
@ukgov.pay_multiples
Leeds City Council
@ukgov.pay_multiples
CREATE TABLE n_31_03_2014 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"paymultiplefactor" VARCHAR,
"remunerationvalue" VARCHAR,
"ratio" VARCHAR,
"period" VARCHAR,
"modelcalculation" VARCHAR,
"organisationtype" VARCHAR
);
CREATE TABLE n_31_03_2017 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"paymultiplefactor" VARCHAR,
"remunerationvalue" VARCHAR,
"ratio" VARCHAR,
"period" VARCHAR,
"modelcalculation" VARCHAR,
"organisationtype" VARCHAR
);
CREATE TABLE n_31_03_2018 (
"effectivedate" TIMESTAMP,
"paymultiplefactor" VARCHAR,
"remunerationvalue" VARCHAR,
"ratio" VARCHAR,
"period" VARCHAR,
"modelcalculation" VARCHAR,
"organisation_type" VARCHAR
);
CREATE TABLE n_31_03_2019 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"paymultiplefactor" VARCHAR,
"remunerationvalue" VARCHAR,
"ratio" VARCHAR,
"period" VARCHAR,
"modelcalculation" VARCHAR,
"organisation_type" VARCHAR
);
CREATE TABLE n_31_03_2020 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"paymultiplefactor" VARCHAR,
"remunerationvalue" VARCHAR,
"ratio" VARCHAR,
"period" VARCHAR,
"modelcalculation" VARCHAR,
"organisation_type" VARCHAR
);
Anyone who has the link will be able to view this.