About this Dataset

Trade Union Facility Time

This dataset published by Lincolnshire County Council shows Trade Union facility time. It shows numbers of Trade Union representatives and estimates of spending on Trade Unions. The dataset is published by Lincolnshire County Council Human Resources, and is updated annually. For any enquiries relating to this publication, please e-mail: people_management@lincolnshire.gov.uk.
Publisher name: Lincolnshire County Council
Last updated: 2024-09-14T08:42:37Z

Tables

Table 1

@ukgov.trade_union_facility_time6.table_1

12.09 kB
18 rows
12 columns

CREATE TABLE table_1 (
  "dataset_id_dsid" BIGINT  -- Dataset ID (DSID),
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR  -- Mandatory Or Optional Requirement (MOR),
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);

Trade Union Facility Time

@ukgov.trade_union_facility_time6.trade_union_facility_time

16.47 kB
21 rows
19 columns

CREATE TABLE trade_union_facility_time (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "latestdata" VARCHAR,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "reportingperiodtype" VARCHAR,
  "reportingperiod" VARCHAR,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "function" VARCHAR,
  "totalrepresentativecount" BIGINT,
  "fterepresentativescount" DOUBLE,
  "totalrepresentativesmajoritydutycount" BIGINT,
  "fterepresentativesmajoritydutycount" DOUBLE,
  "totalestimatespendingamount" DOUBLE,
  "relativeestimatespending" DOUBLE
);