Cisco Cisco IPCC Web Option Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
AK-1 NOT NULL
VNAME32
An enterprise name for the translation route. This 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.
LogicalControllerID
PK, FK NOT NULL
DBINT
An identifier that is unique among all skill targets in the enterprise.
SkillTargetID
NOT NULL
DBINT
The type of translation route:
Type
• 1 = DNIS
• 2 = CDPD
Trunk Table
Each row describes a trunk associated with a peripheral. Trunks are grouped by the Trunk Group
table.
Use the Trunk bulk configuration tools to add, update, and delete Trunk records.
Related table
 (via TrunkID)
 (via TrunkID)
 (via TrunkGroupID)
 (via TrunkID)
Table 204: Indexes for Trunk Table
index_keys
index_description
index_name
TrunkGroupID, TrunkNumber
nonclustered, unique, unique key
located on PRIMARY
XAKTrunk
TrunkID
clustered, unique, primary key
located on PRIMARY
XPKTrunk
Fields in Trunk 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
VNAME32
The carrier that provides the circuit.
CircuitProvider
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
419
Chapter 2:  All Tables
Trunk Table