Technical References

Keys and Null Option:Data Type:Description:Field Name:
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-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by
the ICM/IPCC Enterprise software to track the record.
RecoveryKey
AK-2 NOT NULLDBFLT8
The date and time when the call was routed.
TCDRecoveryKey
Translation_Route Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
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.
Use the Translation Route Explorer or Translation Route Wizard to add, update, and delete
Translation_Route records.
Related tables
Logical Interface Controller (page 230) (via LogicalControllerID)
Skill Target (page 406) (via SkillTargetID)
Table 203: Indexes for Translation_Route Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Translation_Route
LogicalControllerIDnonclustered located on PRIMARYXIE1Translation_Route
SkillTargetIDclustered, unique, primary key
located on PRIMARY
XPKTranslation_Route
Fields in Translation_Route Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
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