2020-03 HSC COVID unit transition: Difference between revisions

(10 intermediate revisions by 3 users not shown)

Line 3:

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

* '''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''' – 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===

Line 12:

Line 14:

== Temporary naming ==

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

Line 38:

Line 34:

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

Line 53:

Line 49:

** 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]]

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

* 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]]

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

Line 74:

Line 68:

== Reporting ==

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

Line 80:

Line 76:

[[Category: 2020 COVID unit transition ]]

[[Category:2020 COVID unit transition ]]

[[Category: Legacy Data Collection]]

[[Category:Legacy Data Collection]]

@@ Line 3: / Line 3: @@
 ==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)
-* '''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''' – 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===
@@ Line 12: / Line 14: @@
 == Temporary naming ==
 * 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 ==
@@ Line 38: / Line 34: @@
 === 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
@@ Line 53: / Line 49: @@
 ** 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]]
-** 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) ====
 * 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]]
-** 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.
@@ Line 74: / Line 68: @@
 == Reporting ==
 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 ==
@@ Line 80: / Line 76: @@
-[[Category: 2020 COVID unit transition ]]
+[[Category:2020 COVID unit transition ]]
-[[Category: Legacy Data Collection]]
+[[Category:Legacy Data Collection]]