Project Borrow arrive: Difference between revisions

(6 intermediate revisions by 2 users not shown)

Line 4:

|ProjectRequestor=Critical Care program (Allan Garland)

|ProjectCollectionStartDate=2018-07-19

|ProjectCollectionStopDate=~~2020~~-01-29

|ProjectCollectionStopDate=2019-09-20

|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.~~ "

** emailed Julie to ~~find out if we really want to do this Ttenbergen 00:10, 2020 July 25 (CDT)~~

*** Trish meant to say "~~replace the project name 'Borrow Arrive' to '~~Boarding Loc~~' to combine the two projects which are actually collecting the same information.~~" ~~This is fine with me - no messing with my program. I prefer this too. Can Pagasa be able to do this by herself or she needs your help?~~ --~~[[User:JMojica|JMojica]] 13:43, 2020 July 27 (CDT)~~

**** Pagasa should be able to do this with an update query. Pagasa do you want to give this a try and let me know how it goes? If you run into problems with it we can zoom to work it out. ~~Ttenbergen 21:55, 2020 July 30 (CDT)~~

}}

{{LegacyContent

Line 31:

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.

* but [[2025-05 Revision of concept around ICUotherService]] will make it obsolete.

== Data Collection Instructions ==

Line 70:

Line 66:

=== 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.

Line 77:

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 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 ===

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

Line 95:

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.

** 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)}}~~

Line 109:

Line 102:

::: 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 ==

@@ Line 4: / Line 4: @@
 |ProjectRequestor=Critical Care program (Allan Garland)
 |ProjectCollectionStartDate=2018-07-19
-|ProjectCollectionStopDate=2020-01-29
+|ProjectCollectionStopDate=2019-09-20
 |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. "
-** emailed Julie to find out if we really want to do this Ttenbergen 00:10, 2020 July 25 (CDT)
-*** Trish meant to say "replace the  project name 'Borrow Arrive' to 'Boarding Loc' to combine the two projects which are actually collecting the same information."  This is fine with me - no messing with my program.  I prefer this too. Can Pagasa be able to do this by herself or she needs your help?  --[[User:JMojica|JMojica]] 13:43, 2020 July 27 (CDT)
-**** Pagasa should be able to do this with an update query. Pagasa do you want to give this a try and let me know how it goes? If you run into problems with it we can zoom to work it out. Ttenbergen 21:55, 2020 July 30 (CDT)
-}}
 {{LegacyContent
@@ Line 31: / 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.
+* but [[2025-05 Revision of concept around ICUotherService]] will make it obsolete.
 == Data Collection Instructions ==
@@ Line 70: / Line 66: @@
 === 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.
@@ Line 77: / 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 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 ===
 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
@@ Line 95: / 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.
-** 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}}
@@ Line 109: / Line 102: @@
 ::: 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 ==