ADR Metadata Catalogue

ADR  > Critical Care Dataset (CCDS) @ 301

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/CCDS+-+Critical+Care+Dataset, https://www.datadictionary.wales.nhs.uk/#!WordDocuments/criticalcaredatasetccds2.htm

A good supplementary to hospital inpatient dataset (PEDW), covers the period of critical care patient received, including intensity of care (e.g. bed levels, organ support), treatment specialty, and outcome.

This dataset requires additional governance approvals from the data provider before data can be provisioned to a SAIL project.

SAIL Databank (Wales)

Digital Health and Care Wales

PAT_REG_GP_GEOGRAPHY_HEALTH_ORG_PREVIOUSNAME

The Critical Care Data Set captures all intensive and high dependency care activity regardless of the patient&amp;acirc;&amp;euro;&amp;trade;s area of residence. Velindre NHS Trust and Powys teaching Health Board do not provide critical care data as they do not provide these services.

CRITICAL_CARE_EPISODE

The period of time in hours between time of admission and time of discharge ready.

DUR_ADMIS_DISCH_READY_HOURS

Country name in which the patient is resident, based on the previous census.

PAT_STATS_PREV_CENSUS_COUNTRY_NAME

Current Site Code of Treatment (5 character code). The organisation code for the site where the patient will be or is treated.

TREAT_SITE_ORG_CURR_CD

The five year age band of the patient at date of admission.

PAT_ADMIS_AGE_FIVE_YEAR_BANDS

COUNT_CRITICAL_CARE_EPI

Admission Time Band. The time band, given as a range, in which the patient first occupies a designated critical care bed.

ADMIS_TM_BAND_A

COUNT_ADMIS_PREV_DISCH_SAME_TREAT_SITE_FORTY_EIGHT_HOURS

COUNT_EPI_ADMIS_UNPLANNED_DISCH_DELAYED

COUNT_EPI_LEVEL_TWO_THREE_DAYS_LESS_TOTAL

Current Name of Site of Treatment. The organisation name for the site where the patient will be or is treated.

TREAT_SITE_ORG_CURR_NAME

PAT_ID_E

PAT_REG_GP_CLUSTER_NAME

LAST_UPDATED_TS

UNIT_FUNCTION_CD

Derived code indicating the type of location the patient was in prior to the start of the Critical Care Period.

SOURCE_LOC_DERIVED_CD

Derived Admission Type Description. Description indicating whether a Critical Care Period was initiated as a result of a non-emergency treatment plan, for example, for elective major surgery. This relates only to the period of critical care and not to the nature of the hospital admission. For example, a planned hospital admission may unexpectedly require an emergency ICU admission, in which case the classification will be &amp;#039;01&amp;#039;

ADMIS_TYPE_DERIVED_DESC

SERVICE_AREA_DESC

PAT_URBAN_RURAL_CD

Current Name of Site of Treatment., for sites in Wales only. The organisation name for the site where the patient will be or is treated.

TREAT_SITE_ORG_CURR_NAME_WELSH_ONLY

Derived name of the Local Health Board (LHB) where the patient is a resident, identified via the NHS Postcode Directory. This ensures that the Local Health Board can receive information about the care given to its residents. Note: For English Residents treated in Wales, use the Organisation Code of the Primary Care Trust (PCT) of Residence for all activity / waiting times data up to 31st March 2013. From 1st April 2013 (inclusive) onwards, use the Organisation Code of the Clinical Commissioning Group (CCG).

PAT_RES_HEALTH_ORG_DERIVED_NAME

Country code in which the patient is resident, based on the previous census.

PAT_STATS_PREV_CENSUS_COUNTRY_CD

This is the total number of days that the patient received dermatological system support during a Critical Care Period. To be completed when the patient has been discharged from the Critical Care Unit or has died.

DUR_DERMATOLOGICAL_SUPPORT_DAYS

Current Provider Unit Code (3 character code), for health care providers in Wales only. This is the organisation code of the health care provider. The provider code identifies the health care provider who is responsible for managing the treatment of the patient. Notes: 1. Healthcare providers may also act as commissioners when sub-contracting patient care services to other providers of health care. 2. Although the healthcare provider identified in this data item is responsible for managing the patient&amp;acirc;&amp;euro;&amp;trade;s treatment, it may not necessarily be where the treatment is actually conducted. For example, where the treatment has been sub-contracted to another healthcare provider. 3. For OPRD (outpatient referral dataset), the Organisation Code (Code of Provider) is that of the organisation receiving the referral. If the provider is a Local Health Board/Trust, use the 3 character Local Health Board/Trust code with 2 zeros placed in the 4th and 5th character position. 4. For RTTD (Referral to Treatment Times (Combined)), use the 3 character Local Health Board/Trust code.

PROV_ORG_CURR_CD_WELSH_ONLY

COUNT_EPI_LEVEL_TWO_THREE_DAYS_ZERO

PAT_SEX_CD

TREAT_SITE_PARENT_CURR_CD

Discharge Date. This is the end date of a Critical Care Period. This occurs either when the patient dies or when the patient is transferred from the critical care unit. When the patient is transferred from a temporary area to a critical care unit or from one critical care unit to another, even within the same Local Health Board, this will be the end of the current Critical Care Period and the start of a new one.

DIS_DT

Discharge Satus Description. Description of the discharge status of a patient who is discharged from a Ward Stay where they were receiving care as part of a Critical Care Period and the discharge ends the Critical Care Period. It must be completed when the Critical Care Discharge Date is recorded.

DISCH_STS_DESC

Admission Type Description. Descrption indicating whether a Critical Care Period was initiated as a result of a non-emergency treatment plan, for example, for elective major surgery. This relates only to the period of critical care and not to the nature of the hospital admission. For example, a planned hospital admission may unexpectedly require an emergency ICU admission, in which case the classification will be &amp;#039;01&amp;#039;

ADMIS_TYPE_DESC

COUNT_ADMIS_UNPLANNED

PAT_SEX_DESC

Name of the Local Health Board (LHB) where the patient is a resident, identified via the NHS Postcode Directory. This ensures that the Local Health Board can receive information about the care given to its residents. Note: For English Residents treated in Wales, use the Organisation Code of the Primary Care Trust (PCT) of Residence for all activity / waiting times data up to 31st March 2013. From 1st April 2013 (inclusive) onwards, use the Organisation Code of the Clinical Commissioning Group (CCG).

PAT_RES_HEALTH_ORG_NAME

PAT_ID_SOURCE

Discharge Ready Date. The date on which the patient has been declared clinically ready for discharge or transfer from the Critical Care Period and a formal request has been made to the hospital bed management system (or appropriate staff with authority to admit at the intended destination) and the date and time of this status is recorded as such in the clinical record. Only to be completed if the patient has not died.

DIS_READY_DT

Derived Discharge Destination Description. Description of the primary organisation type that the patient has been discharged to at the end of the Critical Care Period. It must be completed when the Critical Care Discharge Date is recorded.

DISCH_DEST_DERIVED_DESC

This is the total number of days that the patient received renal system support during a Critical Care Period. To be completed when the patient has been discharged from the Critical Care Unit or has died.

DUR_RENAL_SUPPORT_DAYS

The ten year age band of the patient at date of discharge.

PAT_DISCH_AGE_TEN_YEAR_BANDS

PAT_REG_GP_GEOGRAPHY_HEALTH_ORG_CD

This is the total number of days that the patient received liver support during a Critical Care Period. To be completed when the patient has been discharged from the Critical Care Unit or has died.

DUR_LIVER_SUPPORT_DAYS

The period of time in seconds between time of previous discharge (at the same treatment site) and time of admission.

DUR_ADMIS_PREV_DISCH_SAME_TREAT_SITE_SECONDS

Current Name of the Local Health Board (LHB) where the patient is a resident, identified via the NHS Postcode Directory. This ensures that the Local Health Board can receive information about the care given to its residents. Note: For English Residents treated in Wales, use the Organisation Code of the Primary Care Trust (PCT) of Residence for all activity / waiting times data up to 31st March 2013. From 1st April 2013 (inclusive) onwards, use the Organisation Code of the Clinical Commissioning Group (CCG).

PAT_RES_HEALTH_ORG_CURR_NAME

Admission Time. The time the patient first occupies a designated critical care bed.

ADMIS_TM

DUR_DELAYED_TRANSFER_OF_CARE_HOURS

Derived Discharge Satus code. Code indicating the discharge status of a patient who is discharged from a Ward Stay where they were receiving care as part of a Critical Care Period and the discharge ends the Critical Care Period. It must be completed when the Critical Care Discharge Date is recorded.

DISCH_STS_DERIVED_CD

Current Organisation Code (3 character code). Code for the Local Health Board (LHB) where the patient is a resident, identified via the NHS Postcode Directory. This ensures that the Local Health Board can receive information about the care given to its residents. Note: For English Residents treated in Wales, use the Organisation Code of the Primary Care Trust (PCT) of Residence for all activity / waiting times data up to 31st March 2013. From 1st April 2013 (inclusive) onwards, use the Organisation Code of the Clinical Commissioning Group (CCG).

PAT_RES_HEALTH_ORG_CURR_CD

UNIT_FUNCTION_DERIVED_CD

Discharge Destination Description. Description of the primary organisation type that the patient has been discharged to at the end of the Critical Care Period. It must be completed when the Critical Care Discharge Date is recorded.

DISCH_DEST_DESC

Provider Organisation Name. This is the organisation name of the health care provider. The provider code identifies the health care provider who is responsible for managing the treatment of the patient. Notes: 1. Healthcare providers may also act as commissioners when sub-contracting patient care services to other providers of health care. 2. Although the healthcare provider identified in this data item is responsible for managing the patient&amp;acirc;&amp;euro;&amp;trade;s treatment, it may not necessarily be where the treatment is actually conducted. For example, where the treatment has been sub-contracted to another healthcare provider. 3. For OPRD (outpatient referral dataset), the Organisation Code (Code of Provider) is that of the organisation receiving the referral. If the provider is a Local Health Board/Trust, use the 3 character Local Health Board/Trust code with 2 zeros placed in the 4th and 5th character position. 4. For RTTD (Referral to Treatment Times (Combined)), use the 3 character Local Health Board/Trust code.

PROV_ORG_NAME

Code indicating the main composition of critical care bed types for the ward.

UNIT_BED_CONFIGURATION_CD

PAT_REG_ORG_COUNTRY_NAME

Previous Organisation Code (3 character code). Code for the Local Health Board (LHB) where the patient is a resident, identified via the NHS Postcode Directory. This ensures that the Local Health Board can receive information about the care given to its residents. Note: For English Residents treated in Wales, use the Organisation Code of the Primary Care Trust (PCT) of Residence for all activity / waiting times data up to 31st March 2013. From 1st April 2013 (inclusive) onwards, use the Organisation Code of the Clinical Commissioning Group (CCG).

PAT_RES_HEALTH_ORG_PREV_CD

COUNT_ADMIS_PLANNED

Encrypted Hospital Spell Number. A number (alphanumeric) to provide a unique identifier for each hospital provider spell for a health care provider.

HOSP_SPELL_NUM_E

This is the total number of days that the patient received gastro-intestinal system support during a Critical Care Period. To be completed when the patient has been discharged from the Critical Care Unit or has died.

DUR_GASTROINTESTINAL_SUPPORT_DAYS

SERVICE_AREA_CD

The period of time in hours between time of discharge ready and time of discharge.

DUR_DISCH_READY_DISCH_HOURS

Derived Treatment Function Code. This is the specialty under which the patient will be or is treated. This may either be the same as the specialty function recorded as the consultant&amp;#039;s main specialty or a different specialty function which will be the consultant&amp;#039;s interest specialty function. Note that both the main specialty function and the interest specialty function should be based on one of the Royal College specialties.

TREAT_SPEC_DERIVED_CD

Previous Name of the Local Health Board (LHB) where the patient is a resident, identified via the NHS Postcode Directory. This ensures that the Local Health Board can receive information about the care given to its residents. Note: For English Residents treated in Wales, use the Organisation Code of the Primary Care Trust (PCT) of Residence for all activity / waiting times data up to 31st March 2013. From 1st April 2013 (inclusive) onwards, use the Organisation Code of the Clinical Commissioning Group (CCG).

PAT_RES_HEALTH_ORG_PREV_NAME

PAT_REG_GP_GEOGRAPHY_HEALTH_ORG_NAME

The period of time in hours between time of previous discharge (at the same treatment site) and time of admission.

DUR_PREV_DISCH_ADMIS_SAME_TREAT_SITEHOURS

PAT_STATS_CURR_CENSUS_LA_PREV_CD

The total number of days that the patient received advanced respiratory support during a Critical Care Period. To be completed when the patient has been discharged from the Critical Care Unit or has died.

DUR_ADVANCED_RESPIRATORY_SUPPORT_DAYS

COUNT_DISCH_EARLY

Derived description of the type of location the patient was in prior to the start of the Critical Care Period.

SOURCE_LOC_DERIVED_DESC

Treatment Function Code. This is the specialty under which the patient will be or is treated. This may either be the same as the specialty function recorded as the consultant&amp;#039;s main specialty or a different specialty function which will be the consultant&amp;#039;s interest specialty function. Note that both the main specialty function and the interest specialty function should be based on one of the Royal College specialties.

TREAT_SPEC_CD

PAT_REG_ORG_NAME

Discharge Status Code. Code indicating the discharge status of a patient who is discharged from a Ward Stay where they were receiving care as part of a Critical Care Period and the discharge ends the Critical Care Period. It must be completed when the Critical Care Discharge Date is recorded.

DISCH_STS_CD

The Anonymised Linking Field, which has been Encrypted for its use within the database, is derived from the persons NHS number by double encryption (first encryption occurs in NWIS and the second in SAIL). If the NHS number is not supplied in the data extract then matching methods are applied.

ALF_E

ADMIS_DT_KEY

Indiactes whether or not the admission date is valid.

ADMIS_DT_VALID

TREAT_SITE_ORG_TYPE_CD

Encrypted Critical Care Local Identifier. This is a unique local activity identifier used to identify a Critical Care Period. This locally defined variable should as a minimum include a sequential numerical component that can discriminate two or more Critical Care Periods occurring on the same calendar day for the same patient.

PAT_LOCAL_ID_E

PAT_STATS_PREV_CENSUS_HEALTH_ORG_PREV_CD

Current Country Name of health care provider.

PROV_ORG_CURR_COUNTRY_NAME

Organisation Name. Name of the Local Health Board (LHB) where the patient is a resident, identified via the NHS Postcode Directory. This ensures that the Local Health Board can receive information about the care given to its residents. Based on the current census. Note: For English Residents treated in Wales, use the Organisation Code of the Primary Care Trust (PCT) of Residence for all activity / waiting times data up to 31st March 2013. From 1st April 2013 (inclusive) onwards, use the Organisation Code of the Clinical Commissioning Group (CCG).

PAT_STATS_CURR_CENSUS_HEALTH_ORG_NAME

Indiactes whether or not the discharge date is valid.

DIS_DT_VALID

Indiactes whether or not the discharge ready date is valid.

DIS_READY_DT_VALID

The period of time in hours between time of admission and time of discharge.

DUR_ADMIS_DISCH_HOURS

Indiactes whether or not the site code of treatment is valid.

TREAT_SITE_ORG_VALID

Match percentage assigned when deriving the Encrypted Anonymised Linking Field.

ALF_MTCH_PCT

DIS_DT_KEY

Indiactes whether or not the discharge time is valid.

DIS_TM_VALID

This is the total number of days that the patient received basic respiratory support during a Critical Care Period. To be completed when the patient has been discharged from the Critical Care Unit or has died.

DUR_BASIC_RESPIRATORY_SUPPORT_DAYS

Current Country Name of the site where the patient will be or is treated.

TREAT_SITE_ORG_CURR_COUNTRY_NAME

UNIT_FUNCTION_DESC

Code indicating the type of location the patient was in prior to the start of the Critical Care Period.

SOURCE_LOC_CD

The age in years of patient at date of admission.

PAT_ADMIS_AGE_YEARS

PAT_REG_GP_CLUSTER_CD

COUNT_EPI_ADMIS_UNPLANNED_DISCH_EARLY

TREAT_SPEC_CAT

Current Provider Organisation Name. This is the organisation name of the health care provider. The provider code identifies the health care provider who is responsible for managing the treatment of the patient. Notes: 1. Healthcare providers may also act as commissioners when sub-contracting patient care services to other providers of health care. 2. Although the healthcare provider identified in this data item is responsible for managing the patient&amp;acirc;&amp;euro;&amp;trade;s treatment, it may not necessarily be where the treatment is actually conducted. For example, where the treatment has been sub-contracted to another healthcare provider. 3. For OPRD (outpatient referral dataset), the Organisation Code (Code of Provider) is that of the organisation receiving the referral. If the provider is a Local Health Board/Trust, use the 3 character Local Health Board/Trust code with 2 zeros placed in the 4th and 5th character position. 4. For RTTD (Referral to Treatment Times (Combined)), use the 3 character Local Health Board/Trust code.

PROV_ORG_CURR_NAME

Current Provider Organisation Name, for health care providers in Wales only. This is the organisation name of the health care provider. The provider code identifies the health care provider who is responsible for managing the treatment of the patient. Notes: 1. Healthcare providers may also act as commissioners when sub-contracting patient care services to other providers of health care. 2. Although the healthcare provider identified in this data item is responsible for managing the patient&amp;acirc;&amp;euro;&amp;trade;s treatment, it may not necessarily be where the treatment is actually conducted. For example, where the treatment has been sub-contracted to another healthcare provider. 3. For OPRD (outpatient referral dataset), the Organisation Code (Code of Provider) is that of the organisation receiving the referral. If the provider is a Local Health Board/Trust, use the 3 character Local Health Board/Trust code with 2 zeros placed in the 4th and 5th character position. 4. For RTTD (Referral to Treatment Times (Combined)), use the 3 character Local Health Board/Trust code.

PROV_ORG_CURR_NAME_WELSH_ONLY

Organisation Code (3 character code). Code for the Local Health Board (LHB) where the patient is a resident, identified via the NHS Postcode Directory. This ensures that the Local Health Board can receive information about the care given to its residents. Note: For English Residents treated in Wales, use the Organisation Code of the Primary Care Trust (PCT) of Residence for all activity / waiting times data up to 31st March 2013. From 1st April 2013 (inclusive) onwards, use the Organisation Code of the Clinical Commissioning Group (CCG).

PAT_RES_HEALTH_ORG_CD

Admission Date. The date the patient first occupies a designated critical care bed. If there are repeated admissions to the same unit or transfers to different critical care areas within the same Hospital Provider, these should produce separate Critical Care Periods identified by different start dates. If there are repeated admissions to the same unit during the same calendar day, each period must record and be uniquely identified by the Critical Care Local Identifier.

ADMIS_DT

The ten year age band of the patient at date of admission.

PAT_ADMIS_AGE_TEN_YEAR_BANDS

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

PAT_REG_GP_ORG_CODE

The five year age band of the patient at date of discharge.

PAT_DISCH_AGE_FIVE_YEAR_BANDS

Discharge Ready Time Band Description. The time band, given as a range, in which the patient has been declared clinically ready for discharge or transfer from the Critical Care Period and a formal request has been made to the hospital bed management system (or appropriate staff with authority to admit at the intended destination) and the date and time of this status is recorded as such in the clinical record.

DIS_READY_TM_BANDA

Treatment Function Description. This is the specialty under which the patient will be or is treated. This may either be the same as the specialty function recorded as the consultant&amp;#039;s main specialty or a different specialty function which will be the consultant&amp;#039;s interest specialty function. Note that both the main specialty function and the interest specialty function should be based on one of the Royal College specialties.

TREAT_SPEC_DESC

Contains a critical care specific fields giving greater granularity for patients under critical care.

Critical Care Dataset (CCDS)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin