TfGM Organisation Structure
Transport for Greater Manchester
@ukgov.tfgm_organisation_structure
Transport for Greater Manchester
@ukgov.tfgm_organisation_structure
CREATE TABLE organisation_structure (
"organisationlabel" VARCHAR,
"applicabledate" TIMESTAMP,
"level" DOUBLE,
"jobtitle" VARCHAR,
"name" VARCHAR,
"grade" VARCHAR,
"organisationalunit" VARCHAR,
"service" VARCHAR,
"contracttype" VARCHAR,
"contactdetails" VARCHAR,
"salary_band_range" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR
);
Anyone who has the link will be able to view this.