Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-283
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Trunk_Group_Half_Hour Table
Trunk_Group_Half_Hour Table
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 tables:
Trunk Group (via TrunkGroupID)
Table 2-186 Trunk_Group_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
Central Controller date and time at the start of the
half-hour interval.
half-hour interval.
smalldatetime
PK, NOT
NULL
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.
offset in minutes from GMT.
int
PK, NOT
NULL
NULL
CallsAbandonedToHalf
Number of calls to the trunk group abandoned during
the current half-hour interval.
the current half-hour interval.
int
NULL
CallsInToHalf
Number of incoming calls received on the trunk group
during the half-hour interval.
during the half-hour interval.
int
NULL
TrunksInService
Number of trunks in the group in service at the end of
the half-hour interval.
the half-hour interval.
int
NULL
CallsOutToHalf
Number of outbound calls sent on the trunk group
during the half-hour interval.
during the half-hour interval.
int
NULL
AllTrunksBusyToHalf
Total time, in seconds, during the half-hour interval
that all trunks in the group were busy.
that all trunks in the group were busy.
int
NULL
InServiceTimeToHalf
Aggregate number of seconds trunks in the group were
in service during the half-hour interval.
in service during the half-hour interval.
int
NULL
TrunksIdle
Number of non-busy trunks in the group at the end of
the half-hour interval.
the half-hour interval.
int
NULL
InUseInboundTimeToHalf
Aggregate number of seconds trunks in the group were
used for inbound calls during the half-hour interval.
used for inbound calls during the half-hour interval.
int
NULL
RecoveryDay
A value used internally by the ICM software to track
virtual time.
virtual time.
int
NOT NULL
InUseOutboundTimeToHalf
Aggregate number of seconds trunks in the group were
used for outbound calls during the half-hour interval.
used for outbound calls during the half-hour interval.
int
NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL