Cisco Cisco Customer Voice Portal 8.0(1)

The Unified CVP Reporting Data Model

Topics:

•

•

•

•

DateTime Columns

Most major tables have three columns to assist in managing the reporting server itself. These

are:

•

 - This column is used for partitioning and purging data.

This is date the call started and is meant to ensure that detail data, which may cross a date

boundary, are tied to the original call and can all be stored and removed together.

•

 - This is the date and time that the recorded event transpired. This is recorded

in UTC time.

 table has two EventDateTime fields, recorded as StartDateTime and

•

 - This is the date and time that the recorded event was written to the database.

It is meant to contrast with the eventdatetime. A marked difference between these values

indicates a delay in the data arriving at the reporting server. This delay should either be

allowed for or investigated.

Informix Dates and Times

The Informix engine that hosts the CVP Reporting Database supports three concepts of time.

Dates

A date (for example CallStartDate) has no time element to it. It is specified between single

quotes as 'MM/DD/YYYY'.

SELECT count(*)

  FROM Call

 WHERE CallStartDate= '05/31/2009';

Reporting Guide for Cisco Unified Customer Voice Portal Release 8.0(1)