Technical References

Keys and Null Option:Data Type:Description:Field Name:
AK-1 NOT NULLVNAME32
An enterprise name for the translation route. This name must be
unique among all translation routes in the enterprise.
EnterpriseName
FK, IE-1 NOT NULLDBSMALLINT
The Logical Interface Controller associated with the translation
route.
LogicalControllerID
PK, FK NOT NULLDBINT
An identifier that is unique among all skill targets in the enterprise.
SkillTargetID
NOT NULLDBINT
The type of translation route:
Type
• 1 = DNIS
• 2 = CDPD
Trunk Table
This is in the Device (page 441) category. For database rules, click here (page 504).
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
Galaxy_Single_Trunk Table (page 202) (via TrunkID)
Galaxy_Trunk_Call_Count Table (page 204) (via TrunkID)
Trunk Group (page 420) (via TrunkGroupID)
Vru Port Map (page 437) (via TrunkID)
Table 204: Indexes for Trunk Table
index_keysindex_descriptionindex_name
TrunkGroupID, TrunkNumbernonclustered, unique, unique key
located on PRIMARY
XAKTrunk
TrunkIDclustered, unique, primary key
located on PRIMARY
XPKTrunk
Fields in Trunk Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLVNAME32
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