2020-03 HSC COVID unit transition: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Moved MICU / SICU change to 2020-04 HSC COVID unit transition since it)
m (removed links to accept and arrive dttm)
 
(11 intermediate revisions by 3 users not shown)
Line 3: Line 3:
==Background==
==Background==
* '''Thursday March 19.20''' – patients in [[HSC_D5_Pre_COVID]] will be moving to [[HSC_WRS3]] (Level 3 of 735 Notre Dame Ave. old womens Hosp)
* '''Thursday March 19.20''' – patients in [[HSC_D5_Pre_COVID]] will be moving to [[HSC_WRS3]] (Level 3 of 735 Notre Dame Ave. old womens Hosp)
* '''Friday March 20.20''' – patients in [[HSC_D4_pre_COVID]] will be moving to [[HSC D5]]
** ?? - patients from [[HSC_WRS3]] will move back to HSC D5
* '''Friday March 20.20''' - '''D4''' will be the new COVID-19 ward ([[HSC_D4_COVID]] ?)
* '''Friday March 20.20''' – patients in "HSC_D4_pre_COVID" will be moving to [[HSC D5]]
* '''Wednesday April 1'''- [[HSC_H4]] patients moved to HSC D4 as suspect COVID cases ([[HSC_H4]] closed for terminal clean)
** ''''Friday May 29.20''' - D service patients from [[HSC D5]] will move back to [[HSC D4]]
** '''all''' [[HSC_H4]]  patients were moved to [[HSC_D4_C]] and were all considered as covid suspects.  and  they are the ones who were now labeled as D4 suspects who later move to [[HSC_D2_C]] in Apr 3. the ones left at [[HSC_D4_C]] are all COVID+. HSC_H4 is vacant from April 1 forward
* '''Friday March 20.20''' - '''D4''' will be the new COVID-19 ward ([[HSC_D4_C]] )
* '''Friday April 3''' - D4 Suspect patients moved to D2 Covid Suspect ward (D4-C is now the COVID positive ward)
*'''July 27.21''' - '''B2B''' only COVID ward open at HSC
* '''Tuesday April 7'''- B2B moved to WRS2
{{Discuss|
* is this the same B2 which was occupied by H4H in April 14?  --[[User:JMojica|JMojica]] 14:10, 2020 April 22 (CDT)
** No this is not the same B2, this B2 refers to CAU which was located there prior to H4H moving there, B2B is part of the medicine contingency, both B2 (CAU) and B2B (contingency) moved to WRS2 [[User:Lkaita|Lisa Kaita]] 14:20, 2020 May 1 (CDT)
*** Where do we need to integrate this info? [[HSC_B2]]? Or do we need this at all? This seems to be about a change that is now complete, so we would need to update those pages on the wiki that explain these units, so that if someone looks at them in the future outside of the COVID context, the info is correct. Ttenbergen 10:23, 2020 May 5 (CDT)
****I don't think we need this info at all. this adds confusion. we should mention here only those home wards we are collecting. I suppose these contingency location will only appear in the TMP boarding location and does not need to be very accurate. --[[User:JMojica|JMojica]] 13:44, 2020 May 6 (CDT)}}
* '''Tuesday April 14'''- H4H moved to B2
* '''Wednesday April 15- H4 reopened '''


===HSC_D4_COVID===
===HSC_D4_COVID===
Line 22: Line 14:
== Temporary naming ==
== Temporary naming ==
* changed names of the following in [[s_dispo table]] because the longer version was breaking sending:  
* changed names of the following in [[s_dispo table]] because the longer version was breaking sending:  
** [[HSC_D4_pre_COVID]] to [[HSC_D4_P]] - 3 incomplete as of 2020-05-14
** "HSC_D4_pre_COVID" to "HSC_D4_P"
** [[HSC_D5_Pre_COVID]] to [[HSC_D5_P]] - 1 incomplete as of 2020-05-14
** [[HSC_D5_Pre_COVID]] to [[HSC_D5_P]]
** [[HSC_D4_COVID]] to [[HSC_D4_C]] - 2 incomplete as of 2020-05-14
** [[HSC_D4_COVID]] to [[HSC_D4_C]]
{{TT |
* Once the last of these is sent we can name them back to their longer, more expressive versions.
* deactivate HSC_D4_P / HSC_D5_P in [[s_tmp table]] once last pt has moved. }}


== How will we identify these patients in EPR ==
== Transition plan A - on or after March 19/20, 2020 ==
EPR reports should work for the new locations as usual.
 
== Transition plan ==
Due to the original transition plan duplicate records were created:
Due to the original transition plan duplicate records were created:
* one with the the original, pre-covid location (only renamed), and negative Pat_ID
* one with the the original, pre-covid location (only renamed), and negative Pat_ID
Line 38: Line 24:
The plan was chagned as follows.  
The plan was chagned as follows.  


=== collector instructions ===
=== collector instructions for Transition Plan A ===
# delete the duplicate record with the positive Pat_ID, and keep the one with the negative Pat_ID
# delete the duplicate record with the positive Pat_ID, and keep the one with the negative Pat_ID
# change the [[Service/Location]] of the record to the new location (ie to [[HSC_WRS3]] resp [[HSC_D5]] )
# change the [[Service/Location]] of the record to the new location (ie to [[HSC_WRS3]] resp [[HSC_D5]] )
Line 68: Line 54:
* for patients who previously had [[Service/Location]] "HSC_D4":  
* for patients who previously had [[Service/Location]] "HSC_D4":  
** original will remain with renamed location [[HSC_D4_pre_COVID]], '''negative'' of [[Serial number]] as before, [[Dispo]] will be [[HSC_D5]]
** original will remain with renamed location [[HSC_D4_pre_COVID]], '''negative'' of [[Serial number]] as before, [[Dispo]] will be [[HSC_D5]]
** other copy will be [[HSC_D5]], same [[Serial number]] as before, [[Previous Location]] will be [[HSC_D4_pre_COVID]], [[Accept_DtTm]] blank and [[Arrive_DtTm]] blank
** other copy will be [[HSC_D5]], same [[Serial number]] as before, [[Previous Location]] will be [[HSC_D4_pre_COVID]], "Accept_DtTm" blank and "Arrive_DtTm"
{{TT |
** This may result in [[Orphans in Centralized data.mdb]] for these patients, since the the D5 entry was renamed and therefore the dispo_ID remains the same, but the serial was turned negative. Tina will discuss with Pagasa }}


'''Collector will set the [[Dispo_DtTm]] and [[Arrive_DtTm]] to official transition time, doesn't so much matter what they use but should be consistent in the two records.'''
'''Collector will set the [[Dispo_DtTm]] and "Arrive_DtTm" to official transition time, doesn't so much matter what they use but should be consistent in the two records.'''


Collectors will continue the same serial pool they used for the old [[Service/Location]] at the new one. That way they can just up the count from where they were.  
Collectors will continue the same serial pool they used for the old [[Service/Location]] at the new one. That way they can just up the count from where they were.  
Line 84: Line 68:
== Reporting ==
== Reporting ==
Med reporting is by ward and combined.  
Med reporting is by ward and combined.  
service location D5 before March 19 and WRS3N can be together.
# service location D5 and WRS3 are together.
# service location D5_D and D4 are together.
 


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

Latest revision as of 11:41, 2022 April 21

This page is about the March transition of collection units at HSC to accommodate the new COVID unit. See 2020-04 HSC COVID unit transition about further transitions in April.

Background

  • Thursday March 19.20 – patients in HSC_D5_Pre_COVID will be moving to HSC_WRS3 (Level 3 of 735 Notre Dame Ave. old womens Hosp)
    • ?? - patients from HSC_WRS3 will move back to HSC D5
  • Friday March 20.20 – patients in "HSC_D4_pre_COVID" will be moving to HSC D5
    • 'Friday May 29.20 - D service patients from HSC D5 will move back to HSC D4
  • Friday March 20.20 - D4 will be the new COVID-19 ward (HSC_D4_C )
  • July 27.21 - B2B only COVID ward open at HSC

HSC_D4_COVID

See HSC_D4_COVID for how we will collect the new ward.

Temporary naming

Transition plan A - on or after March 19/20, 2020

Due to the original transition plan duplicate records were created:

  • one with the the original, pre-covid location (only renamed), and negative Pat_ID
  • one with the future location, and negative Pat_ID

The plan was chagned as follows.

collector instructions for Transition Plan A

  1. delete the duplicate record with the positive Pat_ID, and keep the one with the negative Pat_ID
  2. change the Service/Location of the record to the new location (ie to HSC_WRS3 resp HSC_D5 )
  3. enter the actual location as part of Boarding Loc:
    • for patients who had no location borrowing during transition:
      • change the "no borrow" line to "HSC_D5_P", resp "HSC_D4_P"
      • add a line for "HSC - Home medicine ward" with the time that the patient was actually moved
    • if there were patients who actually were in a borrow location during the transition, let's talk about how we would enter those

data processor instructions

The change of Service/Location will cause Orphans in Centralized data.mdb. Query COV_Pat_ID_matcher should help with cleanup. You may need to change the parameters H4/H5 to make it work for the respective laptop.

original plan, keep until fully backed out, but THIS IS NOT HOW WE WILL DO IT   

Tina will pull data from the D4 and D5 laptops and collectors will need to do a CCMDB data.mdb restore from Regional Server before collection.

  • Old D5 laptop (Laptop identifier H5) will need to do this first thing on the morning of Thursday, March 19
  • Old D4 laptop (Laptop identifier H4) will need to do this first thing on the morning of Friday, March 20

Tina will duplicate all records for units D4 and D5 that don't have a Dispo_DtTm. The Service/Location and Serial number sequences will be as follows.

H5 (old D5)

H4 (old D4)

Collector will set the Dispo_DtTm and "Arrive_DtTm" to official transition time, doesn't so much matter what they use but should be consistent in the two records.

Collectors will continue the same serial pool they used for the old Service/Location at the new one. That way they can just up the count from where they were.

We will not need to add _a, _b, _d to the new locations because including the laptop identifier in D_ID takes care of that.

Why not do this with one entry rather than 2?

We could have had one entry, started at old location and then ended at new location. The transition might have been quite prolonged since a pt may have been on ward for long time, and might stay there for long time, especially with D5 population. We would have been in a transition status for months. Possibly longer than this new arrangement will stay. With the current dynamic state, best to have a transition we can complete in a predictable time frame.

Reporting

Med reporting is by ward and combined.

  1. service location D5 and WRS3 are together.
  2. service location D5_D and D4 are together.


Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=2020-03_HSC_COVID_unit_transition&oldid=155665"