Technical References

Keys
and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Number of seconds that an agent in the skill group spent talking on
other calls (neither inbound or outbound) during the half-hour interval.
TalkOtherTimeToHalf
Examples: agent-to-agent transfers and supervisor calls.
TalkOtherTime is included in the calculation of TalkTime and
LoggedOnTime.
NULLDBINT
Number of seconds an agent 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
The number of seconds the agent spent talking on outbound Preview
calls during the half-hour interval. TalkPreviewTime is included in
the calculation of LoggedOnTime.
TalkPreviewTimeToHalf
NULLDBINT
This is how long an agent is in Talking state since the reservation
call is connected to the agent. This is counted using Agent State.
TalkReserveTimeToHalf
PK NOT
NULL
DBINT
The time zone for the date and time. The value is the offset in minutes
from GMT.
TimeZone
NULLDBINT
Number of seconds an agent associated with this skill group spent
handling transferred in calls that ended during the half-hour interval.
TransferredInCallsTimeToHalf
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
transferred to an IVR is subsequently transferred to another agent
and the agent answers the call. For this call scenario this field is not
updated in IPCC Enterprise without an IPCC System PG.
NULLDBINT
Number of calls transferred into the skill group during the half-hour
interval. The value is counted when the after-call work time associated
TransferredInCallsToHalf
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
transferred to an IVR is subsequently transferred to another agent
and the agent answers the call. For this call scenario this field is not
updated in IPCC Enterprise without an IPCC System PG.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
46
Chapter 2: All Tables
Agent_Skill_Group_Half_Hour Table