Cisco Cisco Unified Customer Voice Portal 11.0(1)

Page of 102
VXMLHotLink Table
This table contains one record for each element in which a hotlink was activated. The Name
field holds the name of the hot link.
Description
Index
Null
Type
Field
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
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)
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.
Description
Index
Null
Type
Field
The unique id of a
VXML application
session
Yes (Primary Key,
Composite SessionID,
CallStartDate)
No
int8
SessionID
Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(1)
79
Chapter 6: Introduction to the Database Schema
Table Definitions