Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Related tables
(via SkillTargetID)
Table 202: 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.
central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the translation
route.
route.
Description
AK-1 NOT NULL
VNAME32
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.
EnterpriseName
FK, IE-1 NOT NULL
DBSMALLINT
The Logical Interface Controller associated with
the translation route.
the translation route.
LogicalControllerID
PK, FK NOT NULL
DBINT
An identifier that is unique among all skill targets
in the enterprise.
in the enterprise.
SkillTargetID
NOT NULL
DBINT
The type of translation route:
Type
• 1 = DNIS
• 2 = CDPD
Trunk Table
category. For database rules, click
Each row describes a trunk associated with a peripheral. Trunks are grouped by the Trunk Group
table.
table.
Use the Trunk bulk configuration tools to add, update, and delete Trunk records.
Related table
(via TrunkID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
354
Chapter 2: - All Tables
Trunk Table