Cisco Cisco IPCC Web Option Technical References
2-415
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Translation_Route Table
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.
Related tables:
(via LogicalControllerID)
(via SkillTargetID)
Table 2-371 Translation_Route Table Constraints
Constraint
Field Name(s)
PK
SkillTargetID
AK-1
EnterpriseName
FK
LogicalControllerID
SkillTargetID
SkillTargetID
IE-1
LogicalControllerID
Table 2-372 Translation_Route Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
Description
Additional information about the translation route. DESCRIPTION
NULL
EnterpriseName
An enterprise name for the translation route. This
name must be unique among all translation routes
in the enterprise.
name must be unique among all translation routes
in the enterprise.
VNAME32
AK-1
NOT NULL
LogicalControllerID
The Logical Interface Controller associated with
the translation route.
the translation route.
DBSMALLINT
FK, IE-1
NOT NULL
SkillTargetID
An identifier that is unique among all skill targets
in the enterprise.
in the enterprise.
DBINT
PK, FK
NOT NULL
Type
The type of translation route:
1 = DNIS
2 = CDPD
2 = CDPD
DBINT
NOT NULL