Cisco Cisco Unified Customer Voice Portal 11.0(1)
10, "Call Transfer"
11, "Run Script"
OutgoingECCVariable Table
Descriptions
Index
Null
Type
Field
The global unique id of
a call
a call
Yes (Composite index
CallGUID,
CallStartDate)
CallGUID,
CallStartDate)
No
char(35)
CallGUID
Date of the call, for
data purging purposes
data purging purposes
Yes (second field in
Composite indexes)
Composite indexes)
No
date
CallStartDate
The identifier of the
session in which the
ECC variable changes
session in which the
ECC variable changes
Yes (Composite index
SessionID,
CallStartDate)
SessionID,
CallStartDate)
No
int8
SessionID
The identifier of the
element in which the
ECC variable changes
element in which the
ECC variable changes
Yes (Composite index
ElementID,
CallStartDate)
ElementID,
CallStartDate)
No
int8
ElementID
The name of session
variable that was exited
variable that was exited
No
No
char(12)
ECCVarName
The value of session
variable
variable
No
No
nvarchar(255)
ECCVarValue
Date and time when the
ECC variable changed
ECC variable changed
Yes
No
datetime
EventDateTime
The name of the
message bus that
message bus that
No
No
varchar(42)
MessageBusName
delivers the VXML
datafeed message
datafeed message
The date and time of
the database operation
the database operation
No
No
datetime
DBDateTime
ResultRef Table
This is the table to map a ResultID to a result string.
Descriptions
Index
Null
Type
Field
The unique id of a
result
result
Yes (Primary Key)
No
int
ResultID
The name of the
element result
element result
No
No
nvarchar(96)
Name
Table Values (ID, Name):
1, "Normal"
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.0(1)
71
Chapter 5: Introduction to the Database Schema
Table Definitions