Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-282
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Trunk_Group_Five_Minute Table
Trunk Group Half Hour (via TrunkGroupID)
Trunk Group Real Time (via TrunkGroupID)
Trunk (via TrunkGroupID)
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:
Trunk Group (via TrunkGroupID)
Table 2-185 Trunk_Group_Five_Minute Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
Central Controller date and time at the start of the
five-minute interval.
five-minute interval.
smalldatetime
PK, NOT NULL
TrunkGroupID
Foreign key from the Trunk Group table.
int
PK, FK, NOT
NULL
NULL
TimeZone
The time zone for the date and time. The value is the offset
in minutes from GMT.
in minutes from GMT.
int
PK, NOT NULL
TrunksInService
Number of trunks in this trunk group in service at the end
of the five-minute interval.
of the five-minute interval.
int
NULL
AllTrunksBusyToHalf
Total time, in seconds, during the current half-hour
interval that all trunks in the group were busy.
interval that all trunks in the group were busy.
int
NULL
TrunksIdle
Number of non-busy trunks in the group at the end of the
five-minute interval.
five-minute interval.
int
NULL
RecoveryDay
A value used internally by the ICM software to track
virtual time.
virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL