Incident Tracking applications

_{*** 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

Database Diagrams

Incident Tracking Clamecy

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

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

Novecare WW Incident Tracking

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

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 ...