2020-03 HSC COVID unit transition: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(One intermediate revision by the same user not shown)
Line 9: Line 9:
{{Discuss |  
{{Discuss |  
* As of 2020-03-19 we will try to collect patients data on this ward while preventing exposure. Probably enter patients from EPR and then collect details retrospectively. More to come. }}
* As of 2020-03-19 we will try to collect patients data on this ward while preventing exposure. Probably enter patients from EPR and then collect details retrospectively. More to come. }}
== 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]]
{{DT | Once the last of these is sent we can name them back to their longer, more expressive versions. }}


== How will we identify these patients in EPR ==
== How will we identify these patients in EPR ==
Line 24: Line 31:
** original remains with renamed location [[HSC_D5_Pre_COVID]], '''negative'' of [[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]], 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]]
{{DT |
** 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 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 }}


==== H4 (old D4) ====
==== H4 (old D4) ====

Revision as of 15:00, 2020 March 22

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

Background

HSC_D4_COVID

  • As of 2020-03-19 we will try to collect patients data on this ward while preventing exposure. Probably enter patients from EPR and then collect details retrospectively. More to come.
  • SMW


  • Cargo


  • Categories

Temporary naming

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

  • SMW


  • Cargo


  • Categories

How will we identify these patients in EPR

EPR reports should work for the new locations as usual.

Transition plan

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.

H5 (old D5)

H4 (old D4)

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


  • Cargo


  • Categories

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.

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.

Cross checks

  • SMW


  • Cargo


  • Categories
  • 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: