Cisco Cisco IPCC Web Option Technical References
2-265
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Route_Call_Variable Table
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:
(via ExpandedCallVariableID)
Table 2-285 Route_Call_Variable Table Constraints
Constraint
Field Name(s)
AK-1
RecoveryKey
AK-2
ArrayIndex
ExpandedCallVariableID
RCDRecoveryKey
ExpandedCallVariableID
RCDRecoveryKey
FK
ExpandedCallVariableID
IE-1
DateTime
IE-2
DbDateTime
Table 2-286 Route_Call_Variable Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
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.
DBINT
AK-2
NOT NULL
DateTime
The date and time when the call was routed.
DBSMALLDATE
IE-1
NOT 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.
are written to the HDS database. The logger
database has NULL for this column.
DBDATETIME
IE-2
NULL
ECCValue
The value of the call variable or array element.
varchar(255)
NULL
ExpandedCallVariableID
Identifies the expanded call variable.
DBSMALLINT
AK-2, FK
NOT NULL
RCDRecoveryKey
The RecoveryKey value from the associated
Route_Call_Detail row.
Route_Call_Detail row.
DBFLT8
AK-2
NOT NULL
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL