Cisco Cisco IPCC Web Option Technical References
2-162
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Route_Call_Variable Table
Related tables:
Call Type (via CallTypeID)
Dialed Number (via DialedNumberID)
Route (via RouteID)
Route_Call_Variable (RecoveryKey maps to Route_Call_Variable.RCDRecoveryKey)
Routing Client (via RoutingClientID)
Script (via ScriptID)
Script Cross Reference (via FinalObjectID)
Termination Call Detail (via Day + RouterCallKey)
Route_Call_Variable Table
Central database only.
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.
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.
every routing request it processes.
Related tables:
Expanded_Call_Variable (via ExpandedCallVariableID)
Route_Call_Detail (RCDRecoveryKey maps to Route_Call_Detail.RecoveryKey)
Table 2-140 Route_Call_Variable Table
Field Name
Description
Data Type
Keys and Null
Option
Option
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL
DateTime
The date and time when the call was routed.
smalldatetime
IE1, NOT NULL
RCDRecoveryKey
The RecoveryKey value from the associated
Route_Call_Detail row.
Route_Call_Detail row.
float
AK2, NOT
NULL
NULL
ExpandedCallVariableID
Identifies the expanded call variable.
smallint
FK, AK2, NOT
NULL
NULL
ArrayIndex
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.
identifies the array element: 0 to N-1, where N is the
size of the array.
int
AK2, NOT
NULL
NULL
ECCValue
The value of the call variable or array element.
varchar(255)
NULL