McDewey

Keys and NULL Option Data Type Description Name NOT NULL DBCHAR Valid options are: • Y = Allow dialing to work numbers. • N = Do not allow dialing to work numbers. WorkEnabled NOT NULL DBINT Work phone numbers will not be dialed later than WorkEndHours:WorkEndMinutes. Hours are in 24-hour format. WorkEndHours NOT NULL DBINT Work phone numbers will not be dialed later than WorkEndHours:WorkEndMinutes. WorkEndMinutes NOT NULL DBINT Work phone numbers will be dialed no earlier than WorkStartHours:WorkStartMinutes. Hours are in 24-hour format. WorkStartHours NOT NULL DBINT Work phone numbers will be dialed no earlier than WorkStartHours:WorkStartMinutes. WorkStartMinutes NULL varchar (128) Displays the campaign time zone TZDisplayName Campaign_Half_Hour THIS TABLE IS NOT CURRENTLY BEING USED. IT IS RESERVED FOR FUTURE USE. Note This table is in the Blended Agent category (seeBlended Agent (Outbound Option), on page 616). For information about 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 campaign attributes. Related Tables Campaign, on page 156 (via CampaignID) Table 92: Indexes for Campaign_Half_Hour Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Campaign_Half_Hour DbDateTime Nonclustered located on PRIMARY XIE1Campaign_Half_Hour CampaignID, DateTime, TimeZone Clustered, unique primary key located on PRIMARY XPKCampaign_Half_Hour Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 165 All Tables Campaign_Half_Hour