ADR Metadata Catalogue

ADR  > Welsh Demographic Service Dataset (WDSD) - Legacy three-view version @ 365

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+Datas

Legacy metadata for the discontinued three-view WDSD version. The views now provisioned to new projects have &#039;SINGLE&#039; in their title and are found in the main WDSD metadata entry, which is separate to this one.

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.

SAIL Databank (Wales)

Digital Health and Care Wales (DHCW)

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

A three-view WDS table. 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 e.g. date of birth/death, gender, etc.

AR_PERS

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.

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

AVAIL_FROM_DT

The encrypted unique identifier for each person registered on the Welsh Demographic Service.

PERS_ID_PE

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

A three-view WDS table. Complete address history for those in AR_PERS, including at LSOA geography-level. Known issues include full-time students, people failing to notify GPs of change in address, and/or people registering with multiple GPs [de-registration of patients]. Continuous periods of residency may not exist; gaps of more than 30 days are flagged.

AR_PERS_ADD

End of period of residence. 9999-01-01 if current or end date not known.

TO_DT

Indicates whether GP practice has been activated with SAIL [a] or not activated [d]

ROW_STS

The status code generated when deriving RALF_PE [for the encrypted residence identifier - Residence Anonymised Linking Field]. RALF_PE is itself is 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_STS_CD

FROM_DT

Unique Property Reference Number [UPRN] quality match code. UPRN is a unique identifier for every spatial address in Great Britain, maintained by Ordnance Survey. UPRN provides comprehensive, complete, consistent identifier throughout a property&#039;s life cycle - from planning permission through to demolition.

UPRN_QAS_MATCH_CD

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

A three-view WDS table. GP registration history for people registered with GP practices in Wales; primary care-level data related to the Welsh Demographic Service. Information is excluded for those Welsh residents that are registered with a GP practice in England. Each row is a separate GP registration period. Covers all Practices (not just SAIL) and this is flagged.

AR_PERS_GP

This is the encrypted code of the patient&#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

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

Person identifier [encrypted] within the GP practice.

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 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_E

A cleaned version of the address history information from the three-view Welsh Demographic Service (ar_pers_add table). 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&#039;t likely represent a move out of Wales and therefore shouldn&#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_CLEAN_ADD_GEOG_CHAR_LSOA2001

A date reflecting when the cleaning process was run.

AVAILABLE_FROM

End date of this follow-up period (inclusive)

END_DATE

Lower Super Output Area code associated with the 2001 census.

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 version of the address history information from the three-view Welsh Demographic Service (ar_pers_add table). 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&#039;t likely represent a move out of Wales and therefore shouldn&#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.

WDSD_CLEAN_ADD_GEOG_CHAR_LSOA2011

Lower Super Output Area code associated with the 2011 census.

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

See clean_add_geog_char_LSOA2001 (this table is a subset of the columns it has)

WDSD_CLEAN_ADD_LSOA2001

See clean_add_geog_char_LSOA2011 (this table is a subset of the columns it has)

WDSD_CLEAN_ADD_LSOA2011

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 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.

A cleaned version of the three-view Welsh Demographic Service (AR_PERS table). Contains 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 e.g. date of birth/death, gender, etc.

WDSD_CLEAN_AR_PERS

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

This is the sex (gender) of the person. 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

A cleaned version of the address history information from the three-view Welsh Demographic Service (ar_pers_add table). 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&#039;t likely represent a move out of Wales and therefore shouldn&#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&#039;s anonymous household ID (Residential Anonymised Linking Field - RALF), and additionally provides LSOA 2001 codes.

WDSD_CLEAN_ADD_RALF_LSOA2001

Lower Super Output Area (LSOA) code from the 2001 census.

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

RALF_E

A cleaned version of the address history information from the three-view Welsh Demographic Service (ar_pers_add table). 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&#039;t likely represent a move out of Wales and therefore shouldn&#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&#039;s anonymous household ID (Residential Anonymised Linking Field - RALF), and additionally provides LSOA 2011 codes.

WDSD_CLEAN_ADD_RALF_LSOA2011

A cleaned version of the address history information from the three-view Welsh Demographic Service (ar_pers_add table). 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&#039;t likely represent a move out of Wales and therefore shouldn&#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_CLEAN_ADD_WALES

A cleaned version of the address history information from the three-view Welsh Demographic Service, containing the Residential Anonymous Linking Field (RALF). 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&#039;t likely represent a move out of Wales and therefore shouldn&#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&#039;s anonymous household ID (Residential Anonymised Linking Field - RALF).

WDSD_CLEAN_GEO_RALF

Legacy three-view version of WDSD, which is now depreciated and replaced by a single-view version. Register of all individuals registered with a Welsh GP, includes individuals anonymised address and practice history.

Welsh Demographic Service Dataset (WDSD) - Legacy three-view version

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin