Cisco Cisco IP Contact Center Release 4.6.1 Technical References
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
(via TrunkGroupID)
Table 206: Indexes for Trunk_Group_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Trunk_Group_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Trunk_Group_Half_Hour
DateTime, TrunkGroupID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKTrunk_Group_Half_Hour
Fields in Trunk_Group_Half_Hour Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Total time, in seconds, during the half-hour
interval that all trunks in the group were busy.
interval that all trunks in the group were busy.
AllTrunksBusyToHalf
NULL
DBINT
Number of calls to the trunk group abandoned
during the current half-hour interval.
during the current half-hour interval.
CallsAbandonedToHalf
NULL
DBINT
Number of incoming calls received on the trunk
group during the half-hour interval.
group during the half-hour interval.
CallsInToHalf
NULL
DBINT
Number of outbound calls sent on the trunk group
during the half-hour interval.
during the half-hour interval.
CallsOutToHalf
PK NOT NULL
DBSMALLDATE
Central Controller date and time at the start of
the half-hour interval.
the half-hour interval.
DateTime
IE-1 NULL
DBDATETIME
The current date and time stamp when the records
are written to the HDS database. The logger
database has NULL for this column.
are written to the HDS database. The logger
database has NULL for this column.
DbDateTime
NULL
DBINT
Aggregate number of seconds trunks in the group
were in service during the half-hour interval.
were in service during the half-hour interval.
InServiceTimeToHalf
NULL
DBINT
Aggregate number of seconds trunks in the group
were used for inbound calls during the half-hour
interval.
were used for inbound calls during the half-hour
interval.
InUseInboundTimeToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
358
Chapter 2: - All Tables
Trunk_Group_Half_Hour Table