Cisco Cisco Customer Voice Portal Downloads

Page of 102
Descriptions
Index
Null
Type
Field
The date and time a
call ended with
No
Yes
datetime
EndDateTime
hang-up or disconnect
(but see the Note
below)
The UUI of the
originating caller sent
by telephony provider
No
Yes
varchar(100)
UUI
The IIDIGITS of the
originating caller sent
by telephony provider
No
Yes
varchar(100)
Iidigits
The external UID of
the caller if the call is
associated with a user
No
Yes
varchar(50)
UID
The number of
applications visited
No
No
int
NumAppVisited
during the life of the
call
The number of times
that the call is opt out
to an agent
No
No
int
NumOptOut
The total number of
times the call is
transferred out
No
No
int
TotalTransfer
The number of times
the call timed out
No
No
int
NumTimeOut
The number of errors
that occurred during
the call
No
No
int
NumError
The number of times
the call is on hold due
to unavailable port
No
No
int
NumOnHold
The date and time of
the database operation
No
No
datetime
DBDateTime
Note: On occasion, messages are dropped—even for an otherwise successful call. In such cases,
EndDateTime is set to the same value as StartDateTime. Thus, if a call appears to be of 0
duration, report writers will know to exclude such a call from consideration in cases where it
would otherwise skew metrics.
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.0(1)
62
Chapter 5: - Introduction to the Database Schema
Table Definitions