Storage
Description
Field Name
smallint
NOT NULL
The type of the dialer used for the campaign. The
dialer can be any one of the following three types
- Predictive, Progressive or Preview Outbound.
0 - Direct Preview Dialer
1 - IVR based Predictive Dialer
2 - IVR based Progressive Dialer
Default value = 0
dialertype
smallint
NOT NULL
The campaign type can be IVR-based or
ICD-based.
0 - IVR based campaign
1 - Agent based campaign
Default value = 1
campaignType
Related Topics
CampaignCSQMap, on page 20
ContactCallDetail, on page 34
ProfileIDMapping, on page 75
DialingList , on page 61
CampaignCSQMap
Database table name: CampaignCSQMap
The CampaignCSQMap table shows the relationship between campaigns and contact service queues (CSQs).
A new record is created in the CampaignCSQMap table when a campaign is associated with a CSQ in Unified
CCX Administration.
Table 13: CampaignCSQMap Table Fields
Storage
Description
Field Name
int
NOT NULL
Primary Key
A unique identifier for the record
recordid
int
NOT NULL
Primary Key
A unique identifier for the campaign, from the
Campaign table.
campaignid
int
NOT NULL
Primary Key
A unique identifier for the CSQ, from the
ContactServiceQueue table.
csqid
Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1
20
Database Schema
CampaignCSQMap
