Technical References

Keys
and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
The number of consultative calls an agent associated with this skill
group that ended in the half-hour interval. The count is counted when
ConsultativeCallsToHalf
the after-call work time associated with the consultative call (if any)
is completed, and the database is updated every half hour.
PK NOT
NULL
DBSMALLDATE
The date and time at the start of the half-hour interval.
DateTime
IE-1
NULL
DBDATETIME
The current date and time stamp when the records are written to the
HDS database. The logger database has NULL for this column.
DbDateTime
NULLDBINT
During the half-hour interval, the number of emergency assist requests
made either by the agent or by the supervisor.
EmergencyAssistsToHalf
This field is applicable for IPCC Enterprise only.
NULLDBINT
Handle time includes the time spent from the call being answered by
the agent to the time the agent completed after call work time for the
HandledCallsTalkTimeToHalf
call. The value for HandledCallsTime is updated in the database when
the after-call work time associated with the call (if any) has
completed.
This field is applicable for ICM, IPCC Enterprise and Outbound
Option.
NULLDBINT
The time in seconds an agent spent on calls that were handledwithin
the half-hour interval.
HandledCallsTimeToHalf
This field is applicable for ICM, IPCC Enterprise and Outbound
Option.
NULLDBINT
Number of seconds where all calls to the agent are on hold during
the half-hour interval. HoldTime is counted only while the agent is
HoldTimeToHalf
doing no other call-related activity. HoldTime is included in the
calculation of LoggedOnTime.
NULLDBINT
Total number of seconds that inbound ACD calls calls that an agent
associated with this skill group placed on hold that ended during the
IncomingCallsOnHoldTimeToHalf
half-hour interval. 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.
NULLDBINT
The total number of inbound ACD calls that an agent associated with
this skill group placed on hold at least once during the half-hour
IncomingCallsOnHoldToHalf
interval. 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.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
40
Chapter 2: All Tables
Agent_Skill_Group_Half_Hour Table