Change of GRA location names from "our" names to EPR/Cognos names

From CCMDB Wiki
Jump to navigation Jump to search

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

  • we have made 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

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.

Tina's instructions

  • inactivate the old options on Change Date + 5
    • emailed Trish to find out what steps to take next Ttenbergen 11:52, 2021 January 19 (CST)
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

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

However as of 2021-05-05:

D_ID	location_name	RecordStatus	program
G8_GRA_N3-19794	GRA_N3	Incomplete	Med	Missing Chart as per comment
SQL   

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

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

Status

  • 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.
  • added: no added date
  • action: no action date
  • Cargo


  • Categories


  • 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:

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)

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Related articles

Related articles: