Data Elements
Data elements are collections of similarly defined data items, potentially from different sources.
2001 Census area 4 Columns
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.
A&E arrival mode 6 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 3 Columns
The length of time the patient waited for an assessment.
A&E attendance category 15 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 6 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 6 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 6 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 6 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 3 Columns
The wait time until conclusion, at an accident and emergency department.
A&E department type 11 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 7 Columns
The date that a patient leaves an accident and emergency department after an accident and emergency attendance has concluded.
A&E departure time 7 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 8 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 31 Columns
Primary key - Use this field to join to the other tbl_Data_SEM_AEA_* tables.
A&E incident location type 6 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 7 Columns
The date that the patient is first assessed in the accident and emergency department.
A&E initial assessment time 7 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 173 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 18 Columns
An identifier assigned during loading to aid processing.
A&E patient group 8 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 18 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 15 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 4 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 173 Columns
The treatment, for an accident and emergency attendance.
A&E treatment date 2 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 9 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 2 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 40 Columns
A unique identifier for each episode.
APCE load identifier 22 Columns
The load identifier for the reporting episode within the spell. Used largely for data processing purposes.
APCE raw identifier 14 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 47 Columns
A unique identifier for each spell.
APCS load identifier 29 Columns
An identifier assigned during loading to aid processing.
Abnormality detected 1 Columns
An indication of whether any abnormalities were detected during the dating scan.
Absent without leave indicator 2 Columns
Indicates an absent without leave episode.
Abuse question asked indicator 4 Columns
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.