L CCI Picklist table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
Line 1: Line 1:
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]].
The '''L_CCI_Component''' table in [[CCMDB.accdb]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]]. It's the counterpart of the [[L CCI Component table]].




Line 17: Line 17:
|| '''[[Px_Date]]''' || Date/Time || [[Px_Date]]
|| '''[[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_Date]]_missing''' || yes/no || originally intended for cross check if no [[Px_Date]] and [[Px_Type]] = acquired; not currently used or accessible in CCMDB.accdb front end
|-
|-
|| '''[[Px_Type]]''' || text(8) || Acquired, Admit, Comorbid
|| '''[[Px_Type]]''' || text(8) || Acquired, Admit, Comorbid

Revision as of 10:45, 22 September 2019

The L_CCI_Component table in CCMDB.accdb 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.accdb 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_Combined.

Related Articles

Related articles: