Manual
DescriptionIndexNullTypeField
The unique id of a
visited element
Yes (Primary Key,
Composite ElementID,
CallStartDate)
Noint8ElementID
Date of the call, for
data purging purposes
Yes (second field in
Primary Key and
Composite indexes)
NodateCallStartDate
The unique id of a
VXML application
session
Yes (Composite index
SessionID,
CallStartDate)
Noint8SessionID
The global unique id of
a call
YesNochar(35)CallGUID
The name of an
element
NoNonvarchar(51)ElementName
The type of elementNoNointElementTypeID
Date and time when the
element was entered
YesNodatetimeEnterDateTime
Date and time when the
element was exited
NoYesdatetimeExitDateTime
The exit state of the
element
NoYesnvarchar(51)ExitState
The number of
interactions while the
NoYesintNumberOfInteractions
user visited this
element
Indicates how an
element ended
NoYesintResultID
The name of the
message bus that
NoNovarchar(42)MessageBusName
delivers the VXML
datafeed message
The date and time of
the database operation
NoNodatetimeDBDateTime
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.
DescriptionIndexNullTypeField
The unique id of an
element
Yes (Composite index
ElementID,
CallStartDate)
Noint8ElementID
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
69
Chapter 5: Introduction to the Database Schema
Table Definitions