Cisco Cisco IP Contact Center Release 4.6.2 Technical References

NULL

varchar(64)

Reserved for future use

FutureUseVarchar1

NULL

varchar(64)

Reserved for future use

FutureUseVarchar2

NULL

varchar(64)

Reserved for future use

FutureUseVarchar3

NOT NULL

DBINT

The percentage of hits (completed/attempted) per campaign considered
as a threshold by the predictive algorithm. The percentage value is a
whole number between 0 and 100.

HitRate

NOT NULL

DBCHAR

Indicates whether or not to use hit rate to move between query rules
within this campaign:

HitRateEnabled

• Y = Use hit rate

• N = Do not use hit rate

NOT NULL

DBINT

The order in which the query rules are to be used.

ListOrder

NOT NULL

DBINT

The percentage of this query rule to be attempted before shifting to the
next query rule within the current campaign. The percentage value is a
whole number between 0 and 100.

Penetration

NOT NULL

DBCHAR

Indicates whether or not to use penetration rate to move between query
rules within this campaign:

PenetrationEnabled

• Y = Use penetration rate

• N = Do not use penetration rate

NOT NULL

DBCHAR

Indicates whether the query rule is enabled or disabled within this
campaign:

QueryRuleEnabled

• Y = Enabled

• N = Disabled

PK, FK NOT NULL

DBINT

The query rule belonging to the campaign identified by the CampaignID.
This field is a foreign key from the Query Rule table.

QueryRuleID

This field is applicable to Outbound Option only.

NOT NULL

DBINT

TThe contact will not be dialed earlier than the StartHours:StartMinutes.
Hours are in 24-hour format and are based on the ICM Central Controller
time.

StartHours

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)