ADR Metadata Catalogue

ADR  > Healthcare Workers Risk Assessment (HWRA) @ 341

https://saildatabank.com/about-us/

This dataset provides limited information about which NHS workers completed Risk Assessments in the course of normal work.

SAIL Databank (Wales)

NHS Wales Shared Services Partnership

Anonymised Linking Field (ALF), Encrypted.  This field is derived from by double encryption after splitting demographic information and clinical information; the first encryption occurs in NHS Wales Informatics Service (NWIS), and the second in SAIL. If the NHS number is not supplied in the data extract, then matching methods are applied; please refer to ALF_MTCH_PCT.

ALF_E

This table provides data linkages to SAIL and HWRA data via unique IDs, and can provide general background location data [e.g. LHB].

HEALTHCARE_WORKERS_ALF

Anonymised Linked Field Match Percentage.  This number is a match % score from probabalistic matching, when joining together anonymised data. This linkage process consists of matching against the Welsh Demographic Service by NHS number, where a valid number exists, and where there is no valid number then matching is attempted using first name, surname, date of birth, and postcode. This is an artificial score with no real-world meaning; i.e. a match of .99 does not mean there is a 99% chance the match is correct.  This number is assigned when deriving the Encrypted Anonymised Linking Field.

ALF_MTCH_PCT

Anonymised Linked Field Status Code.  This is assigned when deriving the Encrypted Anonymised Linking Field.

ALF_STS_CD

Date when the data made available i.e. date of loading

AVAIL_FROM_DT

The date of the current extract data held within SAIL.

EXTRACT_DT

This is a placeholder. Field is blank/NULL.

FIELD_2

FIELD_3

FIELD_4

This is the sex (gender) of person, employee or patient. Can potentially assist in correct identification of gender-specific primary cancer sites. Can potentially be different from gender identity as stated/assigned at birth.

GNDR_CD

This is the Local Health Board where the worker normally is employed.

The code for the 2001 Local Super Output Area [LSOA] of residence; this is a code created and maintained by Office for National Statistics.  Not to be confused with LSOA name or other LSOA fields.

LSOA2001_CD

PROCESSED_DATE

Encrypted Unique HWRA ID reference number for data linkage.

SYSTEM_ID_E

The date of the Monday that occurs prior, or on, the actual date of birth. Access to this data item is limited, however, as it can be used to calculate age at specific events. Possible errors in extract may include patients with events and event dates before WOB.

HEALTHCARE_WORKERS_ALF_PRV

This tables provides an overview of the specific role and staff group than an individual healthcare worker has within an organisation.

HEALTHCARE_WORKERS_RA

This refers to the specific NHS Trust to which the health worker is attached, e.g. Cardiff and Vale, Aneurin Bevan, etc.

ORGANISATION

Specifies the role the health worker has within the organisation, e.g. Porter, Staff Nurse, Clerical Worker, etc.

ROLE

This relates to the specific staff group to which the worker is attached, e.g. Medical and Dental, Nursing and Midwifery Registered, Estates and Ancillary, etc.

Healthcare Workers Risk Assessment (HWRA)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin