CCMDB Wiki

Query check CCI each count vs LOS: Difference between revisions

← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 24: Line 24:
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
We have had some CCI count entries that are so high that they are likely errors.


=== Imaging codes considered ===
=== Imaging codes considered ===
Line 42: Line 44:
* {{CCIPick ByCode|3.OT.10.VA}}
* {{CCIPick ByCode|3.OT.10.VA}}


=== Discussion ===
{{Discuss |
* Just came across this... the started query includes additional dxs now, as per [[#CCI collect count each]]. Does the proposed accepted count make sense for all the dxs? Your validation table was for CXR. [[User:Ttenbergen|Ttenbergen]] 11:50, 2023 May 3 (CDT)
** Did some checking on all 13 LAB Imaging from CCI picklist and found counts more than the LOS only in ECHO, AXR and CXR. Emailed Lisa and Pagasa March 14, 2024 to check if correct or not. Waiting for their feedbacks. In the email, I also propose another query (e.g. the counts per calendar day per patient must not be more than one) as alternative to the threshold limits LOS +- 3 STD shown below.  --[[User:JMojica|JMojica]] 10:55, 2024 March 18 (CDT)
*** That query is tighter and would therefore have more false positives. What does Lisa think about that? [[User:Ttenbergen|Ttenbergen]] 09:51, 2024 March 20 (CDT)
**** I made some limits per LOS group for CXR, AXR, ECHO and Blood gases and emailed the results to Tina and Lisa 3/25/2024 for discussion. ---[[User:JMojica|JMojica]] 13:28, 2024 March 25 (CDT)
***** Further emails with Julie and Lisa about details. Discussed with Lisa who is reviewing some of the errors and will hold off until she is done. [[User:Ttenbergen|Ttenbergen]] 12:46, 2024 April 8 (CDT)
}}


{{DT |
*


We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors.


=== What are likely maximum entries? ===
=== What are likely maximum entries? ===
Line 110: Line 101:


== Log ==
== Log ==
* 2024-04-24 - implemented LOS <7 and count >10 (i.e. double digits, because that's a likely fumble finger mistake)
* 2024-04-24 -  
** implemented LOS <7 and count >10 (i.e. double digits, because that's a likely fumble finger mistake)
** initially this was supposed to be for CXR, then general imaging, now all sorts of CCI entries
* 2022-02-10 - confirmed that this would not be affected by the change of including a time in the [[Px Date]]
* 2022-02-10 - confirmed that this would not be affected by the change of including a time in the [[Px Date]]
* 2022-01-19 - Julie confirmed that we don't need to check this per [[Boarding Loc]] - per profile is enough (especially since it's a soft check)
* 2022-01-19 - Julie confirmed that we don't need to check this per [[Boarding Loc]] - per profile is enough (especially since it's a soft check)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_each_count_vs_LOS"