Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-419
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Trunk_Group_Five_Minute Table
Trunk_Group_Five_Minute Table
Central database only.
Contains information about a trunk group collected during each five-minute interval.
The ICM software generates Trunk_Group_Five_Minute records for each trunk group.
Related tables:
(via TrunkGroupID)
Table 2-377 Trunk_Group_Five_Minute Table Constraints
Constraint
Field Name(s)
PK
DateTime
TimeZone
TrunkGroupID
TimeZone
TrunkGroupID
AK-1
RecoveryKey
FK
TrunkGroupID
Table 2-378 Trunk_Group_Five_Minute Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AllTrunksBusyToHalf
Total time, in seconds, during the current
half-hour interval that all trunks in the group were
busy.
half-hour interval that all trunks in the group were
busy.
DBINT
NULL
DateTime
Central Controller date and time at the start of the
five-minute interval.
five-minute interval.
DBSMALLDATE
PK
NOT NULL
RecoveryDay
Currently not used, set to zero (0).
DBINT
NOT NULL
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL
TimeZone
The time zone for the date and time. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
DBINT
PK
NOT NULL
TrunkGroupID
Foreign key from the Trunk Group table.
DBINT
PK, FK
NOT NULL
TrunksIdle
Number of non-busy trunks in the group at the end
of the five-minute interval.
of the five-minute interval.
DBINT
NULL
TrunksInService
Number of trunks in this trunk group in service at
the end of the five-minute interval.
the end of the five-minute interval.
DBINT
NULL