2020-03 HSC COVID unit transition: Difference between revisions

(29 intermediate revisions by 5 users not shown)

Line 1:

This page is about the transition of collection units at HSC to accommodate the new COVID unit.

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

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

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

===HSC_D4_COVID===

See [[HSC_D4_COVID]] for how we will collect the new ward.

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

** "HSC_D4_pre_COVID" to "HSC_D4_P"

** [[HSC_D5_Pre_COVID]] to [[HSC_D5_P]]

** [[HSC_D4_COVID]] to [[HSC_D4_C]]

~~{{DT |~~

* Once the last of these is sent we can name them back to their longer, more expressive versions. }}

~~{{DT |~~

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

* deactivate HSC_D4_P / HSC_D5_P in [[s_tmp table]] once last pt has moved. }}

~~== How will we identify these patients in EPR ==~~

~~EPR reports should work for the new locations as usual.~~

== Transition plan ==

Due to the original transition plan duplicate records were created:

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

Line 29:

Line 24:

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

# change the [[Service/Location]] of the record to the new location (ie to [[HSC_WRS3]] resp [[HSC_D5]] )

Line 39:

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 54:

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"

~~{{DT |~~

** 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 75:

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.

~~== Cross checks ==~~

~~{{Discuss |~~

* We have no [[CCMDB.accdb Data Integrity Checks]] yet for [[Boarding Loc]] , so that won’t limit our options. Is this the time to add cross-checks?

}}

~~{{Discuss |~~

* Have not yet checked how this will impact [[CFE Data Integrity Checks]]. Pagasa, of the top of your head which would be impacted and how?

}}

== Related articles ==

Line 90:

Line 76:

[[Category: 2020 COVID unit transition ]]

[[Category:2020 COVID unit transition ]]

[[Category: Legacy Data Collection]]

[[Category:Legacy Data Collection]]

@@ Line 1: / Line 1: @@
-This page is about the transition of collection units at HSC to accommodate the new COVID unit.
+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 ==
+==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''' - '''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]]
+** ''''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 ===
+===HSC_D4_COVID===
 See [[HSC_D4_COVID]] for how we will collect the new ward.
 == 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]]
+** "HSC_D4_pre_COVID" to "HSC_D4_P"
 ** [[HSC_D5_Pre_COVID]] to [[HSC_D5_P]]
 ** [[HSC_D4_COVID]] to [[HSC_D4_C]]
-{{DT |
-* Once the last of these is sent we can name them back to their longer, more expressive versions. }}
-{{DT |
+== Transition plan A - on or after March 19/20, 2020 ==
-* deactivate HSC_D4_P / HSC_D5_P in [[s_tmp table]] once last pt has moved. }}
-== How will we identify these patients in EPR ==
-EPR reports should work for the new locations as usual.
-== Transition plan ==
 Due to the original transition plan duplicate records were created:
 * one with the the original, pre-covid location (only renamed), and negative Pat_ID
@@ Line 29: / Line 24: @@
 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
 # change the [[Service/Location]] of the record to the new location (ie to [[HSC_WRS3]] resp [[HSC_D5]] )
@@ Line 39: / 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 54: / 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"
-{{DT |
-** 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 75: / 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.
-== Cross checks ==
-{{Discuss |
-* We have no [[CCMDB.accdb Data Integrity Checks]] yet for [[Boarding Loc]] , so that won’t limit our options. Is this the time to add cross-checks?
-}}
-{{Discuss |
-* Have not yet checked how this will impact [[CFE Data Integrity Checks]]. Pagasa, of the top of your head which would be impacted and how?
-}}
 == Related articles ==
@@ Line 90: / Line 76: @@
-[[Category: 2020 COVID unit transition ]]
+[[Category:2020 COVID unit transition ]]
-[[Category: Legacy Data Collection]]
+[[Category:Legacy Data Collection]]