Cisco Cisco Unified Customer Voice Portal 11.0(1)

Page of 102
Description
Index
Null
Type
Field
The date and time
when the record is
updated
No
No
datetime
UpdateDateTime
CVPLog Table
This table contains log messages.
Description
Index
Null
Type
Field
Date and time of
message
No
Yes
datetime
MessageDateTime
Message details
No
Yes
varchar(255)
Message
Type of message: Add,
Aged Off, Alter, Err
Yes
Yes
char(8)
MessageClass
Info, Remainder,
EPurge
Note: Effective, Unified CVP Release 7.x, the CVPDateTrap, CVPPartitionInfo,
CVPPartitionParameters, and CVPPurgeList tables are only for system use.
ElementTypeRef Table
This is the table to map an ElementTypeID to a VXML element type.
Description
Index
Null
Type
Field
The unique id of an
element type
Yes (Primary Key)
No
int
ElementTypeID
The name of the
element type
No
No
nvarchar(96)
Name
Table Values (ID, Name):
0, "Start"
1, "End"
2, "Subdialog_Start"
3, "Subdialog_Return"
4, "Decision"
5, "Action"
6, "Custom"
7, "HotLink"
Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(1)
68
Chapter 6: - Introduction to the Database Schema
Table Definitions