Cisco Cisco Customer Voice Portal Downloads
Description
Index
Null
Type
Field
The global unique id of
a call
a call
Yes (Composite index
CallGUID,
CallStartDate)
CallGUID,
CallStartDate)
No
char(35)
CallGUID
Date of the call, for
data purging purposes
data purging purposes
Yes (Composite index
CallGUID,
CallStartDate)
CallGUID,
CallStartDate)
No
date
CallStartDate
A call id assigned by a
Service
Service
No
Yes
varchar(43)
CallLegID
The name of the Call
Server (its message
Server (its message
No
No
varchar(42)
MessageBusName
adapter name) with
which the event is
associated
Date and time of the
event
which the event is
associated
Date and time of the
event
Yes
No
datetime
EventDateTime
The mechanism used
to generate the call
event
to generate the call
event
No
No
int
EventTypeID
The reason that the call
event was generated
event was generated
No
No
int
CauseID
The date and time of
the database operation
the database operation
No
No
datetime
DBDateTime
(when the 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)
The type of the Service
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)
The type of the Service
Yes
No
int
SubSystemTypeID
The name of the
Service the event
originated from
Service the event
originated from
No
No
varchar(41)
SubSystemName
The local time zone
identifier. This field is
not populated
identifier. This field is
not populated
No
Yes
int
LocalTimeZone
Stores the path and the
name of the media file
name of the media file
No
Yes
nvarchar(255)
MediaFileName
of the video requested
in the call.
in the call.
Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(2)
60
Chapter 6: Introduction to the Database Schema
Table Definitions