2020-03 HSC COVID unit transition: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
|||
| (20 intermediate revisions by 4 users not shown) | |||
| Line 2: | Line 2: | ||
==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''' | * '''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]] ) | ||
* '''Friday | *'''July 27.21''' - '''B2B''' only COVID ward open at HSC | ||
* ''' | |||
===HSC_D4_COVID=== | ===HSC_D4_COVID=== | ||
| Line 23: | 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" | ||
** [[HSC_D5_Pre_COVID]] to [[HSC_D5_P]] | ** [[HSC_D5_Pre_COVID]] to [[HSC_D5_P]] | ||
** [[HSC_D4_COVID]] to [[HSC_D4_C]] | ** [[HSC_D4_COVID]] to [[HSC_D4_C]] | ||
== Transition plan == | == Transition plan A - on or after March 19/20, 2020 == | ||
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 41: | 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 51: | Line 34: | ||
=== data processor instructions === | === data processor instructions === | ||
The change of [[Service/Location]] will cause [[Orphans in | 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 66: | 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 | ** 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]], | ** 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" | ||
'''Collector will set the [[Dispo_DtTm]] and | '''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 87: | Line 68: | ||
== Reporting == | == Reporting == | ||
Med reporting is by ward and combined. | Med reporting is by ward and combined. | ||
service location D5 | # service location D5 and WRS3 are together. | ||
# service location D5_D and D4 are together. | |||
== Related articles == | == Related articles == | ||
| Line 93: | Line 76: | ||
[[Category: 2020 COVID unit transition ]] | [[Category:2020 COVID unit transition ]] | ||
[[Category: Legacy Data Collection]] | [[Category:Legacy Data Collection]] | ||