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

From CCMDB Wiki
Jump to navigation Jump to search
 
(36 intermediate revisions by 2 users not shown)
Line 1: Line 1:
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]].  
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.  
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 ==
== Collector instructions ==
* we have made available the new unit entries as per wording in [[Cognos EPR Report]] as options for the [[Boarding Loc]] dropdown
Nothing left to do for collectors as of 2021-05-06
** 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


=== Transition plan ===
== Name changes on wiki ==
* The [[Boarding Loc]] entries for all records currently on the GRA Med laptops will be manually changed by GRA Med collectors on <code>Change Date</code>.  
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.


== Tina's instructions ==
== Data Processor's instructions ==
* inactivate the old options on <code>Change Date</code> + 5
* 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


Confirmed no more in pre-inpt, previous, dispo.


However as of 2021-05-05 there is one entry left in [[Service/Location]]. It's a [[Lost/missing chart]], waiting for resolution what we should do about those.  
Query to see remaining:
  D_ID location_name RecordStatus program
SELECT L_TmpV2.D_ID, L_TmpV2.Item, L_TmpV2.D_Tmp_ID, L_TmpV2.obsdate, L_TmpV2.date_var
  G8_GRA_N3-19794 GRA_N3 Incomplete Med Missing Chart as per comment
  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"));


{{Collapsable
Query starting point to update:
| always= SQL
  UPDATE L_TmpV2 SET L_TmpV2.Item = "GH-Emergency"
| full=  
WHERE (((L_TmpV2.Project)="Boarding Loc") AND ((L_TmpV2.Item)="GRA_ER"));
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


== Dates ==
== Dates ==
=== [[Boarding Loc]] Changes ===
<code>Change Date</code> '''= 2020-12-16''':  
<code>Change Date</code> '''= 2020-12-16''':  
* Date new boarding loc entries will be available: <code>Change Date</code>
* Date new boarding loc entries will be available: <code>Change Date</code>
* Date by which all boarding loc entries should be changed on collector laptops: <code>Change Date</code> + 5
* Date by which all boarding loc entries should be changed on collector laptops: <code>Change Date</code> + 5
* Date by which Pagasa will change all vetted data: <code>Change Date</code> or later
* Date by which Pagasa will change all vetted data: <code>Change Date</code> 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 ==
== Status ==
{{TT|
The change is complete for GRA, see [[Change of remaining location names from "our" names to EPR/Cognos names]] for other sites. [[User:Ttenbergen|Ttenbergen]] 11:15, 2022 January 19 (CST)
* 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
| who = Tina 
| question = 
* decided at Task that we should to this for the other sites as well, need to execute.
 
once that's done, we will need to review if the following are still needed:
* [[Identifying_patients_in_boarding_locations]]
* [[HSC_Boarding_Locations ]]
* [[STB_Boarding_Locations]]
* [[GRA_Boarding_Locations]]
 
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)
| todo_added = 2021-04 
| todo_action = 
}}


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

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: