Cisco Cisco Customer Voice Portal Downloads

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
data feed message

The date and time of
the database operation

No

No

datetime

DBDateTime

(when the 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)

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

Date of the call, for
data purging purposes

Yes (Composite index
ElementID,
CallStartDate)

No

date

CallStartDate

The name of the
element variable

No

No

nvarchar(51)

VarName

The String value of the
element variable

No

Yes

nvarchar(255)

VarValue

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