/mcpTable 457: Fields in Trunk_Group_Half_Hour Table Keys and NULL Option Data Type Description Name NULL DBINT Total time, in seconds, during the half-hour interval that all trunks in the group were busy. AllTrunksBusyToHalf NULL DBINT Number of calls to the trunk group abandoned during the current half-hour interval. CallsAbandonedToHalf NULL DBINT Number of incoming calls received on the trunk group during the half-hour interval. CallsInToHalf NULL DBINT Number of outbound calls sent on the trunk group during the half-hour interval. CallsOutToHalf PK NOT NULL DBSMALLDATE Central Controller 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 used for inbound calls during the half-hour interval. InUseInboundTimeToHalf NULL DBINT Aggregate number of seconds trunks in the group were used for outbound calls during the half-hour interval. InUseOutboundTimeToHalf NOT NULL DBINT Currently not used, set to zero (0). RecoveryDay AK-1 NOT NULL DBFLT8 A unique ID assigned to each record and used internally by the Unified CCE software to track the record. RecoveryKey PK NOT NULL DBINT The Central Controller’s time zone for the date and time. The value is the offset in minutes from UTC (formerly GMT).The value is negative for time zones to the east of UTC and positive for time zones to the west of UTC. TimeZone PK, FK NOT NULL DBINT Foreign key from the Trunk Group table. TrunkGroupID NULL DBINT Number of non-busy trunks in the group at the end of the half-hour interval. TrunksIdle Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 595 All Tables Trunk_Group_Half_Hour