Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
The query rule belonging to the campaign identied by the
CampaignID.
QueryRuleID
This eld is applicable to Outbound Option only.
NULLDBINT
The number of calls that detected a Special Information Tone
(SIT).
SITToneDetectCount
NULLDBINT
The total number of seconds agents spent talking on the telephone
since midnight.
TalkTimeCount
NULLDBINT
The total number of records available to dial for the current
campaign query rule.
TotalCount
NULLDBINT
The number of calls for the day that ended in successful customer
contact.
VoiceCount
Outbound Option: The number of calls that detected a live
person.
NULLDBINT
The number of seconds agents spent in wrap-up mode since
midnight.
WrapupTimeCount
NULLDBINT
The number of calls where the customer phone number was
incorrect.
WrongNumberCount
Campaign_Skill_Group Table
This table is in the Blended Agent category (page 439). To see database rules for these tables,
click here (page 503).
It contains the associations between campaigns and skill groups within the software.
Note: If Outbound Option was not selected during setup, this table will contain no data.
Use the Outbound Option Conguration option within ICM Conguration Manager to modify
Campaign_Skill_Group records.
Related tables
Campaign (page 125) (via CampaignID)
Skill_Group (page 364) (SkillGroupID maps to Skill_Group.SkillTargetID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
139
Chapter 2: All Tables
Campaign_Skill_Group Table