L CCI Picklist table: Difference between revisions

(14 intermediate revisions by the same user not shown)

Line 1:

The '''~~L_CCI_Component~~''' table in [[CCMDB.~~mdb~~]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]].

{{DISPLAYTITLE:L_CCI_Picklist table}} The '''L_CCI_Picklist ''' 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 ==

Line 12:

|| '''[[Patient_ID]]/[[D_ID]]''' || text || link to [[L_Log table]]

|-

|| '''~~CCI_Pick_Code~~''' || ~~number~~(~~long integer~~) || link to [[s_CCI_Picklist table]]

|| '''[[CCI_Picklist_Code]]''' || text(20) || code and link to [[s_CCI_Picklist table]]

|-

|| '''[[Px_Date]]''' || Date/Time || [[Px_Date]]

|-

|| '''[[Px_Date]]~~_unknown~~''' || yes/no || ~~mus be set to true~~ if no [[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

Line 24:

== How it works ==

~~One field stores a single [[CCI Procedure]]:~~

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_Combined]].

* [[CCI_Pick_Code]] - <number between 1-8>.<2 letters>.<2 numbers><optionally more letters>

To understand all [[CCI Procedure]]s for a patient, consider [[~~L CCI Component~~ table]] and [[~~L CCI Component~~ table]] together, eg. by using the [[~~Query L CCI Resolver~~]].

== Related Articles ==

[[Category: Data structure]]

[[Category:Data structure]]

[[Category: ICD10/CCI Conversion]]

[[Category:ICD10/CCI Conversion]]

[[Category: CCI]]

[[Category:CCI]]

[[Category: L Table]]

[[Category:L Table]]

[[Category: CCI Data Structure]]

[[Category:CCI Data Structure]]

[[Category: L CCI Picklist table]]

[[Category:L CCI Picklist table]]

[[Category:CCI Picklist Coding]]

@@ Line 1: / Line 1: @@
-The '''L_CCI_Component''' table in [[CCMDB.mdb]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]].
+{{DISPLAYTITLE:L_CCI_Picklist table}} The '''L_CCI_Picklist ''' 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 ==
@@ Line 12: / Line 12: @@
 || '''[[Patient_ID]]/[[D_ID]]''' || text || link to [[L_Log table]]
 |-
-|| '''CCI_Pick_Code''' || number(long integer) || link to [[s_CCI_Picklist table]]
+|| '''[[CCI_Picklist_Code]]''' || text(20) || code and link to [[s_CCI_Picklist table]]
 |-
 || '''[[Px_Date]]''' || Date/Time || [[Px_Date]]
 |-
-|| '''[[Px_Date]]_unknown''' || yes/no || mus be set to true if no [[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
@@ Line 24: / Line 24: @@
 == How it works ==
-One field stores a single [[CCI Procedure]]:
+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_Combined]].
-* [[CCI_Pick_Code]] -  <number between 1-8>.<2 letters>.<2 numbers><optionally more letters>
-To understand all [[CCI Procedure]]s for a patient, consider [[L CCI Component table]] and [[L CCI Component table]] together, eg. by using the [[Query L CCI Resolver]].
 == Related Articles ==
 {{Related Articles}}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: ICD10/CCI Conversion]]
+[[Category:ICD10/CCI Conversion]]
-[[Category: CCI]]
+[[Category:CCI]]
-[[Category: L Table]]
+[[Category:L Table]]
-[[Category: CCI Data Structure]]
+[[Category:CCI Data Structure]]
-[[Category: L CCI Picklist table]]
+[[Category:L CCI Picklist table]]
+[[Category:CCI Picklist Coding]]