About this Dataset

Trade Union Facility Time

This dataset shows staff time allocated to trade union activities. Please note ----------- * Data is based on trade union roles/facilties time recorded corporately * C= convenors * ULRC = Union Learn Representative Co-Ordinator * ULRL = Union Learn Representative Lead * Costs are based on basic pay with oncost and also include accommodation costs * Trade union spend is calculated as a percentage of the total pay bill to provide a basic estimate of spending on facilities time * For the purpose of collective bargaining Leeds City Council recognises the following trade unions :UNITE, UNISON, UCATT & GMB and primarily in schools: ATL, ASCL, NUT, NAHT & NASUWT * Trade Unions have confirmed all activities i.e. attending conferences, meeting regional officers, branch and regional meetings are carried out within the agreed facilities time. * Teaching Trade Unions have confirmed that they carry out activities in their own time i.e. attending conferences, meeting regional officers, branch and regional meetings. Local Government Transparency Code 2015 --------------------------------------- * This is a key dataset which the government wants local authorities to publish. * https://www.gov.uk/government/publications/local-government-transparency-code-2015 Trade Union Facility Time Publication Regulation 2017 ----------------------------------------------------- * The purpose of these regulations is to promote transparency and allow for public scrutiny of facility time. * Additional information is required over and above the Local Government Transparency Code. This information has been included from 2017/18. * https://www.gov.uk/government/publications/trade-union-facility-time-publication-requirements From 2018 we no longer record the figure of representatives spending more than 50% of their time on Trade union activities.
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:52:08Z

Tables

Council 2012/13 - 2019/20

@ukgov.trade_union_facility_time.council_2012_13_2019_20

17.95 KB
10 rows
21 columns


CREATE TABLE council_2012_13_2019_20 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" VARCHAR,
  "period" VARCHAR,
  "gmbofficials" VARCHAR,
  "unisonofficials" VARCHAR,
  "uniteofficials" VARCHAR,
  "ulrcoordinators" VARCHAR,
  "ulrleads" VARCHAR,
  "totalrepresentativecount_headcount_includes_c_ulrc_ulr_40066b11" BIGINT,
  "n__spentonfacilitytime0" VARCHAR,
  "n__spentonfacilitytime1_50" VARCHAR,
  "n__spentonfacilitytime51_99" VARCHAR,
  "n__spentonfacilitytime100" VARCHAR,
  "fterepresentativecount_includes_c_ulrc_ulrl_end_of_rep_885258a4" DOUBLE,
  "totalrepresentativesmajoritydutycount_devote_50_or_mor_ea691ad0" BIGINT,
  "fterepresentativemajoritydutycounter_devote_50_or_more_3035b563" VARCHAR,
  "n__timeontuactivities_total_hours_spent_on_paid_activi_ac2ea4c0" VARCHAR,
  "totalestimatespendingamount" VARCHAR,
  "totalpaybill" VARCHAR,
  "relativeestimatespending_of_total_pay_bill" VARCHAR
);

Education 2017/18 - 2019/20

@ukgov.trade_union_facility_time.education_2017_18_2019_20

16.16 KB
5 rows
19 columns


CREATE TABLE education_2017_18_2019_20 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "period" VARCHAR,
  "atlofficials" BIGINT,
  "nasuwtofficials" BIGINT,
  "nutofficials" BIGINT,
  "nahtcoordinators" BIGINT,
  "gmbleads" BIGINT,
  "totalrepresentativecount_headcount_includes_c_ulrc_ulr_40066b11" BIGINT,
  "n__spentonfacilitytime0" DOUBLE,
  "n__spentonfacilitytime1_50" BIGINT,
  "n__spentonfacilitytime51_99" BIGINT,
  "n__spentonfacilitytime100" BIGINT,
  "fterepresentativecount" DOUBLE,
  "n__timeontuactivities_total_hours_spent_on_paid_activi_ac2ea4c0" BIGINT,
  "totalestimatespendingamount" VARCHAR,
  "totalpaybill" VARCHAR,
  "relativeestimatespending_of_total_pay_bill" VARCHAR
);