Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-132
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Network_Trunk_Group_Half_Hour Table
Network_Trunk_Group_Half_Hour Table
Central database only.
Provides statistics for each network trunk group defined in the system. These statistics are updated every
30 minutes.
30 minutes.
The ICM software generates Network_Trunk_Group_Half_Hour records for each network trunk group.
Related tables:
Network Trunk Group (via NetworkTrunkGroupID)
Table 2-110 Network_Trunk_Group_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
NetworkTrunkGroupID
Identifies the network trunk group.
int
PK, FK, NOT
NULL
NULL
DateTime
The date and time at the start of the half-hour
interval.
interval.
datetime
PK, NOT 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
AllTrunksBusyToHalf
Total number of seconds for which all trunks in the
network trunk group were busy simultaneously
during the half-hour interval.
network trunk group were busy simultaneously
during the half-hour interval.
int
NULL
CallsAbandonedToHalf
Number of calls to the network trunk group that
were abandoned during the half-hour interval.
were abandoned during the half-hour interval.
int
NULL
CallsInToHalf
Number of inbound calls offered to the network
trunk group during the half-hour interval.
trunk group during the half-hour interval.
int
NULL
CallsOutToHalf
Number of outbound calls sent on the network trunk
group during the half-hour interval.
group during the half-hour interval.
int
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.
int
NULL
InUseInboundTimeToHalf
Aggregate number of seconds trunks in the group
were in use for inbound calls during the half-hour
interval.
were in use for inbound calls during the half-hour
interval.
int
NULL
InUseOutboundTimeToHalf
Aggregate number of seconds trunks in the group
were in use for outbound calls during the half-hour
interval.
were in use for outbound calls during the half-hour
interval.
int
NULL
TrunksIdle
Number of idle trunks in the network trunk group at
the end of the half-hour interval.
the end of the half-hour interval.
int
NULL
TrunksInService
Number of in-service trunks in the network trunk
group at the end of the half-hour interval.
group at the end of the half-hour interval.
int
NULL
RecoveryDay
A value used internally by the ICM software to
track virtual time.
track virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to
track virtual time.
track virtual time.
float
NOT NULL