Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-279
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Termination_Call_Variable Table
Termination_Call_Variable Table
Central database only.
Each row records the value of an expanded call variable for a call handled at a peripheral. If the expanded
call variable is an array, one Termination_Call_Variable row is generated for each element of the array.
call variable is an array, one Termination_Call_Variable row is generated for each element of the array.
The ICM software generates a Termination_Call_Variable record for each enabled expanded call
variable for every call processed at a peripheral.
variable for every call processed at a peripheral.
Related tables:
Expanded_Call_Variable (via ExpandedCallVariableID)
Termination_Call_Detail (TCDRecoveryKey maps to Termination_Call_Detail.RecoveryKey)
Translation_Route Table
Each row defines a special route that is used for sending additional information with the call. When the
peripheral receives a call targeted at a translation route, it requests the true route from the ICM
CallRouter process.
peripheral receives a call targeted at a translation route, it requests the true route from the ICM
CallRouter process.
Use the Translation Route Explorer or Translation Route Wizard to add, update, and delete
Translation_Route records.
Translation_Route records.
Table 2-181 Termination_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
TCDRecoveryKey
The RecoveryKey value from the associated
Termination_Call_Detail row.
Termination_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
Table 2-182 Translation_Route Table
Field Name
Description
Data Type
Keys and Null
Option
Option
SkillTargetID
An identifier that is unique among all skill targets in the
enterprise.
enterprise.
int
PK, FK, NOT
NULL
NULL
EnterpriseName
An enterprise name for the translation route. This name
must be unique among all translation routes in the
enterprise.
must be unique among all translation routes in the
enterprise.
varchar(32)
AK1, NOT
NULL
NULL