Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NULLvarchar(64)
Reserved for future use
FutureUseVarchar2
NULLvarchar(64)
Reserved for future use
FutureUseVarchar3
NOT NULLDBINT
Number of ports supported by the IVR for the current skill group
(3 digits).
IVRPorts
NULLvarchar(50)
Contacts are transferred to this route point, which points to an IVR.
IVRRoutePoint
NOT NULLDBINT
The number of agents per skill group to ignore during predictive
dialer calculations.
OverowAgents
NOT NULLDBINT
The number of records that should be cached by the dialer for a
specic campaign-skill group combination.
RecordsToCache
NULLDBINT
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.
ReservationPercentage
PK, FK NOT NULLDBINT
A unique key indicating the skill group with which this target group
is associated. Foreign key to the Skill Group table.
SkillTargetID
Campaign_Target_Sequence 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 target type (home or work) and the sequence with which numbers are dialed
within a campaign.
Note: If Outbound Option was not selected during setup, this table will contain no data.
Related tables
Campaign (page 125) (via CampaignID)
Dialer Detail (page 163) (via Phone Index)
Table 56: Indexes for Campaign_Target_Sequence Table
index_keysindex_descriptionindex_name
CampaignID, SequenceNumberclustered, unique, primary key
located on PRIMARY
XPKCampaign_Target_Sequence
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
141
Chapter 2: All Tables
Campaign_Target_Sequence Table