Project Borrow arrive: Difference between revisions

mNo edit summary
No edit summary
 
(9 intermediate revisions by 2 users not shown)
Line 4: Line 4:
|ProjectRequestor=Critical Care program (Allan Garland)
|ProjectRequestor=Critical Care program (Allan Garland)
|ProjectCollectionStartDate=2018-07-19
|ProjectCollectionStartDate=2018-07-19
|ProjectCollectionStopDate=2020-01-29
|ProjectCollectionStopDate=2019-09-20
|Project=Borrow arrive
|Project=Borrow arrive
}}
}}
{{Discuss |
All remaining "Borrow arrive" entries were changed to "[[Boarding Loc]]" 2020-08-05.
* Trish said " Legacy - need to get updated in master database change to all borrow arrive to boarding Loc instead of 2 different things that mean the same things now is main database.  Julie had mentioned but can be done later. "
** Trish, what do you mean by that? Ttenbergen 10:52, 2020 May 14 (CDT)
}}


{{LegacyContent
{{LegacyContent
Line 29: Line 26:


This project does '''not''' replace [[ICUotherService]]; we will still need this item in the event that both the bed and the service are both borrowed. Administration at STB want this data.  
This project does '''not''' replace [[ICUotherService]]; we will still need this item in the event that both the bed and the service are both borrowed. Administration at STB want this data.  
* but [[2025-05 Revision of concept around ICUotherService]] will make it obsolete.


== Data Collection Instructions ==
== Data Collection Instructions ==
Line 68: Line 66:


=== Special Case - original arrival is in "borrowed bed" ===
=== Special Case - original arrival is in "borrowed bed" ===
If pt is admitted to your physician service but the original location is from an off-ward bed, code that location  [[Arrive DtTm]] = borrow date and time.
If pt is admitted to your physician service but the original location is from an off-ward bed, code that location  ''Arrive DtTm'' = borrow date and time.


The APACHE elements time frame will start in the off-ward bed location and TISS starts from the off-ward bed as well.
The APACHE elements time frame will start in the off-ward bed location and TISS starts from the off-ward bed as well.
Line 75: Line 73:
If a bed is borrowed in PACU / post-anesthesia care / recovery unit, code this as a '''borrow'''. (i.e. <hosp> - recovery, e.g. "HSC - recovery").
If a bed is borrowed in PACU / post-anesthesia care / recovery unit, code this as a '''borrow'''. (i.e. <hosp> - recovery, e.g. "HSC - recovery").


If the decision to accept to the service happens in PACU, the [[Arrive DtTm]] = the borrow date and time.  The APACHE elements are collected at PACU stay and TISS starts at PACU.
If the decision to accept to the service happens in PACU, the ''Arrive DtTm'' = the borrow date and time.  The APACHE elements are collected at PACU stay and TISS starts at PACU.


=== Special Case - From ER ===
=== Special Case - From ER ===
Not included in this project.   
Not included in this project.   
*The time spent/waiting in ER is done using [[Arrive DtTm]] vs [[Accept DtTm]].
*The time spent/waiting in ER is done using ''Arrive DtTm'' vs ''Accept DtTm''.
**March 30.19: own ward, to own ER (under ICU physician care) then to own ICU when bed available.  Started occurring at Grace- March 30.19
**March 30.19: own ward, to own ER (under ICU physician care) then to own ICU when bed available.  Started occurring at Grace- March 30.19


Line 93: Line 91:


* --[[User:JMojica|JMojica]] 11:17, 2018 November 15 (CST)  --  Added some more as shown by the data.  Just a note - only 30 out of 1807 (2%) records have shown borrowed location while 98% have no borrow. This is expected since STB ACCU has stopped borrowing bed and instead, now borrowing service from ICMS /ICCS which is being collected in another tmp project. The site with most frequent borrower is HSC SICU (i.e. borrowing bed from PACU). How much work will it take to do all these integrity checks?  Also with very few useful data, I think we should not collect this project for all admissions but restore the use of [[Off ward field]] checkbox and  collect only for those with YES Off ward.  
* --[[User:JMojica|JMojica]] 11:17, 2018 November 15 (CST)  --  Added some more as shown by the data.  Just a note - only 30 out of 1807 (2%) records have shown borrowed location while 98% have no borrow. This is expected since STB ACCU has stopped borrowing bed and instead, now borrowing service from ICMS /ICCS which is being collected in another tmp project. The site with most frequent borrower is HSC SICU (i.e. borrowing bed from PACU). How much work will it take to do all these integrity checks?  Also with very few useful data, I think we should not collect this project for all admissions but restore the use of [[Off ward field]] checkbox and  collect only for those with YES Off ward.  
** We are checking in with [[HSC_SICU]] to see how they use this data.
{{Discuss |who=Julie | question= did they ever get back to us?  no response from HSC SICU --[[User:JMojica|JMojica]] 10:14, 2019 May 6 (CDT)}}
{{Data Integrity Check List}}
{{Data Integrity Check List}}


Line 107: Line 102:
::: where Next Arrival Date_time = Dispo Date_time if there is no more next arrival date_time.  
::: where Next Arrival Date_time = Dispo Date_time if there is no more next arrival date_time.  


The SAS program is saved in X:\Julie\SAS_CFE\CFE_macros\Bed_Borrow.sas
The SAS program is saved in {{S:\MED\MED_CCMED}}Julie\SAS_CFE\CFE_macros\Bed_Borrow.sas


== Background ==
== Background ==