Cisco Cisco IPCC Web Option Technical References

2-104

Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)

Chapter 2 Table Details

Campaign_Skill_Group Table

Contains the associations between campaigns and skill groups within the ICM software.

Use the Outbound Option Configuration option within ICM Configuration Manager to modify
Campaign_Skill_Group records.

Table 2-74

Campaign_Skill_Group Table Constraints

Constraint

Field Name(s)

CampaignID
SkillTargetID

Table 2-75 Campaign_Skill_Group Table

Field Name

Description

Data Type

Keys and
Null Option

AbandonedRoutePoint

Abandoned Contacts are transferred to this route
point, which points to an IVR.

varchar(50)

NULL

AutotAnswerReservationCall

Indicates whether the dialer will use CTI Server to
answer the reservation call sent to the agent or
allow the agent’s phone to answer the call on its
own:

1 = Auto answer on.
2 = Auto-answer off.

DBINT

NULL

CampaignID

The campaign to which this target group belongs.
Foreign key from the Campaign table.

This field is applicable to Outbound Option
only.

DBINT

PK, FK

NOT NULL

ConfigParam

Additional configuration parameters.

varchar(255)

NULL

IVRPorts

Number of ports supported by the IVR for the
current skill group (3 digits).

DBINT

NOT NULL

IVRRoutePoint

Contacts are transferred to this route point, which
points to an IVR.

varchar(50)

NULL

OverflowAgents

The number of agents per skill group to ignore
during predictive dialer calculations.

DBINT

NOT NULL

PredictiveDN

The Dialed Number to dial for predictive numbers. varchar(32)

NULL

PreviewDN

The Dialed Number to dial for preview numbers.

varchar(32)

NULL

RecordsToCache

The number of records that should be cached by
the dialer for a specific campaign-skill group
combination.

DBINT

NOT NULL