Cisco Cisco Customer Voice Portal 8.0(1)

Page of 102
Description
Index
Null
Type
Field
The local time zone
identifier. This field is
not populated
No
Yes
int
LocalTimeZone
ANI of the caller sent
by telephony provider
No
Yes
varchar(32)
ANI
DNIS of a call sent by
telephony provider
No
No
varchar(32)
DNIS
The date and time a
call ended with
hang-up or disconnect.
No
Yes
datetime
EndDateTime
Note: 
Sometimes
messages are
dropped—even for an
otherwise successful
call. In these 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
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
No
No
int
TotalTransfer
transferred out. A
transfer includes
Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(2)
58
Chapter 6: Introduction to the Database Schema
Table Definitions