Cisco Cisco Unified Customer Voice Portal 10.5(1)
14, "Agent Video"
15, "ICM Video
OutgoingECCVariable Table
This table contains the ECC variable used by ICM. This is for outgoing calls, that is calls from
Unified CVP back to ICM.
Unified CVP back to ICM.
Description
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
data feed message
data feed message
The date and time of
the database operation
the database operation
No
No
datetime
DBDateTime
(when the record was
inserted). This is useful
for debugging purposes
to determine lags
between when the
event occurred versus
when it was written to
the database (for
example, a long lag
may indicate problems
with the reporting
server)
inserted). This is useful
for debugging purposes
to determine lags
between when the
event occurred versus
when it was written to
the database (for
example, a long lag
may indicate problems
with the reporting
server)
Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(1)
70
Chapter 6: - Introduction to the Database Schema
Table Definitions