L_ICD10 table
Jump to navigation
Jump to search
The L_ICD10 table in CCMDB.accdb contains the ICD10 data collected as per ICD10 collection.
Data Structure
FieldName | FieldDataType | FieldLength | DataElementDescription | |
---|---|---|---|---|
Pat ID field | Pat_ID | number | Long Integer | The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number. |
D ID field | D_ID | string | 18 | The unique identifier/index of records in the Critical Care and Medicine Database. |
L ICD10 ID | L ICD10 ID | number | long | Unique identifier of the L_ICD10 table |
ICD10 code | ICD10 code | string | 10 | The actual ICD10 code. |
Dx Date | Dx_Date | date | not entered | The date/time of an ICD10 diagnosis. |
Dx Date unknown | Dx_Date_unknown | boolean | not entered | True for Acquired Diagnosis / Complication when Dx Date legitimately missing. |
Dx Type | Dx Type | string | 8 | The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication) |
Dx Priority | Dx Priority | number | single | The priority of an ICD10 diagnosis, used to rank and group. |
Dx Primary | Dx primary | boolean | not entered | Checkbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis |