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

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
(One intermediate revision by the same user not shown)
Line 50: Line 50:


== Status ==
== Status ==
{{TT|
*2021-04-29 - Julie email confirmed that she doesn't need the specific info listed on these pages since we now get the details in [[Boarding Loc]]. [[User:Ttenbergen|Ttenbergen]] 15:43, 2021 April 29 (CDT)
* Almost complete for Med, notified collectors of stragglers
* 2020-12-30 asked Julie and Trish if CC should be next since they are now inconsistent with Med.  
}}


{{Todo
* ?? [[Change of GRA location names from "our" names to EPR/Cognos names|completed at GRA]]
| who = Tina 
| question = 
* decided at Task that we should to this for the other sites as well, need to execute.


Julie email confirmed that she doesn't need the specific info listed on these pages since we now get the details in [[Boarding Loc]]. [[User:Ttenbergen|Ttenbergen]] 15:43, 2021 April 29 (CDT)
{{DJ |
* As per email from 2021-05-04, "The question is whether to use the generic HIGH OBS and IMCU instead of physical locations H7S or L2ME if we would like to  enter the physical locations COGNOS is showing.  If the decision is physical Locations – how would I know which are the high obs  wards? we would have to put it in the comments, so are we any further ahead?" How does that feature into our plan to move all to Cognos values? On the same note, it appears that GRA is using two designations for PACU dependign on post-OR vs Covid use...
| todo_added = 2021-04 
** I say we use the actual location. Whether or not that location is currently HOBS or otherwise might change. Boarding Loc is a location, not a location type. This would make working [[Level of care hierarchy]] harder; we would likely need to add a new table that includes when units were what level, ie location, level startdttm. Are there other things it would make harder?
| todo_action = 
}}
}}


== Related articles ==  
== Related articles ==  

Revision as of 17:32, 2022 January 19

We 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. We have done a Change of GRA location names from "our" names to EPR/Cognos names, this page is about doing the same change at our other sites.

Decision to go ahead

We decided to go ahead with this change at Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2021#ICU Database Task Group Meeting – April 15, 2021 (#3), confirmed at the next Task meeting and again the one after.

However, there were emails and/or wiki discussions after this that raised concerns.

  • It's a blur to me now, but I seem to remember people still raising concerns about this change after the meeting. If you have ongoing concerns, please post them here. Ttenbergen 16:36, 2021 May 6 (CDT)
  • SMW


  • Cargo


  • Categories

Preparation needed

The related data dropdowns live in three tables: s_Cognos_Units table, S dispo table]], s_tmp table.

  • Tina would need to map current s_dispo table locations with Boarding Loc options so they compare properly. Some of this was previously started in s_Cognos_Units table.Dispo, but this has blanks and has not been validated.
  • Tina would need to determine what needs to be added to the Boarding Loc dropdown.
here is the query   

Collector instructions

Work in progress, don't go ahead with these yet!

  • we would make available the new unit entries as per wording in Cognos EPR Report as options for the Boarding Loc dropdown
    • we will 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
  • 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
  • that will likely be more complicated at the other sites since these are not necessarily one-to-one mappigns...
  • SMW


  • Cargo


  • Categories

Transition plan

  • The Boarding Loc entries for all records currently on the laptops will be manually changed by the respective collectors collectors starting on #Change Date and before #Change Date + 7 days.

Tina's instructions

  • inactivate the old options
    • target date #Change Date
    • confirm no remaining old entries in pre-inpt, previous, service/loc, dispo.
SQL - but this is the wrong one...   

SELECT L_Log.D_ID, s_dispo.location_name, L_Log.RecordStatus, s_dispo.program FROM L_Log INNER JOIN s_dispo ON L_Log.Service_Location = s_dispo.dispo_ID WHERE (((s_dispo.location_name)<>"GRA_Med" And (s_dispo.location_name)<>"GRA_CC") AND ((L_Log.RecordStatus)<>"vetted") AND ((s_dispo.Site)="GRA"));

Data Processor's instructions

  • For Vetted cases, Pagasa has to change the affected ITEM values; this should be done by query, ask Tina for help with the queries if needed

Change Date

Change Date = 2020-12-16:

Status

  • 2021-04-29 - Julie email confirmed that she doesn't need the specific info listed on these pages since we now get the details in Boarding Loc. Ttenbergen 15:43, 2021 April 29 (CDT)


  • As per email from 2021-05-04, "The question is whether to use the generic HIGH OBS and IMCU instead of physical locations H7S or L2ME if we would like to enter the physical locations COGNOS is showing. If the decision is physical Locations – how would I know which are the high obs wards? we would have to put it in the comments, so are we any further ahead?" How does that feature into our plan to move all to Cognos values? On the same note, it appears that GRA is using two designations for PACU dependign on post-OR vs Covid use...
    • I say we use the actual location. Whether or not that location is currently HOBS or otherwise might change. Boarding Loc is a location, not a location type. This would make working Level of care hierarchy harder; we would likely need to add a new table that includes when units were what level, ie location, level startdttm. Are there other things it would make harder?
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: