Change of GRA location names from "our" names to EPR/Cognos names: Difference between revisions
Ttenbergen (talk | contribs) m (→Status) |
Ttenbergen (talk | contribs) |
||
(One intermediate revision by the same user 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 | 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 == | ||
Nothing left to do for collectors as of 2021-05-06 | |||
== Tina's instructions == | == Tina's instructions == | ||
Line 38: | Line 32: | ||
== Status == | == Status == | ||
{{TT| | |||
* We have not changed [[s_Dispo table]] over to use the same values yet. There are at least two Cognos Units at GRA that don't map cleanly: | |||
** "GH-SWAP Location" - we can probably ignore that one, as per [[GH-SWAP Location]] we don't enter it so it doesn't really need a counterpart | |||
** "GH-Surgical Day Care" - this one can eithe rbe an ICU contingency bed or a GRA ambulatory care location; or maybe that's even changed, it was a thing during COVID. There is one line in Cognos for this in the 2020-05-06 batch, and it's for 2021-04-20 10:05:00; there was also a location "GH-IP-Surgical Day Care"... maybe that was the COVID one? [[User:Ttenbergen|Ttenbergen]] 16:30, 2021 May 6 (CDT) | |||
}} | |||
{{TT| | {{TT| | ||
* Almost complete for Med, notified collectors of stragglers | * Almost complete for Med, notified collectors of stragglers |
Revision as of 16:37, 2021 May 6
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
Tina's instructions
- inactivate the old options on
Change Date
+ 5
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.
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
|
|
|
|
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: |