SLDC Senior Salaries
South Lakeland District Council
@ukgov.sldc_senior_salaries
South Lakeland District Council
@ukgov.sldc_senior_salaries
CREATE TABLE count_of_senior_salaries_march_2019 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"extractdate" TIMESTAMP,
"remunerationband" VARCHAR,
"employeecount" DOUBLE
);
CREATE TABLE senior_salaries_2018_to_2019 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"jobtitle" VARCHAR,
"directorate" VARCHAR,
"service" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategorycode" DOUBLE,
"salary" DOUBLE,
"additionalreponsibilitypayment" DOUBLE,
"additionalresponsibilityname" VARCHAR,
"employerspensioncontribution" DOUBLE,
"bonuses" DOUBLE,
"expenseallowances" DOUBLE,
"lossofpostcompensation" DOUBLE,
"benefitsinkind" DOUBLE,
"bonusdetails" VARCHAR,
"benefitsdetails" VARCHAR,
"responsibilties" VARCHAR,
"service_function" VARCHAR,
"service_functioncode" VARCHAR,
"budget" DOUBLE,
"employeecount_fte" VARCHAR
);
CREATE TABLE sldc_senior_salaries (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"extractdate" TIMESTAMP,
"remunerationband" VARCHAR,
"employeecount" BIGINT
);
Anyone who has the link will be able to view this.