Cisco Cisco Unified Customer Voice Portal 10.5(1)
Description
Index
Null
Type
Field
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)
event occurred versus
when it was written to
the database (for
example, a long lag
may indicate problems
with the reporting
server)
Indicates whether this
session variable change
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'
Unified ICME;
Informix stores these
values as 1 or 0, but
represents these values
as 't' or 'f'
VXMLVoiceInteractDetail Table
This table contains the unique id of a call.
Description
Index
Null
Type
Field
The unique id of a
visited element
visited element
Yes (Composite index
ElementID,
CallStartDate)
ElementID,
CallStartDate)
No
int8
ElementID
Date of the call, for
data purging purposes
data purging purposes
Yes (Composite index
ElementID,
CallStartDate)
ElementID,
CallStartDate)
No
date
CallStartDate
Time since the last
interaction
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
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)
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)
Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(1)
82
Chapter 6: - Introduction to the Database Schema
Table Definitions