ADR Metadata Catalogue

ADR  > Emergency Department Dataset Daily (EDDD) @ 306

https://popdatasci.swan.ac.uk/centres-of-excellence/sail/, https://www.youtube.com/watch?v=ZK9-Jw3uVkw, https://saildatabank.com/, https://saildatabank.com/about-us/

EDDD is a project specific dataset for specific COVID-19 related projects only. Administrative and clinical information for all NHS Wales Accident and Emergency department attendances are available from the EDDS dataset.

The data covers administrative and clinical information for all NHS Wales Accident and Emergency department attendances. This is in contrast to EDDS data which are not daily extracts. Includes the All Wales Injury Surveillance Systems (AWISS) dataset. 

Data recording practices may vary, especially in some of the minor A&amp;amp;E and Minor Injury Units which could account for some local differences.

Approx 70-80% coverage of Welsh population through GP registrations.

SAIL Databank (Wales)

DHCW

Fourth diagnosis type code, which may have beeen identified during an Accident and Emergency Department Attendance.

Notes:
- At least one Diagnosis Type must be reported
- Up to 6 diagnosis types can be reported in this section of the Data Set
- Where a physical injury has taken place; &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand.
- For medical conditions where anatomical area is not relevant only a diagnosis type should be recorded.
- When analysing diagnosis types ALL entries should be considered

DIAG4

Administrative and clinical information for all NHS Wales Accident and Emergency department attendances. Includes the All Wales Injury Surveillance Systems (AWISS) dataset.

Data recording practices may vary, especially in some of the minor A&amp;amp;E and Minor Injury Units which could account for some local differences.

DF_EDD_HEALTHEVENTATTENDANCE

First indication of the side of the human body. Up to 6 sides of the human body can be reported. 

Note: Anatomical Area has a 1-1 relationship with Anatomical Side, so that &amp;#039;Anatomical Side 1&amp;#039; directly relates to the body part reported in &amp;#039;Anatomical Area 1&amp;#039; e.g. Left Hand.

SIDE1

Accident and Emergency Attendance Administrative Arrival Time is when the Accident and Emergency reception staff are notified in person that a patient has arrived and needs to be seen within the Accident and Emergency Department. Notification could be by the Ambulance Crew, the patient themselves, or a person accompanying the patient e.g. relative / friend.

ADMIN_ARR_TM

Second indication of the side of the human body. Up to 6 sides of the human body can be reported.

Note: Anatomical Area has a 1-1 relationship with Anatomical Side, so that &amp;#039;Anatomical Side 1&amp;#039; directly relates to the body part reported in &amp;#039;Anatomical Area 1&amp;#039; e.g. Left Hand.

SIDE2

Alcohol Indicator. In the clinical opinion of the Emergency Department, has the presence of alcohol in the presenting patient contributed to this attendance?

Note: this question only needs to be answered for New Attendances and Unplanned Follow-ups. For Follow-up patients, value &amp;acirc;&amp;euro;&amp;tilde;04 &amp;acirc;&amp;euro;&amp;ldquo; Not Applicable&amp;acirc;&amp;euro;&amp;trade; should be recorded in this field.

ALCOHOL_IND

TRACE_STATUS

The type of place where the physical or chemical injury occurred which led to the Accident and Emergency Department Attendance.

LOC_TYPE

Provider Site Code (5 character code). 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_SITE_CD

First part of the human body.

Notes:
- Up to 6 parts of the human body can be reported in this section of the data set.
- Where a physical injury has taken place, &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand. .
- Where multiple body parts have been affected the value &amp;#039;501&amp;#039; should be used.
- Anatomical area also has a 1-1 relationship with Anatomical side.

ANAT_AREA1

Accident and Emergency Attendance Administrative Arrival Date is the date the Accident and Emergency reception staff are notified in person that a patient has arrived and needs to be seen within the Accident and Emergency Department. Notification could be by the Ambulance Crew, the patient themselves, or a person accompanying the patient e.g. relative / friend.

ADMIN_ARR_DT

Case Record Number. This is the patient&amp;#039;s case record number which is unique to that patient within a hospital or health care provider.

CRN_PSEUD

Fourth indication of the side of the human body. Up to 6 sides of the human body can be reported.

Note: Anatomical Area has a 1-1 relationship with Anatomical Side, so that &amp;#039;Anatomical Side 1&amp;#039; directly relates to the body part reported in &amp;#039;Anatomical Area 1&amp;#039; e.g. Left Hand.

SIDE4

Third investigation type code. Investigation type codes may be requested to assist with diagnosis during and Accident and Emergency Department Attendance.

Note: Up to 6 types of investigation can be listed in this section of the Data Set.

INVEST3

Administrative End Time. This is the time that the patients Accident and Emergency Attendance Ends.

Administrative End Time is when one of the following criteria is met;
-  The patient leaves the Accident and Emergency Department to continue their treatment elsewhere, wherever that might be, this is the point of clinical handover;
-  The patient is discharged and is medically fit to leave the department;
-  The patient self discharges;
-  The patient dies.

ADMIN_END_TM

Administrative End Date. This is the date that the patients Accident and Emergency Attendance Ends. 

Accident and Emergency Attendance Administrative End Date is when one of the following criteria is met;
-  The patient leaves the Accident and Emergency Department to continue their treatment elsewhere, wherever this might be, this is the point of clinical handover;
-  The patient is discharged and is medically fit to leave the department;
-  The patient self discharges;
-  The patient dies.

ADMIN_END_DT

Referral Code. This is the nationally recognized code of the person making the referral.This may be a General Medical Practitioner (GMP), General Dental Practitioner (GDP), Consultant or Independent Nurse. If the referral is not from a GMP, GDP, Consultant or Independent Nurse one of the default codes used.

REF_CD

Second part of the human body.

Notes:
- Up to 6 parts of the human body can be reported in this section of the data set.
- Where a physical injury has taken place, &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand. .
- Where multiple body parts have been affected the value &amp;#039;501&amp;#039; should be used.
- Anatomical area also has a 1-1 relationship with Anatomical side.

ANAT_AREA2

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

AVAIL_FROM_DT

Sixth indication of the type of treatment or guidance which may be provided to a patient as a result of an Accident and Emergency Attendance.

Notes:
- The treatment fields do not directly relate to any of the diagnosis fields, but record any treatments that have taken place.
- Up to 6 treatments can be reported in this section of the Data Set

TREAT6

Time of the incident / acute medical episode that led to the Accident and Emergency Department Attendance.

HEALTH_EVENT_TM

ETHNIC_GRP

Fifth diagnosis type code, which may have beeen identified during an Accident and Emergency Department Attendance.

Notes:
- At least one Diagnosis Type must be reported
- Up to 6 diagnosis types can be reported in this section of the Data Set
- Where a physical injury has taken place; &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand.
- For medical conditions where anatomical area is not relevant only a diagnosis type should be recorded.
- When analysing diagnosis types ALL entries should be considered

DIAG5

Status code assigned when deriving the Encrypted Anonymised Linking Field.

ALF_STS_CD

Fourth part of the human body.

Notes:
- Up to 6 parts of the human body can be reported in this section of the data set.
- Where a physical injury has taken place, &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand. .
- Where multiple body parts have been affected the value &amp;#039;501&amp;#039; should be used.
- Anatomical area also has a 1-1 relationship with Anatomical side.

ANAT_AREA4

This is the presenting complaint with which the patient attended the Accident and Emergency Department.

PRESENTING_COMPLAINT

The sport in which the patient was participating at the time of injury that led to the Accident and Emergency Department attendance.

This should only be completed when the &amp;#039;Activity at Time of Injury&amp;#039; is &amp;#039;03 &amp;acirc;&amp;euro;&amp;ldquo; Sport&amp;#039;

SPORT

Third part of the human body.

Notes:
- Up to 6 parts of the human body can be reported in this section of the data set.
- Where a physical injury has taken place, &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand. .
- Where multiple body parts have been affected the value &amp;#039;501&amp;#039; should be used.
- Anatomical area also has a 1-1 relationship with Anatomical side.

ANAT_AREA3

This is the nature of the patients road use at the time of the road traffic collision.

This should only be completed when the &amp;#039;Activity at Time of Injury&amp;#039; is &amp;#039;06 &amp;acirc;&amp;euro;&amp;ldquo; Road Traffic Collision&amp;#039;.

ROAD_USER

Sixth diagnosis type code, which may have beeen identified during an Accident and Emergency Department Attendance.

Notes:
- At least one Diagnosis Type must be reported
- Up to 6 diagnosis types can be reported in this section of the Data Set
- Where a physical injury has taken place; &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand.
- For medical conditions where anatomical area is not relevant only a diagnosis type should be recorded.
- When analysing diagnosis types ALL entries should be considered

DIAG6

First investigation type code. Investigation type codes may be requested to assist with diagnosis during and Accident and Emergency Department Attendance.

Note: Up to 6 types of investigation can be listed in this section of the Data Set.

INVEST1

Accident and Emergency Attendance Category is an indication of whether a patient is making a first or follow-up attendance at the Accident and Emergency Department.

Note - possible values
- New Attendance. A new attendance is the first visit made by a patient to the Accident and Emergency Department for a particular injury or ailment. A new attendance can be the first in a series or one single attendance in an Accident and Emergency Department.
- Planned Follow-up Attendance. A follow-up Accident and Emergency Attendance is a subsequent planned attendance at the same department, and for the same incident as the first attendance. A planned follow-up attendance is agreed or requested by a clinician.
- Unplanned Follow-up Attendance. A patient returning to the Accident and Emergency Department with a conditional previously treated where they have not been asked to return by the clinician will be counted as an unplanned follow-up attendance.

ATTEND_CAT

Additional Incident details. A record of any additional details of the incident that led to the Accident &amp;amp; Emergency Department Attendance that cannot be recorded elsewhere within the dataset.

Note: This field allows for any supplementary information supporting either the injury or illness causing the patient to attend the Accident &amp;amp; Emergency Department, or any other details pertaining to the patient&amp;#039;s treatment, to be recorded; this includes details relating to the location where the incident occurred specifically, Road, Vehicle collision or Assault incidents.

ADD_DETAILS

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

LSOA2011_CD

Second indication of the type of treatment or guidance which may be provided to a patient as a result of an Accident and Emergency Attendance.

Notes:
- The treatment fields do not directly relate to any of the diagnosis fields, but record any treatments that have taken place.
- Up to 6 treatments can be reported in this section of the Data Set

TREAT2

The triage category is assigned to a patient as a result of an initial assessment by medical or nursing staff in an Accident and Emergency Department.

TRIAGE_CAT

Second investigation type code. Investigation type codes may be requested to assist with diagnosis during and Accident and Emergency Department Attendance.

Note: Up to 6 types of investigation can be listed in this section of the Data Set.

INVEST2

This records the outcome of the Accident and Emergency Department Attendance.

Note: &amp;acirc;&amp;euro;&amp;tilde;11 &amp;acirc;&amp;euro;&amp;ldquo; Dead on Arrival&amp;acirc;&amp;euro;&amp;trade; should only be recorded for patients who have been certified as dead on arrival by a clinician in the Accident and Emergency Department

DISCHARGE

The age of patient at start date of admission.

Fourth investigation type code. Investigation type codes may be requested to assist with diagnosis during and Accident and Emergency Department Attendance.

Note: Up to 6 types of investigation can be listed in this section of the Data Set.

INVEST4

The year of the Date of birth of patient / client.

DOB_YR

This is the sex (gender) of person, employee or patient.

Sixth investigation type code. Investigation type codes may be requested to assist with diagnosis during and Accident and Emergency Department Attendance.

Note: Up to 6 types of investigation can be listed in this section of the Data Set.

INVEST6

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

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

LSOA2001_CD

Third diagnosis type code, which may have beeen identified during an Accident and Emergency Department Attendance.

Notes:
- At least one Diagnosis Type must be reported
- Up to 6 diagnosis types can be reported in this section of the Data Set
- Where a physical injury has taken place; &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand.
- For medical conditions where anatomical area is not relevant only a diagnosis type should be recorded.
- When analysing diagnosis types ALL entries should be considered

DIAG3

Third indication of the type of treatment or guidance which may be provided to a patient as a result of an Accident and Emergency Attendance.

Notes:
- The treatment fields do not directly relate to any of the diagnosis fields, but record any treatments that have taken place.
- Up to 6 treatments can be reported in this section of the Data Set

TREAT3

Ambulance Incident Number. When a patient arrives by ambulance, this is the incident number for that journey, allocated by the Ambulance Control.

For patients who did not arrive by ambulance, this field should be left blank.

AMB_INCID_NO

MATCH_PROB

Third indication of the side of the human body. Up to 6 sides of the human body can be reported.

Note: Anatomical Area has a 1-1 relationship with Anatomical Side, so that &amp;#039;Anatomical Side 1&amp;#039; directly relates to the body part reported in &amp;#039;Anatomical Area 1&amp;#039; e.g. Left Hand.

SIDE3

Encrypted record ID. This is the field to identify the type of record being submitted.

RECORD_ID_E

Fifth investigation type code. Investigation type codes may be requested to assist with diagnosis during and Accident and Emergency Department Attendance.

Note: Up to 6 types of investigation can be listed in this section of the Data Set.

INVEST5

The principal means by which a patient arrives at an Accident and Emergency department.

Notes:
- If the patient has been transported from a Heliport/pad to the Accident and Emergency Department by Ambulance, the arrival mode should still be recorded as &amp;#039;02&amp;#039; Helicopter/ Air Ambulance.
- Record value &amp;acirc;&amp;euro;&amp;trade;98 &amp;acirc;&amp;euro;&amp;ldquo; Not Applicable (Planned Follow-Up)&amp;acirc;&amp;euro;&amp;trade; for patients attending the Accident and Emergency Department for a planned follow-up appointment.

ARRIVAL_MOD

The mechanics of how the physical or chemical injury was sustained.

MECH_OF_INJ

First diagnosis type code, which may have beeen identified during an Accident and Emergency Department Attendance.

Notes:
- At least one Diagnosis Type must be reported
- Up to 6 diagnosis types can be reported in this section of the Data Set
- Where a physical injury has taken place; &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand.
- For medical conditions where anatomical area is not relevant only a diagnosis type should be recorded.
- When analysing diagnosis types ALL entries should be considered

DIAG1

Fourth indication of the type of treatment or guidance which may be provided to a patient as a result of an Accident and Emergency Attendance.

Notes:
- The treatment fields do not directly relate to any of the diagnosis fields, but record any treatments that have taken place.
- Up to 6 treatments can be reported in this section of the Data Set

TREAT4

What the patient was doing at the time of injury. This item helps establish a picture of how the physical or chemical injury occurred.

ACTIVITY

Fifth indication of the side of the human body. Up to 6 sides of the human body can be reported.

Note: Anatomical Area has a 1-1 relationship with Anatomical Side, so that &amp;#039;Anatomical Side 1&amp;#039; directly relates to the body part reported in &amp;#039;Anatomical Area 1&amp;#039; e.g. Left Hand.

SIDE5

The encrypted GP practice code where the appointment occured.

PRAC_CD_E

Second diagnosis type code, which may have beeen identified during an Accident and Emergency Department Attendance.

Notes:
- At least one Diagnosis Type must be reported
- Up to 6 diagnosis types can be reported in this section of the Data Set
- Where a physical injury has taken place; &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand.
- For medical conditions where anatomical area is not relevant only a diagnosis type should be recorded.
- When analysing diagnosis types ALL entries should be considered

DIAG2

Fifth part of the human body.

Notes:
- Up to 6 parts of the human body can be reported in this section of the data set.
- Where a physical injury has taken place, &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand. .
- Where multiple body parts have been affected the value &amp;#039;501&amp;#039; should be used.
- Anatomical area also has a 1-1 relationship with Anatomical side.

ANAT_AREA5

Sixth part of the human body.

Notes:
- Up to 6 parts of the human body can be reported in this section of the data set.
- Where a physical injury has taken place, &amp;#039;Diagnosis Type&amp;#039; and &amp;#039;Anatomical Area&amp;#039; should have a 1-1 relationship e.g. Abrasion &amp;acirc;&amp;euro;&amp;ldquo; Hand. .
- Where multiple body parts have been affected the value &amp;#039;501&amp;#039; should be used.
- Anatomical area also has a 1-1 relationship with Anatomical side.

ANAT_AREA6

Date of the incident / acute medical episode that led to the Accident and Emergency Department Attendance.

HEALTH_EVENT_DT

Provider Unit Code (3 character code). 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_UNIT_CD

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

SITE_CD_OF_TREAT

First indication of the type of treatment or guidance which may be provided to a patient as a result of an Accident and Emergency Attendance.

Notes:
- The treatment fields do not directly relate to any of the diagnosis fields, but record any treatments that have taken place.
- Up to 6 treatments can be reported in this section of the Data Set

TREAT1

A general reason for an Accident and Emergency Department Attendance.

Note: &amp;acirc;&amp;euro;&amp;tilde;30 &amp;acirc;&amp;euro;&amp;ldquo; Dead on Arrival&amp;acirc;&amp;euro;&amp;trade; should only be recorded for patients who have been certified as dead on arrival by a clinician in the Accident and Emergency Department

ATTEND_GRP

Sixth indication of the side of the human body. Up to 6 sides of the human body can be reported.

Note: Anatomical Area has a 1-1 relationship with Anatomical Side, so that &amp;#039;Anatomical Side 1&amp;#039; directly relates to the body part reported in &amp;#039;Anatomical Area 1&amp;#039; e.g. Left Hand.

SIDE6

Fifth indication of the type of treatment or guidance which may be provided to a patient as a result of an Accident and Emergency Attendance.

Notes:
- The treatment fields do not directly relate to any of the diagnosis fields, but record any treatments that have taken place.
- Up to 6 treatments can be reported in this section of the Data Set

TREAT5

Daily version of Emergency Department Dataset.

Emergency Department Dataset Daily (EDDD)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin