Cisco Cisco Unified Customer Voice Portal 11.0(1)

The unique id of a
visited element

Yes (Primary Key,
Composite ElementID,
CallStartDate)

No

int8

ElementID

Date of the call, for
data purging purposes

Yes (second field in
Primary Key and
Composite indexes)

No

date

CallStartDate

The unique id of a
VXML application
session

Yes (Composite index
SessionID,
CallStartDate)

No

int8

SessionID

The global unique id of
a call

Yes

No

char(35)

CallGUID

The name of an
element

No

No

nvarchar(51)

ElementName

The type of element

No

No

int

ElementTypeID

Date and time when the
element was entered

Yes

No

datetime

EnterDateTime

Date and time when the
element was exited

No

Yes

datetime

ExitDateTime

The exit state of the
element

No

Yes

nvarchar(51)

ExitState

The number of
interactions while the

No

Yes

int

NumberOfInteractions

user visited this
element

Indicates how an
element ended

No

Yes

int

ResultID

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

VXMLElementDetail Table

This table contains one detail record for each script element variable. VarValue holds the String
value of the variable and VarDataTypeID specifies the data type of the variable to which the
String value can be converted.

The unique id of an
element

Yes (Composite index
ElementID,
CallStartDate)

No

int8

ElementID

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