Change of GRA location names from "our" names to EPR/Cognos names: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 15: Line 15:
*** GH-Emergency vs GRA - ER  
*** GH-Emergency vs GRA - ER  
*** GH-Recovery Room - vs GRA - recovery
*** GH-Recovery Room - vs GRA - recovery
{{Discuss | Should we change med, or med and CC, to the official terms at the same time? If so, should we change the remaining CC entries at the same time as well to finish off GRA? This would be the following, although I am not sure we use all for [[Boarding Loc]]:  
{{Discuss |  
*GH-Endoscopy
*Should we change med, or med and CC, to the official terms at the same time? If so, should we change the remaining CC entries at the same time as well to finish off GRA? This would be the following, although I am not sure we use all for [[Boarding Loc]]:  
*GH-External ICU
::*GH-Endoscopy
*GH-Intensive Care
::*GH-External ICU
*GH-IP-Surgical Day Care
::*GH-Intensive Care
*GH-Recovery Room
::*GH-IP-Surgical Day Care
*GH-Surgical Day Care
::*GH-Recovery Room
 
::*GH-Surgical Day Care
** I can speak to the medicine entries - we had "moving day" last week where all patients were moved off a ward to have it terminally cleaned. In order to do this, medicine patients were moved to Surgical Day Care (SDC) and CAU. Fun time, I know. To my knowledge they've all been moved back to their home ward with the exception of a couple medicine patients still remaining on CAU. We entered the move to these temporary locations in the TMP as GH-Boarding and made notes in the Q (comment) column about the actual location. Unless things start getting really crazy with COVID, medicine should not be using these areas unless circumstances require it. [[User:Surbanski|Surbanski]] 14:31, 2020 December 10 (CST)
** I can speak to the medicine entries - we had "moving day" last week where all patients were moved off a ward to have it terminally cleaned. In order to do this, medicine patients were moved to Surgical Day Care (SDC) and CAU. Fun time, I know. To my knowledge they've all been moved back to their home ward with the exception of a couple medicine patients still remaining on CAU. We entered the move to these temporary locations in the TMP as GH-Boarding and made notes in the Q (comment) column about the actual location. Unless things start getting really crazy with COVID, medicine should not be using these areas unless circumstances require it. [[User:Surbanski|Surbanski]] 14:31, 2020 December 10 (CST)
}}
}}


=== Swap locations ===
* Cognos also lists a [[Swap_Locations#.22Swap_locations.22_at_GRA | swap location]] for GRA: GH-SWAP Location
* Cognos also lists a [[Swap_Locations#.22Swap_locations.22_at_GRA | swap location]] for GRA: GH-SWAP Location
{{Discuss |
{{Discuss |

Revision as of 15:29, 2020 December 15

We currently use different names for locations in s_dispo table (Previous Location, Pre-admit Inpatient Institution, Dispo) than in Cognos EPR Report, and sometimes different again in Boarding Loc. This page is about our plan to move to the EPR based names at the GRA. Other sites may follow after.

Collector instructions

  • Nothing to change in Previous Location, Pre-admit Inpatient Institution, Dispo - we will change the "names" you see in the fields that use s_dispo table - you won't need to change these, they will just reflect the change in the reference table
  • we will make available the new entries for Boarding Loc and but keep the old ones around for now - if we removed them there would likely be problems in CCMDB
    • we will leave both old and new active until all are changed

Transition plan

  • The Boarding Loc entries for all records currently on the GRA Med laptops will be manually changed by GRA Med collectors on Change Date.

additional units

  • The exact wording is also not the same in Cognos for some of the locations used by both CC and Med:
    • Cognos vs current Boarding loc:
      • GH-Emergency vs GRA - ER
      • GH-Recovery Room - vs GRA - recovery
  • Should we change med, or med and CC, to the official terms at the same time? If so, should we change the remaining CC entries at the same time as well to finish off GRA? This would be the following, although I am not sure we use all for Boarding Loc:
  • GH-Endoscopy
  • GH-External ICU
  • GH-Intensive Care
  • GH-IP-Surgical Day Care
  • GH-Recovery Room
  • GH-Surgical Day Care
    • I can speak to the medicine entries - we had "moving day" last week where all patients were moved off a ward to have it terminally cleaned. In order to do this, medicine patients were moved to Surgical Day Care (SDC) and CAU. Fun time, I know. To my knowledge they've all been moved back to their home ward with the exception of a couple medicine patients still remaining on CAU. We entered the move to these temporary locations in the TMP as GH-Boarding and made notes in the Q (comment) column about the actual location. Unless things start getting really crazy with COVID, medicine should not be using these areas unless circumstances require it. Surbanski 14:31, 2020 December 10 (CST)
  • SMW


  • Cargo


  • Categories

Swap locations

  • I am not sure how we currently enter when Cognos/EPR has a Swap loc entry: Do we enter it as part of the previous location? Or the next? Should we start to just enter it as a swap and include those in the analysis? Ttenbergen 11:05, 2020 December 10 (CST)
    • Swap locations are used I believe in EPR only - patients aren't physically moved to a magical waiting area. We don't enter Swap locations, but will enter the move in the TMP if the unit has changed. If someone remains in the same unit but moved rooms, nothing is entered. Surbanski 14:25, 2020 December 10 (CST)
  • SMW


  • Cargo


  • Categories

Tina's instructions

  • update s_Cognos_Units table to reflect the new mappings (timed to be changed on the morning of Change Date
  • inactivate the old options on Change Date + DEPENDS ON PLAN

Data Processor's instructions

  • For Vetted cases, Pagasa has to change the affected ITEM values; ask Tina for help with the queries if needed

Dates

Change Date:

  • Date new boarding loc entries will be available: Change Date
  • Date by which all boarding loc entries should be changed on collector laptops: Change Date + DEPENDS ON PLAN
  • Date by which Pagasa will change all vetted data: Change Date or later

Related articles

Related articles: