ADR Metadata Catalogue

ADR  > Welsh Demographic Service Dataset (WDSD) @ 359

https://saildatabank.com/about-us/, https://popdatasci.swan.ac.uk/centres-of-excellence/sail/, https://saildatabank.com/, https://docs.hiru.swan.ac.uk/display/SATP/WDSD+-+Welsh+Demographic+Service+Dataset

Administrative information about individuals in Wales that use NHS services; such as address and practice registration history. It replaced the NHS Wales Administrative Register (NHSAR) in 2009.

Data drawn from GP practices via Exeter System.

This dataset provides linkage from anonymous individual to anonymous residences, thus enable to group households of individuals.

The single views are now provisioned to new projects and described here, the metadata for the old three-view WDSD version can be found in a separate legacy metadata entry.

SAIL Databank (Wales)

Digital Health and Care Wales (DHCW)

Person identifier [encrypted] within the GP practice. The single view WDS person ID system does not correspond to PERS_ID_E in the older three view versions of WDS.

WDSPERSONID_PE

Single-view WDS table from Digital Health and Care Wales (DHCW), which superseded the old three-view WDS tables. Contains ALF_PE, date of birth/death, GNDR_CD, RALF_PE, LSOA 2001 and 2011 codes, and encrypted GP practice code.

PER_RESIDENCE_GPREG

Encrypted Anonymised Linking Field (ALF). This field is derived from by double encryption after splitting demographic information and clinical information; the first encryption occurs in Digital Health and Care Wales (DHCW), 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_PE

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.

The date [if known] on which a person died or is officially deemed to have died.

DEATH_DT

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. 5 possible status-levels

GNDR_CD

This is the encrypted residence identifier [Residence Anonymised Linking Field], derived from the persons postal address, which allows researchers to associate individuals within the same home, and carry out health geographic studies without knowing the actual location of the properties in space.

RALF_PE

The ***2001*** code for the 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. 1909 LSOAs exist in Wales (2011 data); these have a minimum population of 1000, and a max population of 3000. The minimum number of households is 400, and the maximum number of households is 1200. If these thresholds are breached, then LSOAs are either split or merged; however this is uncommon.

LSOA2001_CD

The ***2011*** code [different from 2001] for the 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. 1909 LSOAs exist in Wales (2011 data); these have a minimum population of 1000, and a max population of 3000. The minimum number of households is 400, and the maximum number of households is 1200. If these thresholds are breached, then LSOAs are either split or merged; however this is uncommon.

LSOA2011_CD

This is the encrypted code of the patient&amp;amp;amp;#039;s registered General Practitioner (GP) Practice. This allows the practice to be notified about treatment received by the patient. The registered GP Practice may or may not be the same as the referring GP Practice. Original codes are updated monthly by Digital Health and Care Wales (DHCW) with information supplied by the Organisation Data Service (ODS) and can be viewed on the Health Reference Data Web Pages on HOWIS.

PRAC_CD_PE

Start of period at residence and GP practice.

ACTIVEFROM

End of period of residence and GP practice. 9999-01-01 or NULL if current or end date not known.

ACTIVETO

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

AVAIL_FROM_DT

A cleaned single-view Welsh Demographic Service (WDS) AR_PERS table from Digital Health and Care Wales (DHCW), which superseded the older three-view WDS tables. Records of people [living or deceased] who have both lived in Wales, and have ever registered with a GP practice in Wales. Provides demographic details: ALF, date of birth/death, GNDR_CD.

WDSD_SINGLE_CLEAN_AR_PERS

A date reflecting when the cleaning process was run.

AVAILABLE_FROM

The date [if known] on which a PERSON died or is officially deemed to have died.

A cleaned table of address history from the single-view Welsh Demographic Service (WDS) table from Digital Health and Care Wales (DHCW), which superseded the older three-view WDS tables. The cleaning involves the following: removing errors such as duplicate or overlapping records; closing gaps of up to 30 days, since a short gap doesn&amp;amp;amp;#039;t likely represent a move out of Wales and therefore shouldn&amp;amp;amp;#039;t be a gap in the followup period; joining consecutive records with the same information to make processing easier; and extending follow-up time to birth when records start within 6 weeks of birth. Several versions of this table are created, combining records at different geography levels. This one uses LSOA 2001 code level, and characteristics associated with LSOA codes added.

WDSD_SINGLE_CLEAN_GEO_CHAR_LSOA2001

A cleaned table of address history from the single-view Welsh Demographic Service (WDS) table from Digital Health and Care Wales (DHCW), which superseded the older three-view WDS tables. The cleaning involves the following: removing errors such as duplicate or overlapping records; closing gaps of up to 30 days, since a short gap doesn&amp;amp;amp;#039;t likely represent a move out of Wales and therefore shouldn&amp;amp;amp;#039;t be a gap in the followup period; joining consecutive records with the same information to make processing easier; and extending follow-up time to birth when records start within 6 weeks of birth. Several versions of this table are created, combining records at different geography levels. This one uses LSOA 2001 code level, and characteristics associated with LSOA codes added. Note: this view will only be provisioned to SAIL projects which have explicit approval for LSOA 2001 in their Information Governance Review Panel document.

End date of this follow-up period (inclusive)

END_DATE

LSOA2001_DESC

Start date of this follow-up period (inclusive)

START_DATE

Whether this is a Welsh LSOA code. 1=yes, 0=no

WELSH_ADDRESS

Welsh Index of Multiple Deprivation 2011 overall index decile. 1=most deprived.

WIMD_2011_DECILE

WIMD_2011_DECILE_DESC

Welsh Index of Multiple Deprivation 2011 overall index quintile. 1=most deprived.

WIMD_2011_QUINTILE

WIMD_2011_QUINTILE_DESC

Welsh Index of Multiple Deprivation 2011 overall index ranking of all Welsh LSOAs starting with 1 as most deprived.

WIMD_2011_RANK

Welsh Index of Multiple Deprivation 2011 overall index score.

WIMD_2011_SCORE

A cleaned table of address history from the single-view Welsh Demographic Service (WDS) table from Digital Health and Care Wales (DHCW), which superseded the older three-view WDS tables. The cleaning involves the following: removing errors such as duplicate or overlapping records; closing gaps of up to 30 days, since a short gap doesn&amp;amp;amp;#039;t likely represent a move out of Wales and therefore shouldn&amp;amp;amp;#039;t be a gap in the followup period; joining consecutive records with the same information to make processing easier; and extending follow-up time to birth when records start within 6 weeks of birth. Several versions of this table are created, combining records at different geography levels. This one uses LSOA 2011 code level, and characteristics associated with LSOA codes added. Note: this view will only be provisioned to SAIL projects which have explicit approval for LSOA 2011 in their Information Governance Review Panel document.

WDSD_SINGLE_CLEAN_GEO_CHAR_LSOA2011

LSOA2011_DESC

Another LSOA description (We are seeking clarification of the precise meaning of 3 different LSOA descriptions)

LSOA2011_ONS_DESC

LSOA_DESC

Townsend deprivation index (https://statistics.ukdataservice.ac.uk/dataset/2011-uk-townsend-deprivation-scores) quintile for this LSOA.

TOWNSEND_2011_QUINTILE

TOWNSEND_2011_QUINTILE_DESC

Townsend deprivation score for this LSOA.

TOWNSEND_2011_SCORE

Welsh Index of Multiple Deprivation 2014 overall index decile. 1=most deprived.

WIMD_2014_DECILE

WIMD_2014_DECILE_DESC

Welsh Index of Multiple Deprivation 2014 overall index quartile. 1=most deprived.

WIMD_2014_QUARTILE

WIMD_2014_QUARTILE_DESC

Welsh Index of Multiple Deprivation 2014 overall index quintile. 1=most deprived.

WIMD_2014_QUINTILE

WIMD_2014_QUINTILE_DESC

Welsh Index of Multiple Deprivation 2014 overall index ranking of all Welsh LSOAs starting with 1 as most deprived.

WIMD_2014_RANK

Welsh Index of Multiple Deprivation 2014 overall index score.

WIMD_2014_SCORE

Welsh Index of Multiple Deprivation 2019 overall index decile. 1=most deprived.

WIMD_2019_DECILE

WIMD_2019_DECILE_DESC

Welsh Index of Multiple Deprivation 2019 overall index quartile. 1=most deprived.

WIMD_2019_QUARTILE

WIMD_2019_QUARTILE_DESC

Welsh Index of Multiple Deprivation 2019 overall index quintile. 1=most deprived.

WIMD_2019_QUINTILE

WIMD_2019_QUINTILE_DESC

Welsh Index of Multiple Deprivation 2019 overall index ranking of all Welsh LSOAs starting with 1 as most deprived.

WIMD_2019_RANK

A cleaned version of the new single-view Welsh Demographic Service (WDS) table from Digital Health and Care Wales (DHCW), which supersedes the three-view WDS tables. The cleaning involves the following: removing errors such as duplicate or overlapping records; closing gaps of up to 30 days, since a short gap doesn&amp;amp;amp;#039;t likely represent a move out of Wales and therefore shouldn&amp;amp;amp;#039;t be a gap in the followup period; joining consecutive records with the same information to make processing easier; and extending follow-up time to birth when records start within 6 weeks of birth. Several versions of this table are created, combining records at different geography levels. This one presents data at the household level, using SAIL&amp;amp;amp;#039;s anonymous household ID (Residential Anonymised Linking Field - RALF). Note: this view will only be provisioned to SAIL projects which have explicit approval for the RALF in their Information Governance Review Panel document.

WDSD_SINGLE_CLEAN_GEO_RALF

Residential Anonymous Linking Field (RALF), Encrypted. Anonymous household identifier. See information here: https://academic.oup.com/jpubhealth/article/31/4/582/1494003

A cleaned version of the new single-view Welsh Demographic Service (WDS) table from Digital Health and Care Wales (DHCW), which supersedes the three-view WDS tables. The cleaning involves the following: removing errors such as duplicate or overlapping records; closing gaps of up to 30 days, since a short gap doesn&amp;amp;amp;#039;t likely represent a move out of Wales and therefore shouldn&amp;amp;amp;#039;t be a gap in the followup period; joining consecutive records with the same information to make processing easier; and extending follow-up time to birth when records start within 6 weeks of birth. Several versions of this table are created, combining records at different geography levels. This one presents data at the household level, using SAIL&amp;amp;amp;#039;s anonymous household ID (Residential Anonymised Linking Field - RALF), and and additionally provides LSOA 2001 codes. Note: this view will only be provisioned to SAIL projects which have explicit approval for LSOA 2001 and RALF in their Information Governance Review Panel document.

WDSD_SINGLE_CLEAN_GEO_RALF_LSOA2001

RALF_E

A cleaned version of the new single-view Welsh Demographic Service (WDS) table from Digital Health and Care Wales (DHCW), which supersedes the three-view WDS tables. The cleaning involves the following: removing errors such as duplicate or overlapping records; closing gaps of up to 30 days, since a short gap doesn&amp;amp;amp;#039;t likely represent a move out of Wales and therefore shouldn&amp;amp;amp;#039;t be a gap in the followup period; joining consecutive records with the same information to make processing easier; and extending follow-up time to birth when records start within 6 weeks of birth. Several versions of this table are created, combining records at different geography levels. This one presents data at the household level, using SAIL&amp;amp;amp;#039;s anonymous household ID (Residential Anonymised Linking Field - RALF), and additionally provides LSOA 2011 codes. Note: this view will only be provisioned to SAIL projects which have explicit approval for RALF and LSOA 2011 in their Information Governance Review Panel document.

WDSD_SINGLE_CLEAN_GEO_RALF_LSOA2011

A cleaned version of the address history from the new single-view Welsh Demographic Service (WDS) table from Digital Health and Care Wales (DHCW), which supersedes the three-view WDS tables. The cleaning involves the following: removing errors such as duplicate or overlapping records; closing gaps of up to 30 days, since a short gap doesn&amp;amp;amp;#039;t likely represent a move out of Wales and therefore shouldn&amp;amp;amp;#039;t be a gap in the followup period; joining consecutive records with the same information to make processing easier; and extending follow-up time to birth when records start within 6 weeks of birth. Several versions of this table are created, combining records at different geography levels. This one presents data at the the all Wales level, making it a simple measure of Welsh residence for follow-up purposes. Because all consecutive records of residing in Wales will be joined together, a single period of living in Wales will always be a single record in this table for a given individual. Requirements for continuous follow-up can always be applied by searching for a single record.

WDSD_SINGLE_CLEAN_GEO_WALES

Register of all individuals registered with a Welsh GP, includes individuals anonymised address and practice history.

Welsh Demographic Service Dataset (WDSD)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin