CCMDB Wiki

Query check CCI each count vs LOS: Difference between revisions

← Older editNewer edit →
mNo edit summary
Line 26: Line 26:


We have had some CCI count entries that are so high that they are likely errors.
We have had some CCI count entries that are so high that they are likely errors.
=== Imaging codes considered ===
* {{CCIPick ByCode|2.ZZ.13.RA}}
* {{CCIPick ByCode|2.ZZ.13.RE}}
* {{CCIPick ByCode|3.GY.10.VA}}
* {{CCIPick ByCode|3.ID.10.V^}}
* {{CCIPick ByCode|3.IP.10.V^}}
* {{CCIPick ByCode|3.IP.30}}
* {{CCIPick ByCode|3.IP.20}}
* {{CCIPick ByCode|3.IP.40}}
* {{CCIPick ByCode|3.IP.70}}
* {{CCIPick ByCode|3.JM.10.V^}}
* {{CCIPick ByCode|3.JY.20}}
* {{CCIPick ByCode|3.KV.10.VX}}
* {{CCIPick ByCode|3.KX.10.VC}}
* {{CCIPick ByCode|3.IM.10.V^}}
* {{CCIPick ByCode|3.OT.10.VA}}


{{CCMDB.accdb cross checks triggering for correct values}}
{{CCMDB.accdb cross checks triggering for correct values}}


== Checks ==
=== CCI codes considered ===
This uses [[Function LOS()]] to calculate the [[LOS]].
 
=== List of codes, pages and collection modes ===
{{#ask: [[Has CCI Picklist Code::2.ZZ.13.RA||2.ZZ.13.RE||3.GY.10.VA||3.ID.10.V^||3.IP.10.V^||3.IP.30||3.IP.20||3.IP.40||3.IP.70||3.JM.10.V^||3.JY.20||3.KV.10.VX||3.KX.10.VC||3.IM.10.V^||3.OT.10.VA]]
{{#ask: [[Has CCI Picklist Code::2.ZZ.13.RA||2.ZZ.13.RE||3.GY.10.VA||3.ID.10.V^||3.IP.10.V^||3.IP.30||3.IP.20||3.IP.40||3.IP.70||3.JM.10.V^||3.JY.20||3.KV.10.VX||3.KX.10.VC||3.IM.10.V^||3.OT.10.VA]]
  |?Has CCI Picklist Code=Code
  |?Has CCI Picklist Code=Code
Line 61: Line 37:
}}
}}


=== CCI collect count each ===
== Checks ==
This uses [[Function LOS()]] to calculate the [[LOS]].
 
=== [[Template:CCI collect count each|CCI collect count each]] and [[Template:CCI collect each|CCI collect each]] ===
These should be checked.  
These should be checked.  


=== CCI collect count days ===
=== [[Template:CCI collect count days|CCI collect count days]] ===
"CCI collect count days" should not be higher than LOS. See [[query check_CCI_vs_LOS_count_days_component]] and [[query check_CCI_vs_LOS_count_days_picklist]].
Implemented by [[query check_CCI_vs_LOS_count_days_component]] and [[query check_CCI_vs_LOS_count_days_picklist]].


=== CCI collect count units ===
=== [[Template:CCI collect count units|CCI collect count units]] ===
Discussed with Julie that this one is likely uncheckable. [[User:Ttenbergen|Ttenbergen]] 15:47, 2021 September 2 (CDT)
Discussed with Julie that this one is likely uncheckable. [[User:Ttenbergen|Ttenbergen]] 15:47, 2021 September 2 (CDT)
=== CCI collect each ===
Discussed with Julie and no specific checks required for this one.
{{DT | except now a bunch of these are collect each ones... }}


== Log ==
== Log ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_each_count_vs_LOS"