Cisco Cisco Customer Voice Portal 8.0(1)
Description
Index
Null
Type
Field
The data type of the
element variable, such
element variable, such
No
No
int
VarDataTypeID
as String, Integer,
Boolean
Boolean
The type of action for
an element that
changes data
an element that
changes data
No
No
int
ActionTypeID
Date and time when the
variable was changed
variable was changed
Yes
No
datetime
EventDateTime
The name of the
message bus that
message bus that
No
No
varchar(42)
MessageBusName
delivers the VXML
data feed message
data feed message
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)
VXMLElementFlag Table
This table contains one record for each element in which a flag was activated. The Name field
holds the name of the flag.
holds the name of the flag.
Description
Index
Null
Type
Field
The unique id for the
element in which the
flag activated
element in which the
flag activated
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
The date and time
when the flag activated
when the flag activated
Yes
No
datetime
EventDateTime
The flag name
No
No
nvarchar(51)
Name
Name of the previous
application element
application element
No
Yes
nvarchar(51)
PreviousElementName
Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(1)
76
Chapter 6: - Introduction to the Database Schema
Table Definitions