Cisco Cisco Unified Contact Center Enterprise 8.5(1) Referencia técnica
Each row records the value of an expanded call variable for a call routed by the ICM software.
If the expanded call variable is an array, one Route_Call_Variable row is generated for each
element of the array.
If the expanded call variable is an array, one Route_Call_Variable row is generated for each
element of the array.
The ICM software generates a Route_Call_Variable record for each enabled expanded call
variable for every routing request it processes.
variable for every routing request it processes.
Related tables
(via ExpandedCallVariableID)
(RCDRecoveryKey maps to Route_Call_Detail.RecoveryKey)
Table 160: Indexes for Route_Call_Variable Table
index_keys
index_description
index_name
RCDRecoveryKey,
ExpandedCallVariableID, ArrayIndex
ExpandedCallVariableID, ArrayIndex
clustered, unique, unique key located
on PRIMARY
on PRIMARY
XAK1Route_Call_Variable
DateTime
nonclustered located on PRIMARY
XIE1Route_Call_Variable
DbDateTime
nonclustered located on PRIMARY
XIE2Route_Call_Variable
RecoveryKey
nonclustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKRoute_Call_Variable
Fields in Route_Call_Variable Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
AK-2 NOT NULL
DBINT
If the expanded call variable is an array, this identifies the
array element: 0 to N-1, where N is the size of the array.
array element: 0 to N-1, where N is the size of the array.
ArrayIndex
IE-1 NOT NULL
DBSMALLDATE
The date and time when the call was routed.
DateTime
IE-2 NULL
DBDATETIME
The current date and time stamp when the records are written
to the HDS database. The logger database has NULL for this
column.
to the HDS database. The logger database has NULL for this
column.
DbDateTime
NULL
varchar(255)
The value of the call variable or array element.
ECCValue
AK-2, FK NOT NULL
DBSMALLINT
Identifies the expanded call variable.
ExpandedCallVariableID
AK-2 NOT NULL
DBFLT8
The RecoveryKey value from the associated
Route_Call_Detail row.
Route_Call_Detail row.
RCDRecoveryKey
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used internally by
the ICM/IPCC Enterprise software to track the record.
the ICM/IPCC Enterprise software to track the record.
RecoveryKey
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
284
Chapter 2: All Tables
Route_Call_Variable Table