Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-59
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Campaign_Query_Rule_Real_Time
Related tables:
Campaign (via CampaignID)
Query_Rule (via QueryRuleID)
Campaign_Query_Rule_Real_Time
Local database only.
Each row provides real-time statistics on a particular Campaign-Query Rule combination. The statistics
reflect counters used in the Blended Agent predictive dialing algorithm.
reflect counters used in the Blended Agent predictive dialing algorithm.
LinesPerAgent
Average number of lines being dialed per agent during the
last half hour.
last half hour.
float
NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NULL
Table 2-34 Campaign_Query_Rule_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-35 Campaign_Query_Rule_Real_Time Table
Field Name
Description
Data Type
Keys and Null
Option
Option
CampaignID
The campaign to which this query rule belongs.
int
PK, FK, NOT
NULL
NULL
QueryRuleID
The query rule belonging to the campaign identified by
the CampaignID.
the CampaignID.
int
PK, FK, NOT
NULL
NULL
DateTime
The ICM Central Controller date and time at which this
data was last updated.
data was last updated.
datetime
NOT NULL
AttemptedCount
The number of attempted calls so far today.
int
NULL
ContactedCount
The number of calls for the day that ended in successful
customer contact.
customer contact.
int
NULL
TalkTimeCount
The total number of seconds agents spent talking on the
telephone today.
telephone today.
int
NULL
WrapupTimeCount
The number of seconds agents spent in wrap-up mode
today.
today.
int
NULL
CallBackCount
The total number of records scheduled for a callback
today.
today.
int
NULL
TotalCount
The total number of records available to dial for the
current campaign query rule.
current campaign query rule.
int
NULL