L CCI Picklist table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
mNo edit summary
Line 1: Line 1:
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]].
{{DISPLAYTITLE: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]].
 


test pagename: {{PAGENAME}}
== Data Structure ==
== Data Structure ==
{| class="wikitable sortable"  
{| class="wikitable sortable"  

Revision as of 15:06, 2023 May 17

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.

test pagename: L CCI Picklist 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: