Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
can be a network based IVR, or a network based answering
service.
NULLDBINT
The number of calls in a half-hour period that were not
answered.
NoAnswerDetectToHalf
NULLDBINT
The number of calls in a half-hour period that did not receive
a dial tone.
NoDialToneDetectToHalf
NULLDBINT
The number of calls in the current half hour period that did not
receive a ring-back tone, that were disconnected by the carrier
NoRingBackDetectToHalf
or the network while ringing, or that were flagged with a data
error or a no-value call.
NULLDBINT
The number of calls where the customer requested a personal
callback.
PersonalCallbackCountToHalf
PK, FK NOT
NULL
DBINT
The query rule belonging to the campaign identified by the
CampaignID.
QueryRuleID
This field is applicable to Outbound Option only.
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NULLDBINT
The number of calls in a half-hour period that detected a
network SIT tone.
SITToneDetectToHalf
NULLDBINT
The total number of seconds agents spent talking on the phone
during the last half-hour.
TalkTimeToHalf
PK NOT NULLDBINT
The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
NULLDBINT
The total number of calls ending in an agent answering the call
during the last half-hour.
VoiceDetectToHalf
Outbound Option: The number of calls in a half-hour period
that detected a live person.
NULLDBINT
The total number of seconds agents spent in wrap-up mode
during the last half-hour.
WrapupTimeToHalf
NULLDBINT
The number of calls where the customer’s phone number was
incorrect (the e. customer did not live there).
WrongNumberCountToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
136
Chapter 2: All Tables
Campaign_Query_Rule_Half_Hour Table