Incident Tracking applications

============================================================

_{BI4-Incident-Tracking has been definitively decomissionned in 03.2021}

_{Ticket ID [#5250108] Decomm BI4 folder "526 - Incident Tracking Novecare"}

_{*** For Incident Tracking Clamecy, there is an active publication this year, but for others no WebI report using these universes has been refreshed by end users in 2016 ***}

Overview

There are four similar applications that deals with tracking of incidents and actions taken.

Incident Tracking Clamecy; Incident Tracking Halifax; Incident Tracking Ospiate and Novecare WW Incident Tracking

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-6 15:45:38.png

Database Diagrams

Incident Tracking Clamecy

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-6 16:8:30.png

Data Loading

ITC snapshots are created in SQLServer replicated database once a week (Friday) from eRoom database.

Anyway only the latest snapshot copy for each month is kept in the replicated sqlserver database.

Incident Tracking Hallifax

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-6 16:11:49.png

Data Loading

ITH snapshots are created in SQLServer replicated database twice a week (Monday and Wednesday) from eRoom database.

Anyway only the latest snapshot copy for each month is kept in the replicated sqlserver database.

Incident Tracking Ospiate

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-6 16:14:54.png

Data Loading

ITO snapshots are created in SQLServer replicated database twice a week (Tuesday and Friday) from eRoom database.

Anyway only the latest snapshot copy for each month is kept in the replicated sqlserver database.

Novecare WW Incident Tracking

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-6 15:59:54.png

Data Loading

NHQITC snapshots are created in SQLServer replicated database twice a week (Tuesday and Friday) from eRoom database.

Anyway only the latest snapshot copy for each month is kept in the replicated sqlserver database.

Universe Documentation

Incident Tracking Clamecy (ITC)

4 classes
43 objects
1 conditions
3 tables
1 alias
2 joins
0 contexts
0 hierarchies

Incident Tracking Hallifax (ITH)

4 classes
72 objects
1 conditions
3 tables
0 alias
2 joins
0 contexts
0 hierarchies

Incident Tracking Ospiate (ITO)

Novecare WW Incident Tracking (NHQITC)

4 classes
68 objects
1 conditions
3 tables
0 alias
2 joins
0 contexts
0 hierarchies

Main BI4 Core Reports

BI4 core folder: 526 - Incident Tracking Novecare

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-10 9:4:52.png

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-23 8:56:10.png

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-10 9:6:55.png

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-23 8:56:33.png

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-10 9:7:52.png

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-23 8:56:55.png

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-10 9:9:3.png

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-23 8:57:14.png

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-10 9:8:30.png

Useful links

Link to UpToDate documentation of universes (from 360 eyes)

Link to Knowledge Transfer documents for Incident Tracking applications

*** This application is in the list of eRoom databases to be migrated to SQLServer 2008 *** see details ...