Query check CCI each count vs LOS: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 44: | Line 44: | ||
{{CCMDB.accdb cross checks triggering for correct values}} | {{CCMDB.accdb cross checks triggering for correct values}} | ||
== disucssion == | |||
{{TT | | {{TT | | ||
* is there a function we can use for the threshold? That would be easier to implement than a list like that. If SAS as a way to generate functions (like excel does for its trendlines) then could you run that? [[User:Ttenbergen|Ttenbergen]] 09:02, 2021 September 2 (CDT) | * is there a function we can use for the threshold? That would be easier to implement than a list like that. If SAS as a way to generate functions (like excel does for its trendlines) then could you run that? [[User:Ttenbergen|Ttenbergen]] 09:02, 2021 September 2 (CDT) | ||
| Line 49: | Line 50: | ||
*** this cross check is not just for CXR, but any CCI. Do those numbers still make sense? Or does the same check for all CCI not make sense? I am OK if we only want to check for CXR. [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 September 2 (CDT) | *** this cross check is not just for CXR, but any CCI. Do those numbers still make sense? Or does the same check for all CCI not make sense? I am OK if we only want to check for CXR. [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 September 2 (CDT) | ||
**** yes, i think applicable to the CCI count each (CXR, AXR and Blood gasses). ECMO count days should not exceed LOS. For Transfusion count units, I need to run the stats. 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) | **** yes, i think applicable to the CCI count each (CXR, AXR and Blood gasses). ECMO count days should not exceed LOS. For Transfusion count units, I need to run the stats. 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) | ||
***** discussed with Julie: make soft check, no more than LOS*2 for count each; count days should not be > LOS; count units is likely uncheckable. [[User:Ttenbergen|Ttenbergen]] 15:47, 2021 September 2 (CDT) }} | ***** discussed with Julie: make soft check, no more than LOS*2 for count each; count days should not be > LOS; count units is likely uncheckable. [[User:Ttenbergen|Ttenbergen]] 15:47, 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) }} | |||
== Related articles == | == Related articles == | ||