Technical References

Keys
and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Number of seconds agents spent talking on other calls (neither inbound
nor outbound) during the half-hour interval. Examples of “other calls
TalkOtherTimeToHalf
include agent-to-agent transfers and supervisor calls. TalkOtherTime
is included in the calculation of TalkTime and LoggedOnTime.
NULLDBINT
Number of seconds agents associated with this skill group spent
talking on external outbound or consultive transfer calls during the
TalkOutTimeToHalf
half-hour interval. TalkOutTime is included in the calculation of
TalkTime and LoggedOnTime.
NULLDBINT
Number of seconds the agent spent talking on outbound Preview calls
during the half-hour interval. TalkAutoOutTimeToHalf is included
in the calculation of LoggedOnTimeToHalf.
TalkPreviewTimeToHalf
NULLDBINT
Number of seconds the agent spent talking on agent reservation calls
during the half-hour interval. TalkReserveTimeToHalf is included in
the calculation of LoggedOnTimeToHalf.
TalkReserveTimeToHalf
NULLDBINT
Total seconds agents associated with this skill group were in the
Talking state during the half-hour interval.
TalkTimeToHalf
This value is based on the following:
• TalkInTimeToHalf
• TalkOutTimeToHalf
• TalkOtherTimeToHalf
• TalkAutoOutTime
• TalkPreviewTime
• TalkReservedTime
PK NOT
NULL
DBINT
The time zone for the date and time. The value is the offset in minutes
from UTC (formerly called GMT).
TimeZone
NULLDBINT
Number of seconds agents associated with this skill group spent
handling transferred in calls that ended during this half-hour interval.
TransferInCallsTimeToHalf
The value is counted when the after-call work time associated with
the call (if any) is completed, and the database is updated every half
hour.
Note: Note: For blind transfers in IPCC Enterprise with an IPCC
System PG, this field is updated when the call that was blind
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
390
Chapter 2: All Tables
Skill_Group_Half_Hour Table