Cognos EPR Report: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Ppiche (talk | contribs)
CCMDB_legit
1,641 edits
No edit summary
 
(17 intermediate revisions by the same user not shown)
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 data in this report feeds the [[Patient viewer tab Cognos ADT]], [[Cognos Admitter]] and [[Cognos Discharger]].
The {{PAGENAME}} is a report generated for us by [[Decision Support Services]]. It is used by the [[Cognos Report Integrator]] to facilitate data entry. The data in this report feeds the [[Patient Viewer Tab Cognos ADT2]], [[Cognos2 Service Starter]]/[[Cognos2 Unit Starter]] and [[Cognos2 Ender]]. See [[Using Cognos2 to keep track of patients]] for how they are used together.
 
== Delays and timing ==
{{Collapsable | always=The data usually arrives around 9:45. If the data doesn't arrive, follow the [[Cognos downtime procedure]] | full=
As of 2025-07-04 the extract is routinely delayed. Based on the last 50 days:
* The report itself (sender "CognosUser@REG1MSAP0160.ad.wrha.mb.ca" and Subject "Report: CCMdb Sample New Version":
** Count: 50
** Min time: 08:53:50
** Max time: 11:52:50
** Median time: 09:41:22
** Average time: 09:52:36
 
* The automated error email about the delay (sender "PIMA.Operations@gov.mb.ca" and subject "NEW: Delay in EPR data load%")":
** Count: 19
** Min time: 09:35:32
** Max time: 13:04:48
** Median time: 10:38:51
** Average time: 10:42:27
}}


== Details ==
== Details ==
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.  
=== What data is included ===
 
* The report includes unit and service info for patients who are admitted to the services we follow.  
{{TT |_DEV_CCMDB -
** if new or unexpected units were to appear, they will be included automatically, we do not need to act on this <!-- as per Chastity 2025-04-25 -->
* 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. }}
* See [[Cognos Report Time Limits]] for the timeframe of the data.


{{TT |_DEV_CCMDB -
=== Process to make it available to collectors ===
* Need to import the extra EMIPs in the second tab. }}
see [[Cognos data import]]


== Log ==
== Log ==
* 2020-06-01 emailed to also include SBGH-A7SO and SBGH-A7WE
* 2025-04-25 - confirmed with Chastity that a specific new location would show up and learned that any new location showing up under a service should be included in our report automatically
* 2020-05-27 emailed to also include [[STB_ACCU]] which they call SBGH CCUO
* 2025-04-01-9 dump didn't include services for new fiscal year; [[Chastity]] updated it to remove filter that caused this and this should no longer impact future fiscal year changes
* 2020-04-03 Chastity has provided a larger file that would work for Tina to start building [[Cognos Report Integrator]]
* 2025-03-11 [[2025-03 COGNOS crash]] (as per 2025-02-13 email from LK)
* 2020-03-19 testing a file with Chastity Cleofas
* 2025-03-03 emailed LK with a tally of the increasing number of delays with the Cognos extracts; this would only have included the ones that resulted in an email from SH, there likely were additional delays in the actual email reports received
* 2020-09-23 gender field was restored at some point
* 2020-06-25 as of about 2 weeks ago, gender is no longer included in the data because it was breaking the export.
* 2020-06-01 emailed to also include SBGH-A7SO and SBGH-A7WE


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

Latest revision as of 14:28, 18 August 2025

The Cognos EPR Report is a report generated for us by Decision Support Services. It is used by the Cognos Report Integrator to facilitate data entry. The data in this report feeds the Patient Viewer Tab Cognos ADT2, Cognos2 Service Starter/Cognos2 Unit Starter and Cognos2 Ender. See Using Cognos2 to keep track of patients for how they are used together.

Delays and timing

The data usually arrives around 9:45. If the data doesn't arrive, follow the Cognos downtime procedure   

As of 2025-07-04 the extract is routinely delayed. Based on the last 50 days:

  • The report itself (sender "CognosUser@REG1MSAP0160.ad.wrha.mb.ca" and Subject "Report: CCMdb Sample New Version":
    • Count: 50
    • Min time: 08:53:50
    • Max time: 11:52:50
    • Median time: 09:41:22
    • Average time: 09:52:36
  • The automated error email about the delay (sender "PIMA.Operations@gov.mb.ca" and subject "NEW: Delay in EPR data load%")":
    • Count: 19
    • Min time: 09:35:32
    • Max time: 13:04:48
    • Median time: 10:38:51
    • Average time: 10:42:27

Details

What data is included

  • The report includes unit and service info for patients who are admitted to the services we follow.
    • if new or unexpected units were to appear, they will be included automatically, we do not need to act on this
  • See Cognos Report Time Limits for the timeframe of the data.

Process to make it available to collectors

see Cognos data import

Log

  • 2025-04-25 - confirmed with Chastity that a specific new location would show up and learned that any new location showing up under a service should be included in our report automatically
  • 2025-04-01-9 dump didn't include services for new fiscal year; Chastity updated it to remove filter that caused this and this should no longer impact future fiscal year changes
  • 2025-03-11 2025-03 COGNOS crash (as per 2025-02-13 email from LK)
  • 2025-03-03 emailed LK with a tally of the increasing number of delays with the Cognos extracts; this would only have included the ones that resulted in an email from SH, there likely were additional delays in the actual email reports received
  • 2020-09-23 gender field was restored at some point
  • 2020-06-25 as of about 2 weeks ago, gender is no longer included in the data because it was breaking the export.
  • 2020-06-01 emailed to also include SBGH-A7SO and SBGH-A7WE

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Cognos_EPR_Report&oldid=167390"