/mcpKeys and NULL Option Data Type Description Name PK, FK NOT NULL DBINT The query rule belonging to the campaign identified by the CampaignID. This field is applicable to Outbound Option only. QueryRuleID AK-1 NOT NULL DBFLT8 Unique identity that is assigned to each record and used internally by Unified CC Enterprise to track the record. RecoveryKey NULL DBINT The number of calls in a half-hour period that detected a network SIT tone. SITToneDetectToHalf NULL DBINT The total number of seconds agents spent talking on the phone during the last half-hour. TalkTimeToHalf 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 NULL DBINT The total number of calls ending in an agent answering the call during the last half-hour. Outbound Option: The number of calls in a half-hour period that detected a live person. VoiceDetectToHalf NULL DBINT The total number of seconds agents spent in wrap-up mode during the last half-hour. WrapupTimeToHalf NULL DBINT The number of calls where the customer's phone number was incorrect (the customer does not live there). WrongNumberCountToHalf Campaign_Query_Rule_Interval This section describes the Campaign Query Rule Interval table. Table 98: Fields in Campaign_Query_Rule_Interval Table Keys and NULL Option Data Type Description Name NULL DBINT The number of calls in a reporting interval period where the dialer abandoned a customer call. AbandonDetect Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 172 All Tables Campaign_Query_Rule_Interval