Manual
VXMLHotLink Table
DescriptionIndexNullTypeField
The unique id for the
element in which the
hotlink activated
Yes (Composite index
ElementID,
CallStartDate)
Noint8ElementID
Date of the call, for
data purging purposes
Yes (Composite index
ElementID,
CallStartDate)
NodateCallStartDate
The date and time
when the hot link
activated
YesNodatetimeEventDateTime
The name of the hot
link
NoNonvarchar(51)Name
The name of the
message bus that
NoNovarchar(42)MessageBusName
delivers the VXML
datafeed message
The date and time of
the database operation
NoNodatetimeDBDateTime
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.
DescriptionIndexNullTypeField
The unique id of a
VXML application
session
Yes (Primary Key,
Composite SessionID,
CallStartDate)
Noint8SessionID
Date of the call, for
data purging purposes
Yes (second field in
Primary Key and
Composite indexes)
NodateCallStartDate
The name of the
session assigned by
VXML Server
NoNonvarchar(96)SessionName
The global unique id of
a call
Yes (Composite index
CallGUID,
CallStartDate)
Nochar(35)CallGUID
Date and time when
session starts
YesNodatetimeStartDateTime
The name of the
VXML application
YesNonvarchar(51)AppName
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
72
Chapter 5: - Introduction to the Database Schema
Table Definitions