Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-417
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Trunk_Group Table
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.
Table 2-375 Trunk_Group Table Constraints
Constraint
Field Name(s)
PK
TrunkGroupID
AK-1
EnterpriseName
AK-2
PeripheralID
PeripheralNumber
PeripheralNumber
FK
NetworkTrunkGroupID
PeripheralID
PeripheralID
IE-1
NetworkTrunkGroupID
Table 2-376 Trunk_Group Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
ConfigParam
A string of parameters the ICM software sends to
the peripheral to initialize the trunk group.
the peripheral to initialize the trunk group.
DESCRIPTION
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
Description
Additional information about the trunk group.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for the trunk group. This must
be unique among all trunk groups in the enterprise.
be unique among all trunk groups in the enterprise.
VNAME32
AK-1
NOT NULL
Extension
The extension number for the trunk group (used by
the Definity ECS ACD).
the Definity ECS ACD).
VTELNO10
NULL
NetworkTrunkGroupID
Optionally, the network trunk group to which this
trunk group belongs.
trunk group belongs.
DBINT
FK, NULL
PeripheralID
Foreign key from the Peripheral table.
DBSMALLINT
AK-2, FK
NOT NULL
PeripheralName
Trunk group name as given by the peripheral.
VNAME32
NOT NULL
PeripheralNumber
Trunk group number as given by the peripheral.
DBINT
AK-2
NOT NULL