/mcpTable 52: Indexes for Application_Gateway_Half_Hour Table index_keys index_description index_name ApplicationGatewayID, DateTime, TimeZone Primary key XPKApplication_Gateway_Half_Ho RecoveryKey Unique key XAK1Application_Gateway_Half_H DbDateTime Inversion key XIE1Application_Gateway_Half_H Table 53: Fields in Application_Gateway_Half_Hour Table Keys and NULL Option Data Type Description Name PK, FK NOT NULL DBINT Identifies the Application Gateway. ApplicationGatewayID NULL DBINT The average delay during the half-hour period (AvgDelayToHalf) is derived by dividing the total delay by the total number of requests during every half-hour interval. TotalDelay is calculated by the router internally in milliseconds, for all requests to the Application Gateway. If RequestsToHalf is higher than TotalDelay during half-hour interval, then this value will be zero. AvgDelayToHalf=TotalDelay/RequestsToHalf AvgDelayToHalf PK NOT NULL DBSMALLDATE The Central Controller date and time at the start of the 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 errors that occurred for Application Gateway requests during the half-hour interval. Consult EMS logs for specific error information. ErrorsToHalf NULL DBINT Number of responses that exceeded the LateTimeout value for the connection during the half-hour interval. LatesToHalf NULL DBINT The longest response time, in milliseconds, for any request to the Application Gateway during the half-hour interval. MaxDelayToHalf Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 90 All Tables Application_Gateway_Half_Hour