Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-213
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
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.
Table 2-222 Network_Trunk_Group_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
DateTime
NetworkTrunkGroupID
TimeZone
NetworkTrunkGroupID
TimeZone
AK-1
RecoveryKey
IE-1
DbDateTime
Table 2-223 Network_Trunk_Group_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
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.
DBINT
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.
DBINT
NULL
CallsInToHalf
Number of inbound calls offered to the network
trunk group during the half-hour interval.
trunk group during the half-hour interval.
DBINT
NULL
CallsOutToHalf
Number of outbound calls sent on the network
trunk group during the half-hour interval.
trunk group during the half-hour interval.
DBINT
NULL
DateTime
The date and time at the start of the half-hour
interval.
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 in use for inbound calls during the half-hour
interval.
were in use for inbound calls during the half-hour
interval.
DBINT
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.
DBINT
NULL
NetworkTrunkGroupID
Identifies the network trunk group.
DBINT
PK
NOT NULL