Cisco Cisco IP Contact Center Release 4.6.1 Technical References
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.
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
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.
unique among all trunk groups in the enterprise.
varchar(32)
AK1, NOT
NULL
NULL
PeripheralID
Foreign key from the Peripheral table.
smallint
AK2, FK, NOT
NULL
NULL
PeripheralNumber
Trunk group number as given by the peripheral.
int
AK2, NOT
NULL
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.
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.
(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).
Definity ECS ACD).
varchar(10)
NULL
ConfigParam
A string of parameters the ICM software sends to the
peripheral to initialize the trunk group.
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
N = No
char(1)
NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL