Technical References

Keys
and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Total handle time, in seconds, for Outbound Preview calls handled
by an agent associated with this skill group that ended during the
PreviewCallsTimeToHalf
half-hour interval. Handle time includes WorkTime, TalkTime, and
HoldTime. The PreviewCallsTime value includes the time spent from
the call being initiated to the time the agent completes after-call work
time for the call. The value is counted when the after-call work time
associated with the call (if any) has completed, and the database is
updated every half hour.
NULLDBINT
Total number of outbound Preview calls made by an agent associated
with this skill group that ended during the half-hour interval. The
PreviewCallsToHalf
value is counted when the after-call work time associated with the
call (if any) has completed, and the database is updated every half
hour.
AK-1
NOT
NULL
DBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NULLDBINT
During the half-hour interval, the number of seconds ACD calls to
the skill group rang at an agent's terminal before being redirected on
RedirectNoAnsCallsTimeToHalf
failure to answer. The value is counted at the time the call is diverted
to another device, and the database is updated every half hour.
NULLDBINT
During the half-hour interval, the number of ACD calls to the skill
group that rang at an agent's terminal and redirected on failure to
RedirectNoAnsCallsToHalf
answer. The value is counted at the time the call is diverted to another
device, and the database is updated every half hour.
NULLDBINT
The time the reservation call has been on hold during the half-hour
interval.
ReserveCallsOnHoldTimeToHalf
NULLDBINT
The total number of reservation calls placed on hold at least once
during the half-hour interval.
ReserveCallsOnHoldToHalf
NULLDBINT
This is the talk time for the reservation call. It should be either zero
or a few seconds. This is counted using Call State.
ReserveCallsTalkTimeToHalf
NULLDBINT
This is the sum of the above two columns. This is counted using Call
State.
ReserveCallsTimeToHalf
NULLDBINT
Number of reservation calls. This should always equal to the
ReserveCallsOnHoldToHalf.
ReserveCallsToHalf
NULLDBINT
Reserved for future use.
Reserved1
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
44
Chapter 2: All Tables
Agent_Skill_Group_Half_Hour Table