Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-420
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
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.
Table 2-379 Trunk_Group_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
DateTime
TimeZone
TrunkGroupID
TimeZone
TrunkGroupID
AK-1
RecoveryKey
FK
TrunkGroupID
Table 2-380 Trunk_Group_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AllTrunksBusyToHalf
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.
DBINT
NULL
CallsAbandonedToHalf
Number of calls to the trunk group abandoned
during the current half-hour interval.
during the current half-hour interval.
DBINT
NULL
CallsInToHalf
Number of incoming calls received on the trunk
group during the half-hour interval.
group during the half-hour interval.
DBINT
NULL
CallsOutToHalf
Number of outbound calls sent on the trunk group
during the half-hour interval.
during the half-hour interval.
DBINT
NULL
DateTime
Central Controller date and time at the start of the
half-hour interval.
half-hour interval.
DBSMALLDATE
PK
NOT 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
IE-1
NULL
InServiceTimeToHalf
Aggregate number of seconds trunks in the group
were in service during the half-hour interval.
were in service during the half-hour interval.
DBINT
NULL
InUseInboundTimeToHalf
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.
DBINT
NULL
InUseOutboundTimeToHalf
Aggregate number of seconds trunks in the group
were used for outbound calls during the half-hour
interval.
were used for outbound calls during the half-hour
interval.
DBINT
NULL
RecoveryDay
Currently not used, set to zero (0).
DBINT
NOT NULL
RecoveryKey
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.
DBFLT8
AK-1
NOT NULL