HomeElementsA

NCDR Data Elements: A

AandE_Attends_Type1 int

Number of A&E attendances for type 1.

Used in 2 places

AandE_Attends_Type2 int

Number of A&E attendances for type 2.

Used in 2 places

AandE_Attends_Type3 int

Number of A&E attendances for type 3.

Used in 2 places

AandE_Dept_Type varchar(50)

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


AbsDischResp varchar(2)

The body or person responsible for granting mental health absolute discharge.


AccommodationStatusCode varchar(4)

An indication of the type of accommodation that a patient currently has. This should be based on the patient's main or permanent residence.


AccommodationStatusDate date

The person property recorded date when the accommodation status code was recorded.


Achieved_Points decimal

The number of achieved points.

Used in 8 places

Achievement_Rate decimal

The achievement rate.

Used in 6 places

ACM_Spec_Col_Name varchar(100)

Column name of the aggregate contract monitoring specification.


Activity_Location_Type varchar(3)

The type of location for an activity where: patients are seen, services are provided or from which requests for services are sent.


Activity_Location_Type_Code varchar(3)

The type of location for an activity where: patients are seen, services are provided or from which requests for services are sent. Recorded at start date (episode).


Activity_Location_Type_Desc varchar(500)

The description of the type of location for an activity where: patients are seen, services are provided or from which requests for services are sent.


Activity_Location_Type_Desc_Short varchar(35)

The short description of the type of location for an activity where: patients are seen, services are provided or from which requests for services are sent.


ActLocTypeCode varchar(3)

The type of location for an activity where: patients are seen, services are provided or from which requests for services are sent.

Used in 3 places

Acute_Morbidity_Indicator decimal

Indicator for acute morbidity.


Acute_Or_Non_Acute varchar(9)

Flag to show if the data is acute or non-acute.


Address_Format_Code varchar(3)

A code to determine the format of the associated patient usual address data.

Used in 3 places

Address_Format_Code_Mother varchar(1)

A code to determine the format of the associated patient usual address (mother) data.


Address_Line_1 varchar(255)

The address field 1.


Address_Line_2 varchar(255)

The address field 2.


Address_Line_3 varchar(255)

The address field 3.


Address_Line_4 varchar(255)

The address field 4.


Address_Line_5 varchar(255)

The address field 5.


Admin_Category_at_Start varchar(2)

The administrative category code of the patient at the start of the episode of admitted patient care.


AdminCatCode varchar(2)

This is recorded for patient activity. A patient who is an overseas visitor does not qualify for free NHS healthcare and can choose to pay for NHS treatment or for private treatment. If they pay for NHS treatment then they should be recorded as NHS patients. The patient's administrative category code may change during an episode or spell. For example, the patient may opt to change from NHS to private health care. In this case, The start and end dates for each new administrative category period (episode or spell) should be recorded.


Administrative_Category varchar(2)

The administrative category code of the patient.

Used in 3 places

Administrative_Category_Der varchar(20)

The administrative category code of the patient.


Administrative_Category_Desc varchar(500)

The administrative category code description of the patient.

Used in 2 places

Administrative_Category_Desc_Short varchar(30)

The administrative category code short description of the patient.

Used in 2 places

Admission_Date date

The same as attribute activity date where the activity date type is national code 'start date' of the hospital provider spell.

Used in 3 places

Admission_Method varchar(2)

The method of admission to a hospital provider spell.

Used in 2 places

Admission_Method_Der varchar(2)

The method of admission to a hospital provider spell.


Admission_Method_Desc varchar(500)

The description of the method of admission to a hospital provider spell.


Admission_Method_Desc_Short varchar(35)

The short description of the method of admission to a hospital provider spell.


Admission_Source varchar(2)

The source of admission to a hospital provider spell or a nursing episode when the patient is in a hospital site or a care home.


Admission_Source_Desc varchar(500)

The description of the source of admission to a hospital provider spell or a nursing episode when the patient is in a hospital site or a care home.


Admission_Source_Desc_Short varchar(35)

The short description of the source of admission to a hospital provider spell or a nursing episode when the patient is in a hospital site or a care home.


Admission_Sub_Type varchar(3)

Admission sub type code (ELE, EMR, MAT or OTH).


Admission_Sub_Type_Desc varchar(500)

Admission sub type description (e.g. ELE: Elective admission).


Admission_Sub_Type_Desc_Short varchar(35)

Admission sub type description (e.g. ELE: Elective).


Admission_Time varchar(8)

The same as the attribute activity time where the activity time type is national code 'start time' of the hospital provider spell.


Admission_Type varchar(4)

Admission type code (DAY, ELE, NON, PSD, REG).


Admission_Type_Desc varchar(500)

Admission type description (e.g. ELE: Elective admission).


Admission_Type_Desc_Short varchar(35)

Admission type description (e.g. ELE: Elective).


AdmMethCodeHospProvSpell varchar(2)

The method of admission to a hospital provider spell.


Adult_Skills_And_English_Lang_Proficiency_Indicators_Combined decimal

Combined indicator for adult skills and English language.


Adult_Skills_Subdomain_Decile int

Adult skills subdomain decile.


Adult_Skills_Subdomain_Rank int

Adult skills subdomain rank.


Adult_Skills_Subdomain_Score decimal

Adult skills subdomain score.