Technical References

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.
The ICM software generates a Route_Call_Variable record for each enabled expanded call
variable for every routing request it processes.
Related tables
Expanded_Call_Variable (page 179) (via ExpandedCallVariableID)
Route_Call_Detail (page 278) (RCDRecoveryKey maps to Route_Call_Detail.RecoveryKey)
Table 160: Indexes for Route_Call_Variable Table
index_keysindex_descriptionindex_name
RCDRecoveryKey,
ExpandedCallVariableID, ArrayIndex
clustered, unique, unique key located
on PRIMARY
XAK1Route_Call_Variable
DateTimenonclustered located on PRIMARYXIE1Route_Call_Variable
DbDateTimenonclustered located on PRIMARYXIE2Route_Call_Variable
RecoveryKeynonclustered, unique, primary key
located on PRIMARY
XPKRoute_Call_Variable
Fields in Route_Call_Variable Table:
Keys and Null Option:Data Type:Description:Field Name:
AK-2 NOT NULLDBINT
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.
ArrayIndex
IE-1 NOT NULLDBSMALLDATE
The date and time when the call was routed.
DateTime
IE-2 NULLDBDATETIME
The current date and time stamp when the records are written
to the HDS database. The logger database has NULL for this
column.
DbDateTime
NULLvarchar(255)
The value of the call variable or array element.
ECCValue
AK-2, FK NOT NULLDBSMALLINT
Identifies the expanded call variable.
ExpandedCallVariableID
AK-2 NOT NULLDBFLT8
The RecoveryKey value from the associated
Route_Call_Detail row.
RCDRecoveryKey
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by
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