Cisco Cisco Customer Voice Portal 8.0(1)

This means that in a single 24-hour periods, the system can process can at most summarize 96

days' worth of data.

•

_Daily tables will be populated one day behind the _15 minute tables.

•

_Weekly tables will be populated from _Daily tables once those have been fully populated

for the week in question.

Retention for summary tables is hardcoded to 60 days for 15 minute summaries, 18 months for

daily summaries and 10 years for weekly data.

• Take into consideration that it can take some time to collect aggregate-level data from the

reporting server.

• Summary tables are built in 15-minute increments using the local time of the reporting server.

There is no guarantee as to the latency of source data. In the event of a failover situation, data

may arrive hours after it was initially created. For this reason all summary time periods reȀect

the time that the source data arrived at the database, which will generally be close to the time

that it was created.

ApplicationSummary_15 Table

A 15-minute summary of Application/element data, useful for Dominant Path analysis.

The start of the time period

for this row

PK

Yes

datetime year to

second

dbdatetime

The name of the VXML

application

PK

Yes

nvarchar(51)

AppName

The name of the application

that transferred to this one

PK

Yes

nvarchar(51)

SourceAppName

The name of the element

PK

No

nvarchar(51)

ElementName

The exit state of the element

PK

Yes

nvarchar(51)

ExitState

The unique id of an element

type

PK; FK

Yes

integer

ElementTypeID

The unique id of a result

PK, FK

Yes

integer

ResultID

The number of occurrences

for this time period

No

Yes

integer

Count

The unique id of a cause

FK

Yes

int

CauseId

The average elapsed time for

this element

No

yes

int

Avg_elapsed

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