Cognos EPR Report: Difference between revisions

TOstryzniuk (talk | contribs)
No edit summary
mNo edit summary
Line 1: Line 1:
The {{PAGENAME}} is a report generated for us by the Decision Support Team (Contact: Chastity Cleofas). It is used by the [[Cognos Report Integrator]] to facilitate data entry.
The {{PAGENAME}} is a report generated for us by the Decision Support Team (Contact: Chastity Cleofas). It is used by the [[Cognos Report Integrator]] to facilitate data entry. The data in this report feeds the [[Patient viewer tab Cognos ADT]], [[Cognos Admitter]] and [[Cognos Discharger]].
*what the collectors will be using is pretty much the same as the [[EPR Reports Integrator]].
 
== Details ==
== Details ==
For the time being we are going to receive a daily scheduled export from COGNOS that will contain the combination of data in [[EPR Reports]] for the last two weeks. IT will be stored at
Tina receives the data in a scheduled, automated email from Chastity every morning at 7:46. The data is then imported into [[CCMDB.accdb]] and provided to collectors via regular roll-out and news and backup.  
* R:\SHARED DATA Agreement Project\Cognos EPR Reports (visible only to main office)
 
{{TT |_DEV_CCMDB -
* Need to make this so the code can be run from button-press, or better yet, from script that includes roll-out and start of email. }}


{{TT |_DEV_CCMDB - Tina will update the code and process for [[Cognos Report Integrator]] to use this new data source, including a way to get it into collector laptops from this file share collectors don't have access to. }}
{{TT |_DEV_CCMDB -  
* Need to import the extra EMIPs in the second tab. }}


== Log ==
== Log ==
* 2020-06-01 emailed to also include SBGH-A7SO and SBGH-A7SO
* 2020-05-27 emailed to also include [[STB_ACCU]] which they call SBGH CCUO
* 2020-04-03 Chastity has provided a larger file that would work for Tina to start building [[Cognos Report Integrator]]
* 2020-04-03 Chastity has provided a larger file that would work for Tina to start building [[Cognos Report Integrator]]
* 2020-03-19 testing a file with Chastity Cleofas
* 2020-03-19 testing a file with Chastity Cleofas