Trade Union Facility Time

Leeds City Council

@ukgov.trade_union_facility_time

Table List

2 tables(34.11 KB)

Education 2017/18 - 2019/20

Council 2012/13 - 2019/20

Council 2012/13 - 2019/20

@ukgov.trade_union_facility_time.council_2012_13_2019_20

17.95 KB
10 rows
21 columns

organisationlabel OrganisationLabel	organisationuri OrganisationURI	effectivedate EffectiveDate	period Period	gmbofficials GMBOfficials	unisonofficials UNISONOfficials	uniteofficials UNITEOfficials	ulrcoordinators ULRCoordinators	ulrleads ULRLeads	totalrepresentativecount_headcount_includes_c_ulrc_ulr_40066b11 TotalRepresentativeCount (Headcount) Includes C/ULRC/ULRL @ End Of Reporting Period	n__spentonfacilitytime0 %SpentOnFacilityTime0%	n__spentonfacilitytime1_50 %SpentOnFacilityTime1-50%	n__spentonfacilitytime51_99 %SpentOnFacilityTime51-99%	n__spentonfacilitytime100 %SpentOnFacilityTime100%	fterepresentativecount_includes_c_ulrc_ulrl_end_of_rep_885258a4 FTERepresentativeCount Includes C/ULRC/ULRL @ End Of Reporting Period	totalrepresentativesmajoritydutycount_devote_50_or_mor_ea691ad0 TotalRepresentativesMajorityDutyCount (devote 50% Or More Time To TU Work) * Inc C/ULRC	fterepresentativemajoritydutycounter_devote_50_or_more_3035b563 FTERepresentativeMajorityDutyCounter (devote 50% Or More Time To TU Work) Include C/ULRC	n__timeontuactivities_total_hours_spent_on_paid_activi_ac2ea4c0 %TimeOnTUActivities (total Hours Spent On Paid Activities ÷ Total Paid Facility Time Hours) X 100	totalestimatespendingamount TotalEstimateSpendingAmount	totalpaybill TotalPayBill	relativeestimatespending_of_total_pay_bill RelativeEstimateSpending % Of Total Pay Bill
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	30/04/2013	2012/13	NA	NA	NA	NA	NA	27	NA	NA	NA	NA	16.69	16	15.5	NA	£508,882	NA	0.12%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	30/04/2014	2013/14	NA	NA	NA	NA	NA	23	NA	NA	NA	NA	15.86	16	15.1	NA	£483,104	NA	0.11%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	30/04/2015	2014/15	NA	NA	NA	NA	NA	27	NA	NA	NA	NA	15.3	17	14.4	NA	£487,776	NA	0.11%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	30/04/2016	2015/16	NA	NA	NA	NA	NA	28	NA	NA	NA	NA	17	18	15.63	NA	£502,095	NA	0.12%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	30/04/2017	2016/17	NA	NA	NA	NA	NA	28	NA	NA	NA	NA	17.11	20	16.67	NA	£486,945	NA	0.11%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	30/04/2018	2017/18	9	12	2	2	8	33	0	15	7	11	17.62	27	15.76	100	£494,399	£428,824,930	0.12%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	30/04/2019	2018/19	10	10	2	2	8	32	0	12	8	12	18.27	20	NA	100	£500,499.99	£449,934,360	0.11%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	30/04/20192019/20		9	10	2	4	0	25	0	5	13	7	18.37	25	NA	100	£580,707.52	474965610	0.12%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	30/04/2020	2020/21	10	12	2	3	0	27	0	6	1	20	19.18	27	NA	100	£552,123.56	£494,343,920	0.11%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	30/04/2021	2021/22	9	12	2	3	0	26	0	4	0	22	19.96	26		100	£660,375.65	474,951,380	0.14%


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
);