Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Trunk_Group_Five_Minute Table
category. For database rules, click
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 table
(via TrunkGroupID)
Table 205: Indexes for Trunk_Group_Five_Minute Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Trunk_Group_Five_Minute
DateTime, TrunkGroupID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKTrunk_Group_Five_Minute
Fields in Trunk_Group_Five_Minute Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
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.
AllTrunksBusyToHalf
PK NOT NULL
DBSMALLDATE
Central Controller date and time at the start of the
fi
fi
ve-minute interval.
DateTime
NOT NULL
DBINT
Currently not used, set to zero (0).
RecoveryDay
AK-1 NOT NULL
DBFLT8
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.
RecoveryKey
PK NOT NULL
DBINT
The time zone for the date and time. The value is
the offset in minutes from UTC (formerly called
GMT).
the offset in minutes from UTC (formerly called
GMT).
TimeZone
PK, FK NOT NULL
DBINT
Foreign key from the Trunk Group table.
TrunkGroupID
NULL
DBINT
Number of non-busy trunks in the group at the end
of the five-minute interval.
of the five-minute interval.
TrunksIdle
NULL
DBINT
Number of trunks in this trunk group in service at
the end of the five-minute interval.
the end of the five-minute interval.
TrunksInService
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
357
Chapter 2: All Tables
Trunk_Group_Five_Minute Table