Manual

DescriptionIndexNullTypeField
The mechanism used
to end the application
visit
NoYesintEventTypeID
The reason that the
application visit ended
NoYesintCauseID
The end date and time
of the session
NoYesdatetimeEndDateTime
The name of the
application that
transferred to this one
NoYesnvarchar(51)SourceAppName
The local time zone
identier
NoYesintLocalTimeZone
The duration of the
session (seconds)
NoYesintDuration
The name of the
VXML Service
NoNovarchar(41)SubSystemName
The name of the
message bus that
NoNovarchar(42)MessageBusName
delivers the VXML
datafeed message
The date and time of
the database operation
NoNodatetimeDBDateTime
VXMLSessionVariable Table
This table contains one record for each instance of a session variable. For example, if the same
session variable was modied once in an application script during a call, there will be two
separate records, one for its initial value when it was created and another for the updated value.
DescriptionIndexNullTypeField
The unique id of an
IVR application
session
Yes (Composite index
SessionID,
CallStartDate)
Noint8SessionID
The identier of the
element in which the
Yes (Composite index
ElementID,
CallStartDate)
Noint8ElementID
session variable
changes
Date of the call, for
data purging purposes
Yes (second eld in
Composite indexes)
NodateCallStartDate
The name of the
session variable that
was exited
NoNonvarchar(51)VarName
The value of the
session variable
NoYesnvarchar(255)VarValue
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
73
Chapter 5: Introduction to the Database Schema
Table Definitions