Cisco Cisco Unified Customer Voice Portal 10.5(1)
Description
Index
Null
Type
Field
Date of the call, for
data purging purposes
data purging purposes
Yes (second field in
Primary Key and
Composite indexes)
Primary Key and
Composite indexes)
No
date
CallStartDate
The name of the
session assigned by
VXML Server
session assigned by
VXML Server
No
No
nvarchar(96)
SessionName
The global unique id of
a call
a call
Yes (Composite index
CallGUID,
CallStartDate)
CallGUID,
CallStartDate)
No
char(35)
CallGUID
Date and time when
session starts
session starts
Yes
No
datetime
StartDateTime
The name of the
VXML application
VXML application
Yes
No
nvarchar(51)
AppName
The mechanism used
to end the application
visit
to end the application
visit
No
Yes
int
EventTypeID
The reason that the
application visit ended
application visit ended
No
Yes
int
CauseID
The end date and time
of the session
of the session
No
Yes
datetime
EndDateTime
The name of the
application that
transferred to this one
application that
transferred to this one
No
Yes
nvarchar(51)
SourceAppName
The local time zone
identifier. This field is
not populated
identifier. This field is
not populated
No
Yes
int
LocalTimeZone
The duration of the
session (seconds)
session (seconds)
No
Yes
int
Duration
The name of the
VXML Service
VXML Service
No
No
varchar(41)
SubSystemName
The name of the
message bus that
message bus that
No
No
varchar(42)
MessageBusName
delivers the VXML
data feed message
data feed message
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
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
Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(1)
80
Chapter 6: - Introduction to the Database Schema
Table Definitions