About this Dataset

SLDC Senior Salaries

This dataset provides information on Senior Salaries in South Lakeland District Council to meet the Local Government Transparency Code 2015 requirements for Organisational Information. Also published is a dataset to give information on the Count of Senior Salaries in South Lakeland District Council. This shows the count of all employees whose remuneration is over £50,000.
Publisher name: South Lakeland District Council
Last updated: 2024-09-14T18:45:06Z

Tables

Count Of Senior Salaries March 2019

@ukgov.sldc_senior_salaries.count_of_senior_salaries_march_2019

5.23 kB
23 rows
5 columns

CREATE TABLE count_of_senior_salaries_march_2019 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "extractdate" TIMESTAMP,
  "remunerationband" VARCHAR,
  "employeecount" DOUBLE
);

Senior Salaries 2018 To 2019

@ukgov.sldc_senior_salaries.senior_salaries_2018_to_2019

19.1 kB
13 rows
23 columns

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  -- EmployeeCount(FTE)
);

SLDC Senior Salaries

@ukgov.sldc_senior_salaries.sldc_senior_salaries

5.14 kB
12 rows
5 columns

CREATE TABLE sldc_senior_salaries (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "extractdate" TIMESTAMP,
  "remunerationband" VARCHAR,
  "employeecount" BIGINT
);