L CCI Component table: Difference between revisions

(9 intermediate revisions by the same user not shown)

Line 1:

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

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

== Data Structure ==

Line 18:

|| '''[[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 30:

* [[CCI_2_Code]] - second component, <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~~]].

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

== Related Articles ==

[[Category: Data structure]]

[[Category:Data structure]]

[[Category: ICD10/CCI Conversion]]

[[Category:ICD10/CCI Conversion]]

[[Category: CCI]]

[[Category:CCI]]

[[Category: S_CCI_1 table]]

[[Category:S_CCI_1 table]]

[[Category: S_CCI_2 table]]

[[Category:S_CCI_2 table]]

[[Category:L CCI Component table]]

[[Category:CCI Data Structure]]

[[Category:CCI Component Coding]]

@@ Line 1: / Line 1: @@
-The '''L_CCI_Component''' table in [[CCMDB.mdb]] contains the [[CCI]] data collected as per [[CCI Collection]].
+The '''L_CCI_Component''' table in [[CCMDB.accdb]] contains the [[CCI]] data collected as per [[CCI Collection]]. It's the counterpart of the [[L CCI Picklist table]].
 == Data Structure ==
@@ Line 18: / Line 18: @@
 || '''[[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 30: / Line 30: @@
 * [[CCI_2_Code]] - second component, <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]].
+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]].
 == Related Articles ==
 {{Related Articles}}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: ICD10/CCI Conversion]]
+[[Category:ICD10/CCI Conversion]]
-[[Category: CCI]]
+[[Category:CCI]]
-[[Category: S_CCI_1 table]]
+[[Category:S_CCI_1 table]]
-[[Category: S_CCI_2 table]]
+[[Category:S_CCI_2 table]]
 [[Category:L CCI Component table]]
 [[Category:CCI Data Structure]]
 [[Category:CCI Component Coding]]