Trafford Council

@ukgov.trafford_council_organisation_chart

Table List

2 tables(20.22 KB)

Senior Structure Dataset

@ukgov.trafford_council_organisation_chart.senior_structure_dataset

16.11 KB
80 rows
16 columns

organisationlabel OrganisationLabel	organisationuri OrganisationURI	effectivedate EffectiveDate	level Level	jobtitle JobTitle	name Name	grade Grade	directorate Directorate	service Service	contracttype ContractType	sharedpost SharedPost	contactdetails ContactDetails	salaryband SalaryBand	maximumsalary MaximumSalary	vacancy Vacancy	comments Comments
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Mon Jul 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Chief Executive / Place-Based Lead for Health and Care Integration, NHS GM/Trafford	Sara Todd	Spot salary	Chief Executive	NA	Permanent	NA	sara.todd@trafford.gov.uk	190000 - 194999	NA	NA	Spot salary - there is no grading structure for this role and therefore there is no salary 'range' applicable
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Mon Jul 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2	Corporate Director of Adults and Wellbeing	NA	Spot salary	Adults Services	NA	Permanent	NA	access.trafford@trafford.gov.uk	125000 - 129999	NA	NA	Spot salary - there is no grading structure for this role and therefore there is no salary 'range' applicable
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Mon Jul 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3	Programme Director	NA	SM3A	Adults Services	Commissioning	Permanent	NA	access.trafford@trafford.gov.uk	95000 - 99999	98908	NA	NA
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Mon Jul 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3	Director of Adults	NA	SM3A	Adults Services	Adults Services	Permanent	NA	access.trafford@trafford.gov.uk	95000 - 99999	98908	NA	NA
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Mon Jul 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3	Assistant Director of Provider Services	NA	SM3B	Adults Services	Adults Services	Permanent	NA	access.trafford@trafford.gov.uk	90000 - 94999	91549	NA	NA
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Mon Jul 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3	Strategic Lead for Quality & Governance	NA	SM4A	Adults Services	Adults Services	Permanent	NA	access.trafford@trafford.gov.uk	70000 - 74999	79139	NA	NA
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Mon Jul 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3	Director of All Age Commissioning	NA	SM3A	Adults Services	All Age Commissioning	Permanent	NA	access.trafford@trafford.gov.uk	95000 - 99999	98908	NA	NA
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Mon Jul 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3	Director of Public Health	NA	Spot salary	Adults Services	Public Health	Permanent	NA	access.trafford@trafford.gov.uk	105000 - 109999	NA	NA	Spot salary - there is no grading structure for this role and therefore there is no salary 'range' applicable
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Mon Jul 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3	Deputy Director of Public Health	NA	SM3A	Adults Services	Public Health	Permanent	NA	access.trafford@trafford.gov.uk	NA	98908	Vacant	NA
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Mon Jul 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	4	Strategic & Neighbourhood Lead Central	NA	SM4A	Adults Services	Neighbourhood Team Central	Permanent	NA	access.trafford@trafford.gov.uk	75000 - 79999	79139	NA	NA


CREATE TABLE senior_structure_dataset (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "level" BIGINT,
  "jobtitle" VARCHAR,
  "name" VARCHAR,
  "grade" VARCHAR,
  "directorate" VARCHAR,
  "service" VARCHAR,
  "contracttype" VARCHAR,
  "sharedpost" VARCHAR,
  "contactdetails" VARCHAR,
  "salaryband" VARCHAR,
  "maximumsalary" VARCHAR,
  "vacancy" VARCHAR,
  "comments" VARCHAR
);

Trafford Council - Organisation Chart

Table List

Senior Structure Dataset

@ukgov.trafford_council_organisation_chart.senior_structure_dataset

organisationlabel

organisationuri

effectivedate

level

jobtitle

name

grade

directorate

service

contracttype

sharedpost

contactdetails

salaryband

maximumsalary

vacancy

comments

Share link