Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

Page of 404
 
2-281
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Trunk_Group Table
Related tables:
Trunk Group (via TrunkGroupID)
Trunk_Group Table
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:
Network Trunk Group (via NetworkTrunkGroupID)
Peripheral (via PeripheralID)
Trunk Group Five Minute (via TrunkGroupID)
Table 2-184 Trunk_Group Table
Field Name
Description
Data Type
Keys and Null 
Option
TrunkGroupID
Unique identifier for this trunk group.
int
PK, NOT NULL
EnterpriseName
An enterprise name for the trunk group. This must be 
unique among all trunk groups in the enterprise.
varchar(32)
AK1, NOT 
NULL
PeripheralID
Foreign key from the Peripheral table.
smallint
AK2, FK, NOT 
NULL
PeripheralNumber
Trunk group number as given by the peripheral.
int
AK2, NOT 
NULL
PeripheralName
Trunk group name as given by the peripheral.
varchar(32)
NOT NULL
NetworkTrunkGroupID
Optionally, the network trunk group to which this trunk 
group belongs.
int
FK, NULL
TrunkCount
The number of trunks in the trunk group. If the value is -1 
(the default), the ICM software determines the number of 
trunks in the group dynamically by examining the Trunk 
table. Do not change this value unless the Trunk data are 
not reliable.
int
NOT NULL
Extension
The extension number for the trunk group (used by the 
Definity ECS ACD).
varchar(10)
NULL
ConfigParam
A string of parameters the ICM software sends to the 
peripheral to initialize the trunk group.
varchar(255)
NULL
Description
Additional information about the trunk group.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
char(1)
NOT NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL