/mcpTable 255: Indexes for Network_Trunk_Group_Half_Hour Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Network_Trunk_Group_Half_H DbDateTime Nonclustered located on PRIMARY XIE1Network_Trunk_Group_Half_H NetworkTrunkGroupID, DateTime, TimeZone Clustered, unique, primary key located on PRIMARY XPKNetwork_Trunk_Group_Half_Ho Table 256: Fields in Network_Trunk_Group_Half_Hour Table Keys and NULL Option Data Type Description Name NULL DBINT Total number of seconds for which all trunks in the network trunk group were busy simultaneously during the half-hour interval. AllTrunksBusyToHalf NULL DBINT Number of calls to the network trunk group that were abandoned during the half-hour interval. CallsAbandonedToHalf NULL DBINT Number of inbound calls offered to the network trunk group during the half-hour interval. CallsInToHalf NULL DBINT Number of outbound calls sent on the network trunk group during the half-hour interval. CallsOutToHalf PK NOT NULL DBSMALLDATE The date and time at the start of the half-hour interval. DateTime IE-1 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. DbDateTime NULL DBINT Aggregate number of seconds trunks in the group were in service during the half-hour interval. InServiceTimeToHalf NULL DBINT Aggregate number of seconds trunks in the group were in use for inbound calls during the half-hour interval. InUseInboundTimeToHalf NULL DBINT Aggregate number of seconds trunks in the group were in use for outbound calls during the half-hour interval. InUseOutboundTimeToHalf PK NOT NULL DBINT Identifies the network trunk group. NetworkTrunkGroupID NOT NULL DBINT Currently not used, set to zero (0). RecoveryDay Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 313 All Tables Network_Trunk_Group_Half_Hour