2020-03 HSC COVID unit transition: Difference between revisions

(42 intermediate revisions by 5 users not shown)

Line 1:

~~{{Discuss |~~

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.

* This page is about the transition of collection units at HSC to accommodate the new COVID unit. ~~Tina is using this as a brain dump for the moment, please don't edit for now~~. }}

== Background ==

==Background==

* '''Thursday March 19.20''' – patients in [[~~HSC_D5~~]] 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 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

* '''Friday March 20.20''' – patients in [[~~HSC D4~~]] will ~~be moving to [[HSC D5]]~~

===HSC_D4_COVID===

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

* ~~'''Friday March 20.20''' - '''D4''' will be~~ the ~~new COVID-19 ward (~~[[#HSC_D4_COVID]] ?)

== 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_D5_Pre_COVID]] to [[HSC_D5_P]]

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

==~~= HSC_D4_COVID =~~==

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

~~{{Discuss |~~

Due to the original transition plan duplicate records were created:

*~~Will we collect there? Exposure should be limited~~, but how much would we be able to get off charts, and would that still be useful? If we want to collect there, we will likely need a new [[Service/Location]] [[HSC_D4_COVID]]. If we are going to consider collecting the COVID ward at all (~~from EPR, no exposure~~), ~~let’s not do it on paper, let’s do it on a laptop. That way the data we can get without exposure is at least available for intermediate analysis.~~

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

*~~2020-Mar-18: email sent to Renner~~, ~~Lynch, Walker~~ and ~~Garland if there is expectation to gather info there for database, but it would be retropective,~~ as ~~I would no allow my staff into there fore this purpose~~.~~--[[User:TOstryzniuk|Trish Ostryzniuk]] 16:38, 2020 March 18 (CDT) }}~~

* one with the future location, and negative Pat_ID

The plan was chagned as follows.

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

=== collector instructions for Transition Plan A ===

~~{{Discuss |~~

# delete the duplicate record with the positive Pat_ID, and keep the one with the negative Pat_ID

* ~~What is not clear~~ to ~~me is how this will all look on our EPR reports~~, ~~I am assuming~~ that we will ~~now select WRS3 for D5, and D5 will now be the D4 census~~. ~~I did a quick check on~~ the ~~EPR and currently~~ the ~~list of options includes WRS3 (closed) as an option~~.

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

}}

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

=~~= Transition~~ plan ==

{{Collapsable

| always= original plan, keep until fully backed out, but THIS IS NOT HOW WE WILL DO IT

| full=

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:

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

* for patients who currently have [[Service/Location]] [[HSC_D5]]:

** ~~one copy will be~~ [[HSC_D5_Pre_COVID]], ~~same~~ [[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]], ~~'''negative''' of~~ 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]]

** (Previously completed/vetted patients in [[CFE]] with [[Service/Location]] [[HSC_D5]] will be changed to [[HSC_D5_Pre_COVID]], [[Serial number]]s and [[D_ID]]s will not be changed.

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

** This ~~will '''NOT''' 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

* for patients who currently have [[Service/Location]] [[HSC_D4]]:

** one copy will be [[HSC_D4]], same [[Serial number]] as before, ~~[[Dispo]] will be [[HSC_D5]]~~

** other copy will be [[HSC_D5]], '''negative~~''' of same [[Serial number]] as before, [[Previous Location]] will be [[HSC_D4]]~~

** (Previously completed/vetted patients in [[CFE]] with ~~[[Service/Location]] [[HSC_D4]] will require no change since, if we were to collect the new D4 it would be as [[HSC_D4_COVID]] .~~

** This will '''NOT''' result in [[Orphans in Centralized data.~~mdb]] for these patients, since the HSC_D4 entry remains'''~~

'''Collector will ~~have to~~ set the [[Dispo_DtTm]] to official transition time, doesn't so much matter what they use but should be consistent in the two records.'''

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

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

~~We might be able to get data from EPR Report directly, but not immediately~~

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

}}

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

Line 76:

[[Category: 2020~~-03~~ COVID unit transition | ]]

[[Category:2020 COVID unit transition ]]

[[Category:Legacy Data Collection]]

@@ Line 1: / Line 1: @@
-{{Discuss  |
+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.
-* This page is about the transition of collection units at HSC to accommodate the new COVID unit. Tina is using this as a brain dump for the moment, please don't edit for now. }}
-== Background ==
+==Background==
-* '''Thursday March 19.20''' – patients in [[HSC_D5]] 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 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
-* '''Friday March 20.20''' – patients in [[HSC D4]] will be moving to [[HSC D5]]
+===HSC_D4_COVID===
+See [[HSC_D4_COVID]] for how we will collect the new ward.
-* '''Friday March 20.20''' - '''D4''' will be the new COVID-19 ward ([[#HSC_D4_COVID]] ?)
+== 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_D5_Pre_COVID]] to [[HSC_D5_P]]
+** [[HSC_D4_COVID]] to [[HSC_D4_C]]
-=== HSC_D4_COVID ===
+== Transition plan A - on or after March 19/20, 2020 ==
-{{Discuss |
+Due to the original transition plan duplicate records were created:
-*Will we collect there? Exposure should be limited, but how much would we be able to get off charts, and would that still be useful? If we want to collect there, we will likely need a new [[Service/Location]] [[HSC_D4_COVID]]. If we are going to consider collecting the COVID ward at all (from EPR, no exposure), let’s not do it on paper, let’s do it on a laptop. That way the data we can get without exposure is at least available for intermediate analysis.
+* one with the the original, pre-covid location (only renamed), and negative Pat_ID
-*2020-Mar-18:  email sent to Renner, Lynch, Walker and Garland if there is expectation to gather info there for database, but it would be retropective, as I would no allow my staff into there fore this purpose.--[[User:TOstryzniuk|Trish Ostryzniuk]] 16:38, 2020 March 18 (CDT) }}
+* one with the future location, and negative Pat_ID
+The plan was chagned as follows.
-== How will we identify these patients in EPR ==
+=== collector instructions for Transition Plan A ===
-{{Discuss |
+# delete the duplicate record with the positive Pat_ID, and keep the one with the negative Pat_ID
-* What is not clear to me is how this will all look on our EPR reports,  I am assuming that we will now select WRS3 for D5, and D5 will now be the D4 census.    I did a quick check on the EPR and currently the list of options includes WRS3 (closed) as an option.
+# change the [[Service/Location]] of the record to the new location (ie to [[HSC_WRS3]] resp [[HSC_D5]] )
-}}
+# 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.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.
-== Transition plan ==
+{{Collapsable
+| always= original plan, keep until fully backed out, but THIS IS NOT HOW WE WILL DO IT
+| full=
 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:
+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) ====
 * for patients who currently have [[Service/Location]] [[HSC_D5]]:
-** one copy will be [[HSC_D5_Pre_COVID]], same [[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]], '''negative''' of 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]]
-** (Previously completed/vetted patients in [[CFE]] with [[Service/Location]] [[HSC_D5]] will be changed to [[HSC_D5_Pre_COVID]], [[Serial number]]s and [[D_ID]]s will not be changed.
+** 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.
-** This will '''NOT''' 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
-* for patients who currently have [[Service/Location]] [[HSC_D4]]:
-** one copy will be [[HSC_D4]], same [[Serial number]] as before, [[Dispo]] will be [[HSC_D5]]
-** other copy will be [[HSC_D5]], '''negative''' of same [[Serial number]] as before, [[Previous Location]] will be [[HSC_D4]]
-** (Previously completed/vetted patients in [[CFE]] with [[Service/Location]] [[HSC_D4]] will require no change since, if we were to collect the new D4 it would be as [[HSC_D4_COVID]] .
-** This will '''NOT''' result in [[Orphans in Centralized data.mdb]] for these patients, since the HSC_D4 entry remains'''
-'''Collector will have to set the [[Dispo_DtTm]] to official transition time, doesn't so much matter what they use but should be consistent in the two records.'''
+==== 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"
+'''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.
-We might be able to get data from EPR Report directly, but not immediately
 === 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.
+}}
 == 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 64: / Line 76: @@
-[[Category: 2020-03 COVID unit transition | ]]
+[[Category:2020 COVID unit transition ]]
+[[Category:Legacy Data Collection]]