Manual

ActionTypeRef Table
This is the table to map an ActionTypeID to the type of action for an element that changes data.
DescriptionIndexNullTypeField
The unique id of an
action type
Yes (Primary Key)NointActionTypeID
The name of the action
type
NoNonvarchar(96)Name
Table Values (ID, Name):
1, "Initialize"
2, "Update"
3, "Return"
Call Table
This table contains one record per call.
DescriptionIndexNullTypeField
The global unique id of
a call
Yes (Primary Key
Composite CallGUID,
CallStartDate)
Nochar(35)CallGUID
Date of the call, for
data purging purposes
Yes (Primary Key
Composite CallGUID,
CallStartDate)
NodateCallStartDate
Date and time a call
was made
YesNodatetimeStartDateTime
The name of the Call
Server (its message
NoNovarchar(42)MessageBusName
adapter name) where
the call originates
The type of Unied
CVP Service, such as
SIP, IVR, VXML
NoNointSubSystemTypeID
The local time zone
identier
NoYesintLocalTimeZone
ANI of the caller sent
by telephony provider
NoNovarchar(32)ANI
DNIS of a call sent by
telephony provider
NoNovarchar(32)DNIS
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
55
Chapter 5: Introduction to the Database Schema
Table Definitions