/mcpindex_keys index_description index_name DateTime, PhysicalControllerID, TimeZone clustered, unique, primary key located on PRIMARY XPKPhysical_Controller_Half_Ho Table 296: Fields in Physical_Controller_Half_Hour Table Keys and NULL Option Data Type Description Name NULL DBINT Number of seconds the Peripheral Gateway's Agent process maintained an active connection to the Side A CallRouter. ActivePGAgentSideATimeToHalf NULL DBINT Number of seconds the Peripheral Gateway's Agent process maintained an active connection to the Side B CallRouter. ActivePGAgentSideBTimeToHalf 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 Number of seconds the Peripheral Gateway's Device Management Protocol connection to the CallRouter was in service. DMPInServiceTimeToHalf PK, FK NOT NULL DBSMALLINT Unique identifier for this physical controller. PhysicalControllerID 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 Physical_Interface_Controller This table is in the Device category (see Device, on page 618). To see database rules for these tables, see Device Tables, on page 698. Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 344 All Tables Physical_Interface_Controller