L ICD10 table

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