Cisco Cisco Unified Customer Voice Portal 10.5(1)
ActionTypeRef Table
This is the table to map an ActionTypeID to the type of action for an element that changes data.
Descriptions
Index
Null
Type
Field
The unique id of an
action type
action type
Yes (Primary Key)
No
int
ActionTypeID
The name of the action
type
type
No
No
nvarchar(96)
Name
Table Values (ID, Name):
1, "Initialize"
2, "Update"
3, "Return"
Call Table
This table contains one record per call.
Descriptions
Index
Null
Type
Field
The global unique id of
a call
a call
Yes (Primary Key
Composite CallGUID,
CallStartDate)
Composite CallGUID,
CallStartDate)
No
char(35)
CallGUID
Date of the call, for
data purging purposes
data purging purposes
Yes (Primary Key
Composite CallGUID,
CallStartDate)
Composite CallGUID,
CallStartDate)
No
date
CallStartDate
Date and time a call
was made
was made
Yes
No
datetime
StartDateTime
The name of the Call
Server (its message
Server (its message
No
No
varchar(42)
MessageBusName
adapter name) where
the call originates
the call originates
The type of Unified
CVP Service, such as
SIP, IVR, VXML
CVP Service, such as
SIP, IVR, VXML
No
No
int
SubSystemTypeID
The local time zone
identifier
identifier
No
Yes
int
LocalTimeZone
ANI of the caller sent
by telephony provider
by telephony provider
No
No
varchar(32)
ANI
DNIS of a call sent by
telephony provider
telephony provider
No
No
varchar(32)
DNIS
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.0(1)
61
Chapter 5: Introduction to the Database Schema
Table Definitions