McDewey

Keys and NULL Option Data Type Description Name NULL DBINT The number of calls where the phone number was incorrect (the customer did not live there). WrongNumberCount Dialer_Skill_Group_Half_Hour THIS TABLE IS NOT CURRENTLY BEING USED. IT IS RESERVED FOR FUTURE USE. Note This table is in the Blended Agent category (see Blended Agent (Outbound Option), on page 616). To see database rules for these tables, see Blended Agent Tables (Outbound Option), on page 695. It gets populated on central and HDS databases and provides historical reporting for campaigns running on a dialer. Each skill group maps to a campaign. This is similar to the dump alloc provided in the dialer traces. Related Tables Dialer, on page 220 (via DialerID) Skill_Group, on page 493 (via SkillGroupSkillTargetID) Table 175: Indexes for Dialer_Skill_Group_Half_Hour Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Dialer_Skill_Group_Half_Hour DbDateTime Nonclustered located on PRIMARY XIE1Dialer_Skill_Group_Half_Hour DialerID, DateTime, SkillGroupSkillTargetID, TimeZone Clustered, unique primary key located on PRIMARY XPKDialer_Skill_Group_Half_Hour Table 176: Fields in Dialer_Skill_Group_Half_Hour Table Keys and NULL Option Data Type Description Name NULL DBINT The number of calls in a half-hour period where the dialer abandoned a customer call. 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 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 244 All Tables Dialer_Skill_Group_Half_Hour