L CCI Picklist table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 25: Line 25:


== How it works ==
== How it works ==
To understand all [[CCI Procedure]]s for a patient, consider [[L CCI Picklist table]] and [[L CCI Component table]] together, eg. by using the [[Query L CCI Resolver]].
To understand all [[CCI Procedure]]s for a patient, consider [[L_CCI_Component table]] and [[L_CCI_Picklist table]] together, eg. by using the [[Query L CCI Resolver]].


== Related Articles ==
== Related Articles ==

Revision as of 20:47, 16 January 2019

The L_CCI_Component table in CCMDB.mdb contains the CCI Picklist data collected as per CCI Collection. It's the counterpart of the L CCI Component table.


Data Structure

field type description
L_CCI_ID Long Integer(AutoNumber) unique ID
Patient_ID/D_ID text link to L_Log table
CCI_Picklist_Code text(20) code and link to s_CCI_Picklist table
Px_Date Date/Time Px_Date
Px_Date_missing yes/no originally intended for cross check if no Px_Date and Px_Type = acquired; not currently used or accessible in CCMDB.mdb front end
Px_Type text(8) Acquired, Admit, Comorbid
Px_Count number (integer) number of times procedure was performed on a given day

How it works

To understand all CCI Procedures for a patient, consider L_CCI_Component table and L_CCI_Picklist table together, eg. by using the Query L CCI Resolver.

Related Articles

Related articles: