Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.1
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Download
Page of 404
 
2-60
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Campaign_Skill_Group Table
Related tables:
Campaign (via CampaignID)
Query_Rule (via QueryRuleID)
Campaign_Skill_Group Table  
Contains the associations between campaigns and skill groups within the ICM software.
Use the Blended Agent Configuration option within ICM Configuration Manager to modify 
Campaign_Skill_Group records.
Related tables:
Campaign (via CampaignID)
Skill_Group (SkillGroupID maps to Skill_Group.SkillTargetID)
Table 2-36 Campaign_Skill_Group Table
Field Name
Description
Data Type
Keys and Null 
Option
CampaignID
The campaign to which this target group belongs. 
Foreign key from the Campaign table.
int
PK, NOT NULL
SkillTargetID
A unique key indicating the skill group with which 
this target group is associated. Foreign key to the Skill 
Group table.
int
PK, FK, NOT 
NULL
OverflowAgents
The number of agents per skill group to ignore during 
predictive dialer calculations.
int
NOT NULL
ReservationPercentage
The percentage of agents to reserve within this skill 
group. The variable is only relevant in preview mode. 
For all other modes, 100 percent of agents are 
reserved.
int
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.
int
NULL
SkillTargetIDPredictive
The skill group that will be used to reserve predictive 
agents.
int
NULL
SkillTargetIDPreview
The skill group that will be used to reserve preview 
agents.
int
NOT NULL
RecordsToCache
The number of records that should be cached by the 
dialer for a specific campaign-skill group 
combination.
int
NOT NULL