CCMDB Wiki

Query check CCI each count vs LOS: Difference between revisions

← Older editNewer edit →
mNo edit summary
m Query check CCI Picklist duplicates and query check_CCI_Date take care of those things. If they don't, then they are still what would need to be fixed to take care of those things. So I think this question is now addressed.
Line 13: Line 13:
=== What are likely maximum entries? ===
=== What are likely maximum entries? ===
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.  
 
{{DT|_dev_CCMDB
* need to update to new AdmDate }}
*LOS based on calendar dates = [[Dispo DtTm]] - ([[Accept DtTm]]/first [[Service tmp entry]]) + 1
*LOS based on calendar dates = [[Dispo DtTm]] - ([[Accept DtTm]]/first [[Service tmp entry]]) + 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
Line 63: Line 64:


=== CCI collect each ===
=== CCI collect each ===
{{DJ |
Discussed with Julie and no specific checks required for this one.  
* Any checks required for these?
**none except that the dates should be within the LOS which I think  you already have and no dup of dates.--[[User:JMojica|JMojica]] 15:54, 2022 January 19 (CST)
*** [[Query check CCI Picklist duplicates]] and [[query check_CCI_Date]] take care of those things. If they don't, then they are still what would need to be fixed to take care of those things. So I think this question is now addressed.
}}
 
== Remaining Discussion - cross check by boarding loc?  ==
{{Discuss | who = Julie | question =
* ... This reminds me of another concern - should this be done vis-a-vis to boarding loc. if pt moves to another loc, enter a separate CXR entry starting on the next boarding loc date.  Are we over doing these CCIs - too much work, are they needed?  In the CC report, I need only a separation of CXR for HSC MICU and HSC SICU.  This would not be a problem if we are handling  continuous stay of MICU and SICU service  in two records and not as one record in patient follow model.  --[[User:JMojica|JMojica]] 14:36, 2021 September 2 (CDT)
** additional decision needed from [[Px Date]] - if we do collect different dttms for each Boarding Loc then the count needs to be per Boarding Loc LOS, not overall LOS. [[User:Ttenbergen|Ttenbergen]] 15:52, 2021 September 2 (CDT)
*** I am checking the sum of all counts in CCI since collectors can enter them over time, so for now I can do a cross check over overall LOS. If we want to break the cross check down further, let's discuss. [[User:Ttenbergen|Ttenbergen]] 16:49, 2021 September 15 (CDT)
**** i think what you did is OK. no need to split by each boarding loc. --[[User:JMojica|JMojica]] 15:56, 2022 January 19 (CST)}}
 
 


{{Todo  
{{Todo  
Line 85: Line 73:
* Confirm that this will work with the time components of [[Px Date]].  
* Confirm that this will work with the time components of [[Px Date]].  
}}
}}
== Log ==
* 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)


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