Trafford Council - Senior Salaries
Trafford Council
@ukgov.trafford_council_senior_salaries
Trafford Council
@ukgov.trafford_council_senior_salaries
CREATE TABLE senior_employees (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"jobtitle" VARCHAR,
"name" VARCHAR,
"directorate" VARCHAR,
"service" VARCHAR,
"salary" BIGINT,
"pensioncontribution" BIGINT,
"bonuses" BIGINT,
"expenseallowances" BIGINT,
"lossofpostcompensation" BIGINT,
"benefitsinkind" BIGINT,
"bonusdetails" VARCHAR,
"benefitsdetails" VARCHAR,
"responsibilities" VARCHAR
);
CREATE TABLE senior_employees_metadata (
"name" VARCHAR,
"description" VARCHAR
);
CREATE TABLE senior_salaries_count (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"remunerationband" VARCHAR,
"employeecount" BIGINT
);
CREATE TABLE senior_salaries_count_metadata (
"name" VARCHAR,
"description" VARCHAR
);
Anyone who has the link will be able to view this.