2020-03 HSC COVID unit transition: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
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)
** ?? - 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 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 May 29.20''' - D service patients from [[HSC D5]] will move back to [[HSC D4]]
Line 71: Line 72:
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.
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.
}}
}}
== Transition plan B ==
=== D Service Patients from HSC D5 to HSC D4 on or after May 29, 2020 ===
# This transition plan is only for the patients with service_location= HSC D5 who moved back to HSC D4
# The label pre-COVID [[HSC D4 P]] will be restored back to [[HSC D4]]
# All new patients admitted on or after May 29, 2020 on D4 will have service_location= [[HSC D4]] and follow the usual guideline for boarding loc in tmp
# The COVID suspect/positive patients  who were at D4 during the move will remain with service_location=[[HSC_D4_C]].
## if the result is negative and the patient stays at D4, the patient will be discharged from service_location=[[HSC_D4_C]] and a new profile will be done with service_location= [[HSC D4]]
## if the COVID suspect/positive patients move to another location, the patient will be discharged from service_location=[[HSC_D4_C]]. 
=== collector instructions for D Service patients  from D5 to D4 ===
# For patients discharged before May 29,2020, keep the Service/Location= [[HSC D5]] and in tmp "no borrow" or as appropriate.
# For patients discharged on or after May 29,2020, change the Service/Location from [[HSC D5]] to [[HSC_D4]] and in tmp, add the "HSC- boarding" and 'D5' in comment (or "HSC_D5" if available), date/time the patient arrived in D5 and the line for "HSC - Home medicine ward" with the time that the patient was actually moved to D4.
# After the last D service patient from D5 has been completed and submitted to the master database, the label for [[HSC D5]] will be changed to [[HSC D5 D]] to denote 'D service patient physically in D5 from March 20 to May 28, 2020 during the COVID season' .
=== Patients From WRS3 to HSC D5 on or after ?? ===
# This transition plan is only for the patients with service_location= HSC WRS3 who moved back to HSC D5
# All new patients admitted on or after ?? 2020 on D5 will have service_location= [[HSC D5 P]] and follow the usual guideline for boarding loc in tmp
=== collector instructions  for patients from WRS3 to D5 ===
# For patients discharged before ?? 2020, keep the Service/Location= [[HSC WRS3]] and in tmp "no borrow" or as appropriate.
# For patients discharged on or after ?? 2020, change the Service/Location from [[HSC WRS3]] to [[HSC D5 P]]  and in tmp, add the "HSC- boarding" and 'WRS3' in comment (or "HSC_WRS3" if available), date/time the patient arrived in WRS3 and the line for "HSC - Home medicine ward" with the time that the patient was actually moved to D5
# After the last D service patient  from D5 has been completed and submitted to the master database and the label for HSC D5 has been changed from [[HSC D5]] to [[HSC D5 D]],the label pre-COVID [[HSC D5 P]] will be restored back to [[HSC D5]]. This change will create orphans to the master database which will be deleted by the Data Processor.


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

Revision as of 10:51, 2020 May 27

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 )

HSC_D4_COVID

See HSC_D4_COVID for how we will collect the new ward.

Temporary naming

  • 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.
  • added: no added date
  • action: 2020-06-03
  • Cargo


  • Categories

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)

    • 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
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

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.

Transition plan B

D Service Patients from HSC D5 to HSC D4 on or after May 29, 2020

  1. This transition plan is only for the patients with service_location= HSC D5 who moved back to HSC D4
  2. The label pre-COVID HSC D4 P will be restored back to HSC D4
  3. All new patients admitted on or after May 29, 2020 on D4 will have service_location= HSC D4 and follow the usual guideline for boarding loc in tmp
  4. The COVID suspect/positive patients who were at D4 during the move will remain with service_location=HSC_D4_C.
    1. if the result is negative and the patient stays at D4, the patient will be discharged from service_location=HSC_D4_C and a new profile will be done with service_location= HSC D4
    2. if the COVID suspect/positive patients move to another location, the patient will be discharged from service_location=HSC_D4_C.

collector instructions for D Service patients from D5 to D4

  1. For patients discharged before May 29,2020, keep the Service/Location= HSC D5 and in tmp "no borrow" or as appropriate.
  2. For patients discharged on or after May 29,2020, change the Service/Location from HSC D5 to HSC_D4 and in tmp, add the "HSC- boarding" and 'D5' in comment (or "HSC_D5" if available), date/time the patient arrived in D5 and the line for "HSC - Home medicine ward" with the time that the patient was actually moved to D4.
  3. After the last D service patient from D5 has been completed and submitted to the master database, the label for HSC D5 will be changed to HSC D5 D to denote 'D service patient physically in D5 from March 20 to May 28, 2020 during the COVID season' .

Patients From WRS3 to HSC D5 on or after ??

  1. This transition plan is only for the patients with service_location= HSC WRS3 who moved back to HSC D5
  2. All new patients admitted on or after ?? 2020 on D5 will have service_location= HSC D5 P and follow the usual guideline for boarding loc in tmp

collector instructions for patients from WRS3 to D5

  1. For patients discharged before ?? 2020, keep the Service/Location= HSC WRS3 and in tmp "no borrow" or as appropriate.
  2. For patients discharged on or after ?? 2020, change the Service/Location from HSC WRS3 to HSC D5 P and in tmp, add the "HSC- boarding" and 'WRS3' in comment (or "HSC_WRS3" if available), date/time the patient arrived in WRS3 and the line for "HSC - Home medicine ward" with the time that the patient was actually moved to D5
  3. After the last D service patient from D5 has been completed and submitted to the master database and the label for HSC D5 has been changed from HSC D5 to HSC D5 D,the label pre-COVID HSC D5 P will be restored back to HSC D5. This change will create orphans to the master database which will be deleted by the Data Processor.


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: