/mcpRelated Tables Campaign, on page 156 (via CampaignID) Query_Rule, on page 362 (via QueryRuleID) Table 99: Indexes for Campaign_Query_Rule_Real_Time Table index_keys index_description index_name CampaignID, QueryRuleID clustered, unique, primary key located on PRIMARY XPKCampaign_Query_Rule_Real_Time Table 100: Fields in Campaign_Query_Rule_Real_Time Table Keys and NULL Option Data Type Description Name NULL DBINT The number of calls abandoned by the dialer. AbandonDetectCount NULL DBINT (THIS FIELD IS NOT CURRENTLY BEING USED. IT IS RESERVED FOR FUTURE USE.) The number of calls in a five minute period where the dialer abandoned a customer call. AbandonDetectTo5 NULL DBINT (THIS FIELD IS NOT CURRENTLY BEING USED. IT IS RESERVED FOR FUTURE USE.) The number of calls in a half-hour period where the dialer abandoned a customer call. AbandonDetectToHalf NULL DBINT The number of calls that detected an answering machine. AbandonToIVRCount NULL DBINT (THIS FIELD IS NOT CURRENTLY BEING USED. IT IS RESERVED FOR FUTURE USE.) The number of calls in a five minute period that had to be abandoned. However, instead of disconnecting on a customer, the call was transferred to an IVR which played a message to the customer. AbandonToIVRTo5 NULL DBINT (THIS FIELD IS NOT CURRENTLY BEING USED. IT IS RESERVED FOR FUTURE USE.) The number of calls in a half-hour period that had to be abandoned. However, instead of disconnecting 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 that were closed by the agent (these customers will not be dialed). AgentClosedCount Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 176 All Tables Campaign_Query_Rule_Real_Time