Cisco Cisco Customer Voice Portal 8.0(1)

Date of the call, for data

purging purposes

Yes (Composite

index ElementID,

CallStartDate)

No

date

CallStartDate

The date and time when hot

event occurred

Yes

No

datetime YEAR to

FRACTION(3)

EventDateTime

Uses UTC in Rel. 8.0.
The name of the hot event

No

No

nvarchar(51)

Name

The date and time of the

database operation (when the

No

No

datetime YEAR to

FRACTION(3)

DBDateTime

record was inserted). This is

useful for debugging purposes

to determine lags between

when the event occurred

versus when it was written to

the database (for example, a

long lag may indicate

problems with the reporting

server).

VXMLHotLink Table

Hotlink is a globally accessible utterance and/or key press that immediately brings the call to a

specific part of the call Ȁow or throws an event. This table contains information (hotlink name,

hotlink datetime and the elementId) about the hotlink that occurred in an element.

The unique id for the

element in which the hotlink

activated

Indexed FK

(Composite index

ElementID,

CallStartDate)

No

int8

ElementID

Date of the call, for data

purging purposes

FK (Composite index

ElementID,

CallStartDate),

No

date

CallStartDate

The date and time when the

hot link activated

Yes

No

datetime YEAR to

FRACTION(3)

EventDateTime

Uses UTC in Rel. 8.0.
The name of the hot link

No

No

nvarchar(51)

Name

The date and time of the

database operation (when

Yes

No

datetime YEAR to

FRACTION(3)

DBDateTime

the record was inserted).

This is useful for debugging

purposes to determine lags

between when the event

occurred versus when it was

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