Query check CCI each count vs LOS: Difference between revisions

mNo edit summary
JMojica (talk | contribs)
No edit summary
Line 47: Line 47:
* 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)
** looks like from the list above,  the mean plus 3 std of 2 per day is common except when LOS <1.  we can use the function twice of LOS.  the CXR should not exceed  twice of LOS.  when LOS <1, should not exceed 5. When LOS is 51 or more, should not exceed LOS.  --[[User:JMojica|JMojica]] 09:18, 2021 September 2 (CDT)
** looks like from the list above,  the mean plus 3 std of 2 per day is common except when LOS <1.  we can use the function twice of LOS.  the CXR should not exceed  twice of LOS.  when LOS <1, should not exceed 5. When LOS is 51 or more, should not exceed LOS.  --[[User:JMojica|JMojica]] 09:18, 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) }}
*** 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) }}


== Related articles ==
== Related articles ==