L CCI Picklist table

The L_CCI_Component table in CCMDB.mdb contains the CCI data collected as per CCI collection.

Data Structure

field	type	description
L_CCI_ID	Long Integer(AutoNumber)	unique ID
Patient_ID/D_ID	text	link to L_Log table
CCI_Pick_Code	long integer	link to s_CCI_Picklist table, defaults to No procedure entered
Px_Date	Date/Time	Px_Date
Px_Date_unknown	yes/no	mus be set to true if no Px_Date
Px_Type	text(8)	Acquired, Admit, Comorbid
Px_Count	number (integer)	number of times procedure was performed on a given day