Manual

CallEvent Table
DescriptionIndexNullTypeField
The global unique id of
a call
Yes (Composite index
CallGUID,
CallStartDate)
Nochar(35)CallGUID
Date of the call, for
data purging purposes
Yes (Composite index
CallGUID,
CallStartDate)
NodateCallStartDate
A call id assigned by a
Service
NoYesvarchar(43)CallLegID
The name of the Call
Server (its message
NoNovarchar(42)MessageBusName
adapter name) with
which the event is
associated
Date and time of the
event
YesNodatetimeEventDateTime
The mechanism used
to generate the call
event
NoNointEventTypeID
The reason that the call
event was generated
NoNointCauseID
The date and time of
the database operation
NoNodatetimeDBDateTime
The type of the ServiceYesNointSubSystemTypeID
The name of the
Service the event
originated from
NoNovarchar(41)SubSystemName
The local time zone
identier
NoYesintLocalTimeZone
CallICMInfo Table
DescriptionIndexNullTypeField
The global unique id of a callYes (Composite
index
Nochar(35)CallGUID
CallGUID,
CallStartDate)
Date of the call, for data
purging purposes
Yes (Composite
index
NodateCallStartDate
CallGUID,
CallStartDate)
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
57
Chapter 5: Introduction to the Database Schema
Table Definitions