2020-03 STB COVID unit transition: Difference between revisions
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) m Text replacement - "STB_E6" to "STB_E6_P" |
||
| Line 2: | Line 2: | ||
== Background == | == Background == | ||
STB is opening a number of beds on STB_A7S and STB_A7W. Patients from our usual [[ | STB is opening a number of beds on STB_A7S and STB_A7W. Patients from our usual [[STB_E6_P]] unit will move there, and the physical E6 location will become the COVID ward. | ||
==Date of change== | ==Date of change== | ||
| Line 12: | Line 12: | ||
| full= | | full= | ||
* there was a plan to only change names for some of the records, but because the names are really only linked values in the s_dispo table you can't change them for some, you have to make a new entry. | * there was a plan to only change names for some of the records, but because the names are really only linked values in the s_dispo table you can't change them for some, you have to make a new entry. | ||
* there were thoughts about continuing to collect these patients as | * there were thoughts about continuing to collect these patients as STB_E6_P even once on A7*; this might have been practical for that collector but would have been confusing for other collectors since their previous location and dispo fields should match, so we decided to name the Service/Location as it actually is. | ||
* we were going to have "STB_A7S" and "STB_A7W" but this was changed to [[STB_A7_B]] since it's the same ward | * we were going to have "STB_A7S" and "STB_A7W" but this was changed to [[STB_A7_B]] since it's the same ward | ||
}} | }} | ||
| Line 19: | Line 19: | ||
* In [[s_dispo table]]: | * In [[s_dispo table]]: | ||
** We create new entries for : | ** We create new entries for : | ||
*** [[ | *** [[STB_E6_P_C]] | ||
*** [[STB_A7_B]] | *** [[STB_A7_B]] | ||
** We change [[ | ** We change [[STB_E6_P]] to [[STB_E6_P_B]] | ||
*** | *** STB_E6_Pa --> STB_E6_PaB | ||
*** | *** STB_E6_Pb --> STB_E6_PbB | ||
*** | *** STB_E6_Pd --> STB_E6_PdB | ||
* In [[s_tmp table]]: | * In [[s_tmp table]]: | ||
** we add [[Boarding Loc]] entry " | ** we add [[Boarding Loc]] entry "STB_E6_P_P" that will stay active only during this transition. | ||
{{DT | Need to deactivate | {{DT | Need to deactivate STB_E6_P_P once transition is over. }} | ||
=== collector instructions === | === collector instructions === | ||
'''E6 / A7 Collector''' | '''E6 / A7 Collector''' | ||
* [[ | * [[STB_E6_P]] patients already on the laptop will automatically have their [[Service/Location]] changed to [[STB_E6_P_P]] | ||
** patients who are discharged while still on that ward don't require further changes | ** patients who are discharged while still on that ward don't require further changes | ||
** patients who are moved to one of the A7 locations should | ** patients who are moved to one of the A7 locations should | ||
*** have their [[Service/Location]] changed to [[STB_A7S]] resp [[STB_A7W]] | *** have their [[Service/Location]] changed to [[STB_A7S]] resp [[STB_A7W]] | ||
*** a [[Boarding Loc]] entry added for the first part of their stay on | *** a [[Boarding Loc]] entry added for the first part of their stay on STB_E6_P_P | ||
*** a move to "STB - Home medicine ward" should be added with the time they were moved | *** a move to "STB - Home medicine ward" should be added with the time they were moved | ||
''' All other collectors''' | ''' All other collectors''' | ||
* patients with [[ | * patients with [[STB_E6_P]] in their [[Previous Location]] or [[Dispo]] fields will automatically have those changed to [[STB_E6_P_P]] | ||
* if the patient was transferred there before the move date, you can leave that. If they were transferred there after the move date but before we put the new entries in place, you may need to change the dispo to [[STB_A7S]] resp [[STB_A7W]]. Don't worry too much about this, we can fix it at the back end, but if you notice it please fix. | * if the patient was transferred there before the move date, you can leave that. If they were transferred there after the move date but before we put the new entries in place, you may need to change the dispo to [[STB_A7S]] resp [[STB_A7W]]. Don't worry too much about this, we can fix it at the back end, but if you notice it please fix. | ||
| Line 46: | Line 46: | ||
{{DT | | {{DT | | ||
* set something up to help Pagasa with these specific [[Orphans in Centralized data.mdb]]. If I don't connect with her before she wants to do this, essentially this would be a query that filters to | * set something up to help Pagasa with these specific [[Orphans in Centralized data.mdb]]. If I don't connect with her before she wants to do this, essentially this would be a query that filters to STB_E6_P and STB_E6_P_B, and wherever there are two, delete the E6 entry. }} | ||
== Reporting == | == Reporting == | ||
| Line 56: | Line 56: | ||
{{DT | | {{DT | | ||
* deactivate | * deactivate STB_E6_P_P in [[s_tmp table]] once last pt has moved. }} | ||
== Cross checks == | == Cross checks == | ||