Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
AK-1, FK NOT NULL
DBINT
Foreign key from the Trunk Group table.
TrunkGroupID
PK NOT NULL
DBINT
A unique identifier for the trunk.
TrunkID
AK-1 NOT NULL
DBINT
Trunk number as understood by the peripheral.
TrunkNumber
NOT NULL
DBSMALLINT
Type of trunk. To see the list of values, click 
.
TrunkType
Trunk_Group Table
 category. For database rules, click 
Each row defines a group of trunks. A peripheral determines how to handle a call based on the
DNIS and the trunk group on which it arrives.
Use the Trunk Group bulk configuration tools to add, update, and delete Trunk_Group records.
Related tables
 (via NetworkTrunkGroupID)
 (via PeripheralID)
 (via TrunkGroupID)
 (via TrunkGroupID)
 (via TrunkGroupID)
 (via TrunkGroupID)
Table 205: Indexes for Trunk_Group Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1Trunk_Group
PeripheralID, PeripheralNumber
nonclustered, unique, unique key
located on PRIMARY
XAK2Trunk_Group
NetworkTrunkGroupID
nonclustered located on PRIMARY
XIE1Trunk_Group
TrunkGroupID
clustered, unique, primary key
located on PRIMARY
XPKTrunk_Group
Fields in Trunk_Group Table:
Keys and Null
Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
420
Chapter 2:  All Tables
Trunk_Group Table