/mcpRelated Tables Campaign_Skill_Group, on page 184 (via CampaignID) Campaign_Target_Sequence, on page 186 (via CampaignID) Campaign_Query_Rule, on page 166 (via CampaignID) Campaign_Half_Hour, on page 165 (via CampaignID) Campaign_Query_Rule_Half_Hour, on page 169 Campaign_Query_Rule_Real_Time, on page 175 (via CampaignID) Dialer_Detail, on page 225 (via CampaignID) Dialer_Port_Real_Time, on page 238 (via CampaignID) Dialer_Skill_Group_Real_Time, on page 247 (via CampaignID) Table 90: Indexes for Campaign Table index_keys index_description index_name CampaignName nonclustered, unique, unique key located on PRIMARY XAK1Campaign CampaignID clustered, unique primary key located on PRIMARY XPKCampaign Table 91: Fields in Campaign Table Keys and NULL Option Data Type Description Name NOT NULL DBINT Indicates which of the following AMD modes are enabled for agent campaigns: 1. Abandon Call. 2. Transfer to Agent. 3. Transfer to IVR Route Point. 4. IVR Mode Abandon call. 5. IVR Mode Transfer to IVR Route Point. AMDTreatmentMode NOT NULL DBCHAR Identifies whether this campaign was created using the Outbound API: • Y = campaign created using the API. • N = campaign created using the Outbound Option Campaign tool in the ICM Configuration Manager. APIGenerated Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 157 All Tables Campaign