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

18.38 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  -- TotalRepresentativeCount (Headcount) Includes C/ULRC/ULRL @ End Of Reporting Period,
  "n__spentonfacilitytime0" VARCHAR  -- %SpentOnFacilityTime0%,
  "n__spentonfacilitytime1_50" VARCHAR  -- %SpentOnFacilityTime1-50%,
  "n__spentonfacilitytime51_99" VARCHAR  -- %SpentOnFacilityTime51-99%,
  "n__spentonfacilitytime100" VARCHAR  -- %SpentOnFacilityTime100%,
  "fterepresentativecount_includes_c_ulrc_ulrl_end_of_rep_885258a4" DOUBLE  -- FTERepresentativeCount Includes C/ULRC/ULRL @ End Of Reporting Period,
  "totalrepresentativesmajoritydutycount_devote_50_or_mor_ea691ad0" BIGINT  -- TotalRepresentativesMajorityDutyCount (devote 50% Or More Time To TU Work) * Inc C/ULRC,
  "fterepresentativemajoritydutycounter_devote_50_or_more_3035b563" VARCHAR  -- FTERepresentativeMajorityDutyCounter (devote 50% Or More Time To TU Work) Include C/ULRC,
  "n__timeontuactivities_total_hours_spent_on_paid_activi_ac2ea4c0" VARCHAR  -- %TimeOnTUActivities (total Hours Spent On Paid Activities ÷ Total Paid Facility Time Hours) X 100,
  "totalestimatespendingamount" VARCHAR,
  "totalpaybill" VARCHAR,
  "relativeestimatespending_of_total_pay_bill" VARCHAR  -- RelativeEstimateSpending % Of Total Pay Bill
);

Education 2017/18 - 2019/20

@ukgov.trade_union_facility_time.education_2017_18_2019_20

16.55 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  -- TotalRepresentativeCount (Headcount) Includes C/ULRC/ULRL @ End Of Reporting Period,
  "n__spentonfacilitytime0" DOUBLE  -- %SpentOnFacilityTime0%,
  "n__spentonfacilitytime1_50" BIGINT  -- %SpentOnFacilityTime1-50%,
  "n__spentonfacilitytime51_99" BIGINT  -- %SpentOnFacilityTime51-99%,
  "n__spentonfacilitytime100" BIGINT  -- %SpentOnFacilityTime100%,
  "fterepresentativecount" DOUBLE,
  "n__timeontuactivities_total_hours_spent_on_paid_activi_ac2ea4c0" BIGINT  -- %TimeOnTUActivities (total Hours Spent On Paid Activities ÷ Total Paid Facility Time Hours) X 100,
  "totalestimatespendingamount" VARCHAR,
  "totalpaybill" VARCHAR,
  "relativeestimatespending_of_total_pay_bill" VARCHAR  -- RelativeEstimateSpending % Of Total Pay Bill
);