Data Elements
Data elements are collections of similarly defined data items, potentially from different sources.
1991 census area 2 Columns
The 1991 census output areas.
2001 census area 11 Columns
2001 census output area code.
A&E arrival mode 5 Columns
The mode by which a patient arrived at an accident and emergency department.
A&E arrival mode description 2 Columns
The description of the mode by which a patient arrived at an accident and emergency department.
A&E assessment wait time 11 Columns
The length of time the patient waited for an assessment.
A&E attendance category 10 Columns
An indication of whether a patient is making first or follow-up attendance at a particular accident and emergency department.
A&E attendance category description 2 Columns
The description of whether a patient is making first or follow-up attendance at a particular accident and emergency department.
A&E attendance disposal 3 Columns
A code to identify how an accident and emergency attendance might end.
A&E attendance disposal description 2 Columns
The description of the code to identify how an accident and emergency attendance might end.
A&E attendance number 4 Columns
A number allocated by an accident and emergency department to provide a unique identifier for each accident and emergency attendance.
A&E conclusion date 4 Columns
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).
A&E conclusion time 4 Columns
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).
A&E conclusion wait time 1 Columns
Not currently populated within the NCDR.
A&E department type 9 Columns
The type of accident and emergency department according to the activity performed.
A&E department type description 4 Columns
The description of the type of accident and emergency department according to the activity performed.
A&E departure date 4 Columns
The date that a patient leaves an accident and emergency department after an accident and emergency attendance has concluded.
A&E departure time 4 Columns
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.
A&E file identifier 1 Columns
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.
A&E incident location type 3 Columns
The type of place where the incident occurred which led to an accident and emergency episode.
A&E incident location type description 2 Columns
The description of the type of place where the incident occurred which led to an accident and emergency episode.
A&E initial assessment date 4 Columns
The date that the patient is first assessed in the accident and emergency department.
A&E initial assessment time 4 Columns
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.
A&E investigation 101 Columns
The clinical investigation, for an accident and emergency attendance.
A&E investigation description 2 Columns
The description of the clinical investigation, for an accident and emergency attendance.
A&E load identifier 28 Columns
The load identifier for the reporting episode within the spell. Used largely for data processing purposes.
A&E patient group 6 Columns
A coded classification to identify the reason for an accident and emergency episode.
A&E patient group description 2 Columns
The description of the coded classification to identify the reason for an accident and emergency episode.
A&E raw identifier 27 Columns
An identifier on the raw data, i.e. assigned by NHS Digital prior to import to the NCDR, used during loading and processing.
A&E source of referral 10 Columns
The source of referral of each accident and emergency episode.
A&E source of referral description 3 Columns
The description of the source of referral of each accident and emergency episode.
A&E staff code 1 Columns
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.
A&E stream description 2 Columns
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.
A&E treatment date 3 Columns
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.
A&E treatment description 2 Columns
The description of the treatment, for an accident and emergency attendance.
A&E treatment time 5 Columns
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.
A&E treatment time since arrival 11 Columns
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.
ACM specification column name 1 Columns
Column name of the aggregate contract monitoring specification.
APCE file identifier 1 Columns
An identifier to distinguish between the APCE files during the load process.
APCE identifier 46 Columns
A unique identifier for each episode.
APCE load identifier 33 Columns
The load identifier for the reporting episode within the spell. Used largely for data processing purposes.
APCE raw identifier 16 Columns
An identifier on the raw data, i.e. assigned by NHS Digital prior to import to the NCDR, used during loading and processing.
APCS identifier 45 Columns
A unique identifier for each spell.
APCS load identifier 36 Columns
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.
AT readmission flag 2 Columns
Indicates if the record is a readmission.
Abnormality detected 2 Columns
An indication of whether any abnormalities were detected during the dating scan.