Cisco Cisco Unified Customer Voice Portal 10.5(1)

Page of 96
Description
Index
Null
Type
Field
ICM Router CallKey
Yes
No
int
RouterCallKey
ICM RouterCallKeyDay
Yes
No
int
RouterCallKeyDay
ICM
RouterCallKeySequenceNumber
Yes
Yes
int
RouterCallKeySequenceNumber
Date and time of the event
Yes
No
datetime
EventDateTime
The name of the message bus
that delivers the VXML
datafeed message
No
No
varchar(42)
MessageBusName
The date and time of the
database operation
No
No
datetime
DBDateTime
CauseRef Table
This is the table to map a CauseID to the cause.
Description
Index
Null
Type
Field
The unique id of a call
event cause
Yes (Primary Key)
No
int
CauseID
The cause of the event
No
No
nvarchar(96)
Name
Table Values (ID, Name):
0, "None"
1, "Normal Completion"
2, "Call Abandon"
3, "Call Transferred"
4, "New Transaction"
5, "Busy"
6, "No Answer"
7, "Maintenance"
8, "Net Congestion"
9, "Net Not Obtainable"
10, "Reorder Tone"
11, "Resources Not Available"
12, "Trunks Busy"
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
58
Chapter 5: - Introduction to the Database Schema
Table Definitions