2020-03 STB COVID unit transition: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "2020-03 COVID unit transition" to "2020-03 HSC COVID unit transition")
No edit summary
Line 1: Line 1:
This page is about the transition of collection units at STB to accommodate the new COVID unit.  
This page is about the transition of collection units at STB to accommodate the new COVID unit.  
{{Discuss | please review and shoot holes into before we implement. }}


== Background ==
== Background ==
{{DT  |
STB is opening a number of beds on STB_A7S and STB_A7W. Patients from our usual [[STB_E6]] unit will move there, and the physical E6 location will become the COVID ward.
* Rough notes from phone call:
STB_E6_C – new Dispo
 
Tmp
STB_A7S
STB_A7W
}}
 


== Transition plan ==
== Transition plan ==
* In [[s_Dispo table]]:
** We will create new entries for :
*** [[STB_E6_C]]
*** [[STB_A7S]]
*** [[STB_A7W]]
** We will change [[STB_E6]] to [[STB_E6_P]]
* In [[s_Tmp table]]:
** we will add a "STB_E6_P" entry that will stay active only during this transition.


=== collector instructions ===
'''E6 / A7 Collector'''
* [[STB_E6]] patients already on the laptop will automatically have their [[Service/Location]] changed to [[STB_E6_P]]
** 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
*** have their [[Service/Location]] changed to [[STB_A7S]] resp [[STB_A7W]]
*** a [[Boarding Loc]] entry added for the first part of their stay on STB_E6_P
*** a move to "STB - Home medicine ward" should be added with the time they were moved


=== collector instructions ===
''' All other collectors'''
* patients with [[STB_E6]] in their [[Previous Location]] or [[Dispo]] fields will automatically have those changed to [[STB_E6_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.


=== data processor instructions ===
=== data processor instructions ===
{{Discuss | How will Pagasa fix [[Previous Location]] / [[Dispo]] for related records? Same question for the other two hospitals... }}
{{DT | set something up to help Pagasa with these specific orphans. }}
== Reporting ==




== Reporting ==
== Cleanup ==
{{DT |
* We needed to use P for Pre_COVID and C for COVID since full names would have broken D_ID in sending. Once the last pt of a location is sent, we can change those names in the s_dispo table. }}


{{DT |
* deactivate STB_E6_P in [[s_Tmp table]] once last pt has moved. }}


== Cross checks ==
== 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 |
{{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?   
* 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?   

Revision as of 16:14, 2020 March 26

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

please review and shoot holes into before we implement. 
  • SMW


  • Cargo


  • Categories

Background

STB is opening a number of beds on STB_A7S and STB_A7W. Patients from our usual STB_E6 unit will move there, and the physical E6 location will become the COVID ward.

Transition plan

collector instructions

E6 / A7 Collector

  • STB_E6 patients already on the laptop will automatically have their Service/Location changed to STB_E6_P
    • 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
      • have their Service/Location changed to STB_A7S resp STB_A7W
      • a Boarding Loc entry added for the first part of their stay on STB_E6_P
      • a move to "STB - Home medicine ward" should be added with the time they were moved

All other collectors

  • patients with STB_E6 in their Previous Location or Dispo fields will automatically have those changed to STB_E6_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.

data processor instructions

How will Pagasa fix Previous Location / Dispo for related records? Same question for the other two hospitals... 
  • SMW


  • Cargo


  • Categories

set something up to help Pagasa with these specific orphans.

  • SMW


  • Cargo


  • Categories

Reporting

Cleanup

  • We needed to use P for Pre_COVID and C for COVID since full names would have broken D_ID in sending. Once the last pt of a location is sent, we can change those names in the s_dispo table.
  • SMW


  • Cargo


  • Categories


  • deactivate STB_E6_P in s_Tmp table once last pt has moved.
  • SMW


  • Cargo


  • Categories

Cross checks

  • 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?
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: