/mcpKeys and NULL Option Data Type Description Name 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 five-minute interval. TrunksIdle NULL DBINT Number of trunks in this trunk group in service at the end of the five-minute interval. TrunksInService Trunk_Group_Half_Hour This is in the Device category (see Device, on page 618). For database rules, see Device Tables, on page 698. It gets populated on central and HDS databases. This table contains information about a trunk group collected during each 30-minute interval. The system software generates Trunk_Group_Half_Hour records for each trunk group. Related Table Trunk_Group, on page 591 (via TrunkGroupID) Table 456: Indexes for Trunk_Group_Half_Hour Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Trunk_Group_Half_Hour DbDateTime Nonclustered located on PRIMARY XIE1Trunk_Group_Half_Hour DateTime, TrunkGroupID, TimeZone Clustered, unique, primary key located on PRIMARY XPKTrunk_Group_Half_Hour Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 594 All Tables Trunk_Group_Half_Hour