L ICD10 table

The L ICD10 table in CCMDB.mdb contains the ICD10 data collected as per ICD10 collection.

Data Structure

field	type	description
L_ICD10_ID	Long Integer(AutoNumber)	unique ID
D_ID	text	link to L_Log table
ICD10_ID		link to s_ICD10 table
Dx_Date	Date/Time	date diagnosis made; mandatory for Acquired Dx
Dx_Type	text(8)	Acquired, Admit, Comorbid
Priority	number (single)	for sorting and grouping

Dx_Date

• Template:Discussion will this be allowed for other dxs?
• Template:Discussion will this be Date diagnosed, or date dx happened?==