Home Data Elements

Data Elements

Data elements are collections of similarly defined data items, potentially from different sources.

The 2001 census output areas, built from unit postcodes and constrained to the 2003 statistical wards, which will form the building blocks for defining higher level geographies in the future. A pseudo code is included for the Channel Islands and the Isle of Man. Derived by NHS Digital prior to import to the NCDR.


The mode by which a patient arrived at an accident and emergency department.


The description of the mode by which a patient arrived at an accident and emergency department.


The length of time the patient waited for an assessment.


An indication of whether a patient is making first or follow-up attendance at a particular accident and emergency department.


The description of whether a patient is making first or follow-up attendance at a particular accident and emergency department.


A code to identify how an accident and emergency attendance might end.


The description of the code to identify how an accident and emergency attendance might end.


A number allocated by an accident and emergency department to provide a unique identifier for each accident and emergency attendance.


The date that a patient's accident and emergency attendance concludes or when treatment in the accident and emergency department is completed (whichever is the later).


The time, recorded using a 24 hour clock, that a patient's accident and emergency attendance concludes or when treatment in the accident and emergency department is completed (whichever is the later).


The wait time until conclusion, at an accident and emergency department.


The type of accident and emergency department according to the activity performed.


The description of the type of accident and emergency department according to the activity performed.


The date that a patient leaves an accident and emergency department after an accident and emergency attendance has concluded.


The time recorded using a 24 hour clock that a patient leaves an accident and emergency department after an accident and emergency attendance has concluded.


A&E duration 8 Columns

Duration of the A&E attendance in minutes, based on the Arrival_Date, Arrival_Time and AEA_Departure_Time fields.


An identifier to distinguish between the AEA files during the load process.


A&E identifier 31 Columns

Primary key - Use this field to join to the other tbl_Data_SEM_AEA_* tables.


The type of place where the incident occurred which led to an accident and emergency episode.


The description of the type of place where the incident occurred which led to an accident and emergency episode.


The date that the patient is first assessed in the accident and emergency department.


The time, recorded using the 24 hour clock, that the patient is first assessed in the accident and emergency department for first attendances and unplanned follow-up attendances.


The clinical investigation, for an accident and emergency attendance.


The description of the clinical investigation, for an accident and emergency attendance.


An identifier assigned during loading to aid processing.


A coded classification to identify the reason for an accident and emergency episode.


The description of the coded classification to identify the reason for an accident and emergency episode.


An identifier on the raw data, i.e. assigned by NHS Digital prior to import to the NCDR, used during loading and processing.


The source of referral of each accident and emergency episode.


The description of the source of referral of each accident and emergency episode.


A locally determined code used to identify the person principally responsible for the care of a patient during an accident and emergency attendance.


A&E stream 1 Columns

The streaming classification assigned to an accident and emergency attendance.


The description of the streaming classification assigned to an accident and emergency attendance.


A&E treatment 173 Columns

The treatment, for an accident and emergency attendance.


The date, that the patient is seen by a clinical decision maker (someone who can define the management plan and discharge the patient) to diagnose the problem and arrange or start definite treatment as necessary.


The description of the treatment, for an accident and emergency attendance.


The time, recorded using the 24 hour clock, that the patient is seen by a clinical decision maker (someone who can define the management plan and discharge the patient) to diagnose the problem and arrange or start definite treatment as necessary.


The waiting time, in minutes, from arrival to seen for treatment. Uses time difference between arrival_date, arrival_time and date_seen_for_treatment , time_seen_for_treatment return. If either of the submitted element is missing then derivation result is null.


Column name of the aggregate contract monitoring specification.


An identifier to distinguish between the APCE files during the load process.


A unique identifier for each episode.


The load identifier for the reporting episode within the spell. Used largely for data processing purposes.


An identifier on the raw data, i.e. assigned by NHS Digital prior to import to the NCDR, used during loading and processing.


A unique identifier for each spell.


An identifier assigned during loading to aid processing.


An indication of whether any abnormalities were detected during the dating scan.


Indicates an absent without leave episode.


An indication of whether the patient was asked the abuse question during a care programme approach review. Note this is not the answer to the abuse question.


The SNOMED CT concept ID which is used to identify that the patient requires support from a communication professional.