Incident Tracking applications

_{*** For Incident Tracking Clamecy, there is a publication is active in 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

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

Incident Tracking Hallifax

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

Incident Tracking Ospiate

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

Novecare WW Incident Tracking

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

Universe Documentation

(ToDo)

Main BI4 Core Reports

BI4 core folder: 526 - Incident Tracking Novecare

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

Incident Tracking Clamecy (ITC)

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.

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

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

Incident Tracking Hallifax (ITH)

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.

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

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

Incident Tracking Ospiate (ITO)

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.

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

Novecare WW Incident Tracking (NHQITC)

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

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.

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

TECHNO - BI TEAM > zzz Incident Tracking > image2016-6-10 9:9:3.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 ...