Query check CCI each count vs LOS: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 5: | Line 5: | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding=query ''check_CCI_CXR_vs_LOS'' | |DIC_coding=query ''check_CCI_CXR_vs_LOS'' | ||
|DIC_status= | |DIC_status=ready to implement | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
{{Todo | |||
| who = Tina | |||
| todo_added = 2022-04-14 | |||
| todo_action = 2022-04-21 | |||
| question = _dev_CCMDB | |||
* Not currently implemented; starting point for the query exists but doesn't yet include Julie's values. Also, isn't being called from anywhere. | |||
}} | |||
We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors. | We have had some medical [[:Category:Labs Imaging]] count entries that are so high that they are likely errors. | ||
| Line 14: | Line 23: | ||
The count per patient stay is related to the [[LOS]]. The threshold limits are either Mean + 3 Standard Deviation or Maximum value of Chest X-ray count per patient day for various LOS category listed in the table below. They are derived from July 1988 to June 2017 Lab data. The LOS is based on calendar dates where partial stay is considered as full day. | The count per patient stay is related to the [[LOS]]. The threshold limits are either Mean + 3 Standard Deviation or Maximum value of Chest X-ray count per patient day for various LOS category listed in the table below. They are derived from July 1988 to June 2017 Lab data. The LOS is based on calendar dates where partial stay is considered as full day. | ||
*LOS based on calendar dates = [[ | *LOS based on calendar dates = [[Function LOS()|Function LOS()]] + 1 | ||
** if patient is still in the unit, [[Dispo DtTm]] is replaced by today's date | ** if patient is still in the unit, [[Dispo DtTm]] is replaced by today's date | ||
*** check is marked as only running on complete records, if that is so then we don't need to replace with today's date | *** check is marked as only running on complete records, if that is so then we don't need to replace with today's date | ||
| Line 48: | Line 57: | ||
=== CCI collect count each === | === CCI collect count each === | ||
*[[AXR (abdominal plain X-ray)]] 3.OT.10.VA | * [[AXR (abdominal plain X-ray)]] 3.OT.10.VA | ||
*[[Blood gas, arterial]] 2.ZZ.13.RE | * [[Blood gas, arterial]] 2.ZZ.13.RE | ||
*[[Blood gas, venous]] 2.ZZ.13.RA | * [[Blood gas, venous]] 2.ZZ.13.RA | ||
*[[CXR (plain film)]] 3.GY.10.VA | * [[CXR (plain film)]] 3.GY.10.VA | ||
"CCI collect count each" count should not be higher than: | "CCI collect count each" count should not be higher than: | ||
| Line 66: | Line 75: | ||
=== CCI collect each === | === CCI collect each === | ||
Discussed with Julie and no specific checks required for this one. | Discussed with Julie and no specific checks required for this one. | ||
== Log == | == Log == | ||
* 2022-02-10 - confirmed that this would not be | * 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) | ||