Incident Tracking applications

Overview

There are four similar applications that deals with tracking of incidents 

Incident Tracking Clamecy

Incident Tracking Halifax

Incident Tracking Ospiate

Novecare WW Incident Tracking

Database Diagram

(ToDo)

Universe Documentation

(ToDo)

Main BI4 Core Reports

(ToDo)

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.

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.

Novecare WW Incident Tracking (NHQITC)

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.

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