ADR Metadata Catalogue

ADR  > Care and Repair Cymru (CARC) @ 1573

https://academic.oup.com/ageing/article/51/1/afab201/6399893, https://careandrepair.org.uk/

CARC contains client and service level information of all services provided by Care and Repair Cymru from 2009 to
2023, including programme and funding type and amount, service type and service start and end dates. This
dataset also contains Hospital to Healthier Homes programme data which runs from 2019 to 2023.

SAIL Databank (Wales)

Anyone in the home, in the last year tripped or fallen

ANYONE_IN_THE_HOME_IN_THE_LAST_YEAR_TRIPPED_OR_FALLEN

CANDR_20180606

APPROX__PROPERTY_AGE

Date when the data made available in SAIL i.e. date of loadin

AVAIL_FROM_DT

CLIENT_AGE

This is the sex (gender) of person, employee or patient. Can potentially be different from gender identity as stated/assigned at birth.

GENDER

HAS_DISABILITY

HOUSEHOLD_TYPE

LIVES_ALONE

PROPERTY_CLASSIFICATION

PROPERTY_TYPE

REQUEST_DATE

SERVICEREQUEST_REQUEST_CLOSED_DATE

SERVICE_REQUEST_TYPE

SERVICE_TYPE

TENURE

TOTAL_VALUE_OF_WORK

UNIQUE_IDENTIFIER_E

WORK_END_DATE

WORK_START_DATE

WORK_TYPE

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

CANDR_ALF_20180606

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

Status code assigned when deriving the Encrypted Anonymised Linking Field.

ALF_STS_CD

EXTRACT_DT

FIELD_1

FIELD_2

FIELD_3

FIELD_4

GNDR_CD

Lower Layer Super Output Area (LSOA) code in which the patient is resident, for a previous version of LSOA codes (2001)

LSOA2001_CD

The date the extract file was processed by the matching and anonymisation algorithm.

PROCESSED_DATE

CANDR_RALF_20180927

ENV_METRIC_1

ENV_METRIC_2

ENV_METRIC_3

ENV_METRIC_4

ENV_METRIC_5

ENV_METRIC_6

ENV_METRIC_7

ENV_METRIC_8

ENV_METRIC_9

LSOA_CD_2001

The&amp;nbsp;2011&amp;nbsp;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.

LSOA_CD_2011

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_E

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

SYSTEM_ID_E

UPRN_QAS_MATCH_CD

ANYONE_IN_THE_HOME_IN_THE_LAST_YEAR_TRIPPED_OR_FALLEN_

CARC_C1_20241003

APPROXIMATE_AGE_

CLIENT_REF_E

CREATE_DATE

FACILITATES_HOSPITAL_DISCHARGE_ADMISSION

SERVICE_REQUEST_CLOSE_DATE

SERVICE_REQUEST_REF_E

CARC_C1_ALF_20241003

LSOA2011_CD

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.

CARC_C2_20241003

APPROX_AGE_OF_PROPERTY

CASE_REF_E

LIVES_ALONE_

CARC contains client and service level information of all services provided by Care and Repair Cymru.

Care and Repair Cymru (CARC)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin