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

From CCMDB Wiki
Jump to navigation Jump to search
Tag: Manual revert
 
(One intermediate revision by the same user not shown)
Line 11: Line 11:
* 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
* 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
** The ITEM values were changed from '''GRA-<ward>'''  to '''GH-<ward>''' .   
** The ITEM values were changed from '''GRA-<ward>'''  to '''GH-<ward>''' .   
** The items having '''GRA_*'''  or  '''GRA - *''' were not changed to '''GH''' as shown by the data. --[[User:JMojica|JMojica]] 11:48, 2022 March 8 (CST)
** The items having '''GRA_*'''  or  '''GRA - *''' were all changed to '''GH''' except for the 85 "GRA - boarding" on March 12, 2024
** There are still inconsistencies found in the ITEM values, example '''GH-3South''' vs '''GH_S3''', '''GH_MICU''' vs '''GH-Intensive Care''', etc.


{{DJ|
* Do we need to change old ITEM values for consistencies? --[[User:JMojica|JMojica]] 12:11, 2022 March 8 (CST)
** It might be nice to have, and you would know better how important this is. If we want to do it, we would need to ask Pagasa to run the update queries for each item. See query below.
*** Was updated for all except GRA Boarding... Tina needs to fix wiki page. [[User:Ttenbergen|Ttenbergen]] 16:11, 2022 March 23 (CDT)
**** This still had a comment for me to clean up so I a look at L_TmpV2 and there are still 32 "GRA" items other than "GRA - boarding". If we want this consistent we might want to ask Pagasa to change them. See query below to view them. [[User:Ttenbergen|Ttenbergen]] 09:31, 2023 July 6 (CDT)


}}
Query to see remaining:  
Query to see remaining:  
  SELECT L_TmpV2.D_ID, L_TmpV2.Item, L_TmpV2.D_Tmp_ID, L_TmpV2.obsdate, L_TmpV2.date_var
  SELECT L_TmpV2.D_ID, L_TmpV2.Item, L_TmpV2.D_Tmp_ID, L_TmpV2.obsdate, L_TmpV2.date_var

Latest revision as of 10:43, 2024 March 18

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, see Change of remaining location names from "our" names to EPR/Cognos names.

Collector instructions

Nothing left to do for collectors as of 2021-05-06

Name changes on wiki

We changed the page names and left redirects form the old page to not break links. It was done this way because these pages are quite interlinked, and a lot of other pages include the letters GRA, so an automated change would have been problematic.

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
    • The ITEM values were changed from GRA-<ward> to GH-<ward> .
    • The items having GRA_* or GRA - * were all changed to GH except for the 85 "GRA - boarding" on March 12, 2024


Query to see remaining: 

SELECT L_TmpV2.D_ID, L_TmpV2.Item, L_TmpV2.D_Tmp_ID, L_TmpV2.obsdate, L_TmpV2.date_var
FROM L_TmpV2
WHERE (((L_TmpV2.Item) Like "GRA*" And (L_TmpV2.Item) Not Like "Grand*" And (L_TmpV2.Item)<>"GRA - boarding") AND ((L_TmpV2.Project)<>"Moves"));

Query starting point to update: 

UPDATE L_TmpV2 SET L_TmpV2.Item = "GH-Emergency"
WHERE (((L_TmpV2.Project)="Boarding Loc") AND ((L_TmpV2.Item)="GRA_ER"));

Dates

Boarding Loc Changes

Change Date = 2020-12-16:

  • 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 + 5
  • Date by which Pagasa will change all vetted data: Change Date or later

S dispo table changes

The locations names having GRA in the s_dispo table were replaced by GH in version CCMDB.accdb_Change_Log_2021#2021-10-20.

Status

The change is complete for GRA, see Change of remaining location names from "our" names to EPR/Cognos names for other sites. Ttenbergen 11:15, 2022 January 19 (CST)

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Change_of_GRA_location_names_from_%22our%22_names_to_EPR/Cognos_names&oldid=161035"