Cisco Cisco Customer Voice Portal 8.0(1)

Page of 132
VXMLError Table
This table contains VXML errors that occurred during the life of the VXML application session.
The table contains one record for each element in which an error occurred. 
The ErrorName field
holds the name of the error.
Description
Index
Null
Type
Field
The unique id for the element
in which the error occurs
Indexed FK
(Composite index
No
int8
ElementID
ElementID,
CallStartDate)
Date of the call, for data
purging purposes
FK (Composite index
ElementID,
CallStartDate)
No
date
CallStartDate
Name of an error
No
No
varchar(12)
ErrorName
The date and time when the
error occurred
Yes
No
datetime YEAR to
FRACTION(3)
EventDateTime
Uses UTC in Rel. 8.0.
The detailed error message
No
No
nvarchar(255)
Description
The date and time of the
database operation (when the
Yes
No
datetime YEAR to
FRACTION(3)
DBDateTime
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).
VXMLHotEvent Table
Hotevent is a global event that when caught, executes developer-specified actions. This table
contains information (hotevent name, hotevent datetime and the elementId) about the hotevent
occurred in an element.
Description
Index
Null
Type
Field
The unique id for the element
in which the hotevent occurred
Indexed FK
(Composite index
No
int8
ElementID
ElementID,
CallStartDate)
Reporting Guide for Cisco Unified Customer Voice Portal Release 8.0(1)
71
Chapter 4: Database Schema
VXML Tables