Cognos EPR Report - Revision history

Ttenbergen at 19:28, 18 August 2025

2025-08-18T19:28:11Z

← Older revision		Revision as of 14:28, 18 August 2025
Line 2:		Line 2:

	== Delays and timing ==		== Delays and timing ==
	{{Collapsable \| always=The data usually arrives around 9:45 \| full=		{{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:		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":		* The report itself (sender "CognosUser@REG1MSAP0160.ad.wrha.mb.ca" and Subject "Report: CCMdb Sample New Version":

Ttenbergen at 16:42, 4 July 2025

2025-07-04T16:42:22Z

← Older revision		Revision as of 11:42, 4 July 2025
Line 1:		Line 1:
	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.		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 \| 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 ==

Ttenbergen: /* What data is included */

2025-04-25T16:23:15Z

What data is included

← Older revision		Revision as of 11:23, 25 April 2025
Line 3:		Line 3:
	== Details ==		== Details ==
	=== What data is included ===		=== What data is included ===
	The report includes unit and service info for patients who are admitted to the services we follow. See [[Cognos Report Time Limits]] for the timeframe of the data.		* 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 <!-- as per Chastity 2025-04-25 -->
			* See [[Cognos Report Time Limits]] for the timeframe of the data.

	=== Process to make it available to collectors ===		=== Process to make it available to collectors ===

Ttenbergen: /* Log */

2025-04-25T16:22:05Z

Log

← Older revision		Revision as of 11:22, 25 April 2025
Line 9:		Line 9:

	== Log ==		== 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-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-11 [[2025-03 COGNOS crash]] (as per 2025-02-13 email from LK)

Ttenbergen: /* Log */

2025-04-10T18:04:49Z

Log

← Older revision		Revision as of 13:04, 10 April 2025
Line 9:		Line 9:

	== Log ==		== Log ==
			* 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-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		* 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

Ttenbergen: /* Log */

2025-03-15T03:30:50Z

Log

← Older revision		Revision as of 22:30, 14 March 2025
Line 9:		Line 9:

	== Log ==		== Log ==
			* 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-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-25 as of about 2 weeks ago, gender is no longer included in the data because it was breaking the export.

Ttenbergen: removed outdated link

2021-12-15T18:04:02Z

removed outdated link

← Older revision		Revision as of 13:04, 15 December 2021
Line 3:		Line 3:
	== Details ==		== Details ==
	=== What data is included ===		=== What data is included ===
	The report includes unit and service info for patients who are ~~present in~~ the services ~~(see [[What is a service admission]])~~ we follow. See [[Cognos Report Time Limits]] for the timeframe of the data.		The report includes unit and service info for patients who are admitted to the services we follow. See [[Cognos Report Time Limits]] for the timeframe of the data.

	=== Process to make it available to collectors ===		=== Process to make it available to collectors ===

Ttenbergen: /* Log */

2021-02-12T17:31:27Z

Log

← Older revision		Revision as of 12:31, 12 February 2021
Line 10:		Line 10:
	== Log ==		== Log ==
	* 2020-09-23 gender field was restored at some point		* 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. ~~I have reminded Chastity repeatedly to put it back in but there is no ETA for this~~		* 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		* 2020-06-01 emailed to also include SBGH-A7SO and SBGH-A7WE

Ttenbergen at 17:22, 12 February 2021

2021-02-12T17:22:38Z

← Older revision		Revision as of 12:22, 12 February 2021
Line 1:		Line 1:
	The {{PAGENAME}} is a report generated for us by ~~the~~ Decision Support ~~Team (Contact: Chastity Cleofas, escalations to Brenda Comte)~~. 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.		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.

	== Details ==		== Details ==

Ttenbergen at 03:25, 26 November 2020

2020-11-26T03:25:41Z

← Older revision		Revision as of 22:25, 25 November 2020
Line 1:		Line 1:
	The {{PAGENAME}} is a report generated for us by the Decision Support Team (Contact: Chastity Cleofas, escalations to Brenda Comte). It is used by the [[Cognos Report Integrator]] to facilitate data entry. The data in this report feeds the [[Patient Viewer Tab Cognos ADT2]], [[~~Cognos~~ Service Starter]]/[[Cognos2 Unit Starter]] and [[Cognos2 Ender]]. See [[Using Cognos2 to keep track of patients]] for how they are used together.		The {{PAGENAME}} is a report generated for us by the Decision Support Team (Contact: Chastity Cleofas, escalations to Brenda Comte). 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.

	== Details ==		== Details ==