Record Table 1067
Title: HES inpatient diagnoses
Access field: 41234 (Records in HES inpatient diagnoses dataset)
Not all features of this website will be available to you.
WARNING: the interactive features of this website use CSS3, which your browser does not support. To use the full features of this website, please update your browser.
Diagnosis codes recorded in an inpatient admission
# Column Type Notes
1 eid integer Encoded participant identifier. This identifier is the same encoded id used in the main dataset.
2 ins_index integer Instance index. A numerical index which together with the eid uniquely identifies the corresponding record in the main HESIN table.
3 arr_index integer Array index. A numerical index which together with the eid & ins_index uniquely identifies this record, i.e. eid, ins_index & arr_index together form a primary key for this table.
4 level integer, coding 926 Classification of diagnosis. The primary diagnosis is the main condition treated or investigated during the relevant episode. A secondary diagnosis is a clinically relevant contributory factor or issue that impacts on the primary diagnosis (including chronic conditions). An external cause is an environmental event causing injury, poisoning or other type of adverse effect.
5 diag_icd9 string, coding 87 Diagnoses - ICD9. Diagnoses are coded according to the International Classification of Diseases version-9 (ICD 9).
6 diag_icd9_nb string, coding 41 Diagnoses - ICD9 addendum.
7 diag_icd10 string, coding 19 Diagnoses - ICD10. Diagnoses are coded according to the International Classification of Diseases version-10 (ICD 10). 8 diag_icd10_nb string, coding 41 Diagnoses - ICD10 addendum.
6 Related HES Record Tables
Enabling scientific discoveries that improve human health