Cisco Cisco Customer Voice Portal 8.0(1)

VXMLHotLink Table

The unique id for the
element in which the
hotlink activated

Yes (Composite index
ElementID,
CallStartDate)

No

int8

ElementID

Date of the call, for
data purging purposes

Yes (Composite index
ElementID,
CallStartDate)

No

date

CallStartDate

The date and time
when the hot link
activated

Yes

No

datetime

EventDateTime

The name of the hot
link

No

No

nvarchar(51)

Name

The name of the
message bus that

No

No

varchar(42)

MessageBusName

delivers the VXML
datafeed message

The date and time of
the database operation

No

No

datetime

DBDateTime

VXMLSession Table

This table contains one record for each application visited by a call. For example, if a call has
transferred from one application to another one, the call with the same CallGUID will have two
session records.

The unique id of a
VXML application
session

Yes (Primary Key,
Composite SessionID,
CallStartDate)

No

int8

SessionID

Date of the call, for
data purging purposes

Yes (second field in
Primary Key and
Composite indexes)

No

date

CallStartDate

The name of the
session assigned by
VXML Server

No

No

nvarchar(96)

SessionName

The global unique id of
a call

Yes (Composite index
CallGUID,
CallStartDate)

No

char(35)

CallGUID

Date and time when
session starts

Yes

No

datetime

StartDateTime

The name of the
VXML application

Yes

No

nvarchar(51)

AppName

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