Cisco Cisco Customer Voice Portal 8.0(1)

Unified CVP Database Tables

This section lists the Unified CVP tables that hold reporting data.

Tables are categorized as follows:

•

•

•

•

•

Call Tables

These tables are:

•

•

•

Call Table

This table is the primary record of a call and contains the basic metrics for each call. It contains

one record per call.

Any drill into a specific call should start here to obtain the proper CallGUID.

On occasion, messages are dropped - even for an otherwise successful call. In such cases,

EndDateTime is set to the same value as StartDateTime. Thus, if a call appears to be of 0

duration, report writers will know to exclude such a call from consideration in cases where it

would otherwise skew metrics.

The global unique id of a call

PK (Composite

CallGUID,CallStartDate)

No

char(32) for new

installations

CallGUID

char(35) for upgrades

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