Cisco Cisco Unified Customer Voice Portal 11.0(1)

Page of 102
CallEvent Table
Descriptions
Index
Null
Type
Field
The global unique id of
a call
Yes (Composite index
CallGUID,
CallStartDate)
No
char(35)
CallGUID
Date of the call, for
data purging purposes
Yes (Composite index
CallGUID,
CallStartDate)
No
date
CallStartDate
A call id assigned by a
Service
No
Yes
varchar(43)
CallLegID
The name of the Call
Server (its message
No
No
varchar(42)
MessageBusName
adapter name) with
which the event is
associated
Date and time of the
event
Yes
No
datetime
EventDateTime
The mechanism used
to generate the call
event
No
No
int
EventTypeID
The reason that the call
event was generated
No
No
int
CauseID
The date and time of
the database operation
No
No
datetime
DBDateTime
The type of the Service
Yes
No
int
SubSystemTypeID
The name of the
Service the event
originated from
No
No
varchar(41)
SubSystemName
The local time zone
identifier
No
Yes
int
LocalTimeZone
CallICMInfo Table
Descriptions
Index
Null
Type
Field
The global unique id of a call
Yes (Composite
index
No
char(35)
CallGUID
CallGUID,
CallStartDate)
Date of the call, for data
purging purposes
Yes (Composite
index
No
date
CallStartDate
CallGUID,
CallStartDate)
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.0(1)
63
Chapter 5: Introduction to the Database Schema
Table Definitions