Change of remaining location names from "our" names to EPR/Cognos names
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.
|
Preparation needed
The related data dropdowns live in three tables: s_Cognos_Units table, s_dispo, s_tmp table.
- Tina would need to map current s_dispo 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
- we will keep the old ones around for now - if we removed them there would likely be problems in CCMDB
- 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
|
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.
- target date
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
|
|
once that's done, we will need to review if the following are still needed:
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) |
|
Related articles
Related articles: |