Cisco Cisco IP Contact Center Release 4.6.1 Technical References
(via TrunkGroupID)
Table 206: 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:
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.
all trunks in the group were busy.
AllTrunksBusyToHalf
PK NOT NULL
DBSMALLDATE
Central Controller date and time at the start of the five-minute
interval.
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.
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).
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.
five-minute interval.
TrunksIdle
NULL
DBINT
Number of trunks in this trunk group in service at the end of the
five-minute interval.
five-minute interval.
TrunksInService
Trunk_Group_Half_Hour Table
category. For database rules, click
Central database only.
Contains information about a trunk group collected during each 30-minute interval.
The ICM software generates Trunk_Group_Half_Hour records for each trunk group.
Related table
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
422
Chapter 2: All Tables
Trunk_Group_Half_Hour Table