Home Data Elements

Data Elements

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

The 1991 census output areas.


2001 census output area code.


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


Not currently populated within the NCDR.


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


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


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


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


ASCII code 20 Columns

ASCII index for the record.


Indicates if the record is a readmission.


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