Technical References

Trunk Group (page 420) (via TrunkGroupID)
Table 207: Indexes for Trunk_Group_Half_Hour Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Trunk_Group_Half_Hour
DbDateTimenonclustered located on PRIMARYXIE1Trunk_Group_Half_Hour
DateTime, TrunkGroupID, TimeZoneclustered, unique, primary key
located on PRIMARY
XPKTrunk_Group_Half_Hour
Fields in Trunk_Group_Half_Hour Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Total time, in seconds, during the half-hour interval that all trunks
in the group were busy.
AllTrunksBusyToHalf
NULLDBINT
Number of calls to the trunk group abandoned during the current
half-hour interval.
CallsAbandonedToHalf
NULLDBINT
Number of incoming calls received on the trunk group during
the half-hour interval.
CallsInToHalf
NULLDBINT
Number of outbound calls sent on the trunk group during the
half-hour interval.
CallsOutToHalf
PK NOT NULLDBSMALLDATE
Central Controller date and time at the start of the half-hour
interval.
DateTime
IE-1 NULLDBDATETIME
The current date and time stamp when the records are written to
the HDS database. The logger database has NULL for this
column.
DbDateTime
NULLDBINT
Aggregate number of seconds trunks in the group were in service
during the half-hour interval.
InServiceTimeToHalf
NULLDBINT
Aggregate number of seconds trunks in the group were used for
inbound calls during the half-hour interval.
InUseInboundTimeToHalf
NULLDBINT
Aggregate number of seconds trunks in the group were used for
outbound calls during the half-hour interval.
InUseOutboundTimeToHalf
NOT NULLDBINT
Currently not used, set to zero (0).
RecoveryDay
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
423
Chapter 2: All Tables
Trunk_Group_Half_Hour Table