CCMDB Wiki

2020-03 HSC COVID unit transition: Difference between revisions

← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,815 edits
No edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(9 intermediate revisions by 2 users not shown)
Line 4: Line 4:
* '''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
** ?? - 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]]
* '''Friday March 20.20''' - '''D4''' will be the new COVID-19 ward ([[HSC_D4_C]] )
* '''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===
===HSC_D4_COVID===
Line 13: 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]]
{{todo
| who = Tina
|
* 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.
| todo_action = 2020-06-03}}


== Transition plan A - on or after March 19/20, 2020 ==
== Transition plan A - on or after March 19/20, 2020 ==
Line 39: Line 34:


=== data processor instructions ===
=== 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.  
The change of [[Service/Location]] will cause [[Orphans in Centralized_data.accdb]]. 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.  


{{Collapsable  
{{Collapsable  
Line 54: Line 49:
** original remains with renamed location [[HSC_D5_Pre_COVID]], '''negative'' of [[Serial number]] as before, [[Dispo]] will be [[HSC_WRS3]]
** original remains with renamed location [[HSC_D5_Pre_COVID]], '''negative'' of [[Serial number]] as before, [[Dispo]] will be [[HSC_WRS3]]
** other copy will be [[HSC_WRS3]], same [[Serial number]] as before, [[Previous Location]] will be [[HSC_D5_Pre_COVID]]
** other copy will be [[HSC_WRS3]], same [[Serial number]] as before, [[Previous Location]] will be [[HSC_D5_Pre_COVID]]
** This may resulted 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 cleaned these up and emailed Pagasa with further info.
** This may resulted in [[Orphans in Centralized_data.accdb]]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 cleaned these up and emailed Pagasa with further info.


==== H4 (old D4) ====
==== H4 (old D4) ====
* 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 72: Line 65:
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 ==
Line 105: Line 76:




[[Category: 2020 COVID unit transition ]]
[[Category:2020 COVID unit transition ]]
[[Category: Legacy Data Collection]]
[[Category:Legacy Data Collection]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=2020-03_HSC_COVID_unit_transition"