Cisco Cisco Unified Customer Voice Portal 11.0(1)

Page of 96
Description
Index
Null
Type
Field
The type of action for
a session variable that
changes data
No
No
int
ActionTypeID
Date and time when the
session variable
changed
Yes
No
datetime
EventDateTime
The data type of the
session variable, such
No
No
int
VarDataTypeID
as Integer, String,
Boolean
The name of the
message bus that
No
No
varchar(42)
MessageBusName
delivers the VXML
datafeed message
The date and time of
the database operation
No
No
datetime
DBDateTime
Indicates whether this
session variable change
No
No
boolean
FromICM
originated from
Unified ICME;
Informix stores these
values as 1 or 0, but
represents these values
as 't' or 'f'
VXMLVoiceInteractDetail Table
Description
Index
Null
Type
Field
The unique id of a
visited 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
Time since the last
interaction
No
No
int
ElapsedTimeMillisecond
Type of interaction
No
No
int
VoiceActionTypeID
Value of interaction
No
Yes
nvarchar(255)
Value
The date and time of
the database operation
No
No
datetime
DBDateTime
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
74
Chapter 5: - Introduction to the Database Schema
Table Definitions