Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
varchar(64)
Reserved for future use
FutureUseVarchar2
NULL
varchar(64)
Reserved for future use
FutureUseVarchar3
NOT NULL
DBINT
Number of ports supported by the IVR for the current skill group
(3 digits).
(3 digits).
IVRPorts
NULL
varchar(50)
Contacts are transferred to this route point, which points to an IVR.
IVRRoutePoint
NOT NULL
DBINT
The number of agents per skill group to ignore during predictive
dialer calculations.
dialer calculations.
OverflowAgents
NOT NULL
DBINT
The number of records that should be cached by the dialer for a
specific campaign-skill group combination.
specific campaign-skill group combination.
RecordsToCache
NULL
DBINT
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.
variable is only relevant in preview mode. For all other modes, 100
percent of agents are reserved.
ReservationPercentage
PK, FK NOT NULL
DBINT
A unique key indicating the skill group with which this target group
is associated. Foreign key to the Skill Group table.
is associated. Foreign key to the Skill Group table.
SkillTargetID
Campaign_Target_Sequence Table
This table is in the
. To see database rules for these tables,
click
It contains the target type (home or work) and the sequence with which numbers are dialed
within a campaign.
within a campaign.
Note: If Outbound Option was not selected during setup, this table will contain no data.
Related tables
(via CampaignID)
(via Phone Index)
Table 56: Indexes for Campaign_Target_Sequence Table
index_keys
index_description
index_name
CampaignID, SequenceNumber
clustered, unique, primary key
located on PRIMARY
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