Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
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-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
AK-2 NOT NULL
DBFLT8
The date and time when the call was routed.
TCDRecoveryKey
Translation_Route Table
. To see database rules for these tables, click
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.
When the 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.
Related tables
(via SkillTargetID)
Table 203: Indexes for Translation_Route Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Translation_Route
LogicalControllerID
nonclustered located on PRIMARY
XIE1Translation_Route
SkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKTranslation_Route
Fields in Translation_Route Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the translation route.
Description
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
418
Chapter 2: All Tables
Translation_Route Table