/mcpDialer, on page 220 (via DialerID) Table 166: Indexes for Dialer_Half_Hour Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Dialer_Half_Hour DbDateTime Nonclustered located on PRIMARY XIE1Dialer_Half_Hour DateTime, DialerID, TimeZone Clustered, unique, primary key located on PRIMARY XPKDialer_Half_Hour The Dialer_Interval Table will be populate with 30/15 minute reporting data, depending on the Historical Reporting Interval setting for the PG. The Dialer_Half_Hour Table will not be populated with this data. Note Table 167: Fields in Dialer_Half_Hour Table Keys and NULL Option Data Type Description Name NULL DBINT The number of calls made during the half hour interval that were abandoned. AbandonDetectToHalf NULL DBINT The number of calls in a half-hour period that had to be abandoned. However, instead of disconnecting the call on a customer, the call was transferred to an IVR which played a message to the customer. AbandonToIVRToHalf NULL DBINT The number of preview/callback calls in a half-hour period that were rejected by the agent (these customers will not be dialed). AgentClosedDetectToHalf NULL DBINT The number of preview/callback calls in a half-hour period that were rejected by the agent. AgentRejectedDetectToHalf NULL DBINT Reserved for future use. AllPortsBusyCountToHalf NULL DBINT The number of calls made during the half hour interval in which an answering machines was detected. AnsweringMachineDetectToHalf NULL DBINT The number of calls in the half-hour period that detected a busy signal. BusyDetectToHalf NULL DBINT The total number of records scheduled for a callback. CallbackCountToHalf NULL DBINT The number of calls in a half-hour period that were dropped while ringing the customer's telephone. CancelledDetectToHalf Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 232 All Tables Dialer_Half_Hour