Technical References

Keys
and
Null
Option:
Data Type:Description:Field Name:
counted when the agent drops off the call or the call becomes a simple
two-party call, and the database is updated every half hour.
Note: Note: For blind conferences in IPCC Enterprise with an IPCC
System PG, this field is updated when the call that was blind
conferenced to an IVR is subsequently answered by another agent.
For this call scenario this field is not updated in IPCC Enterprise
without an IPCC System PG.
NULLDBINT
The number of seconds that agents spent on conference calls that they
initiated. This includes time spent on both ACD and non-ACD
ConferencedOutCallsTimeToHalf
conference calls initiated by the agent. The value is counted when the
agent drops off the call or the call becomes a simple two-party call,
and the database is updated every half hour.
NULLDBINT
The number of conference calls that the skill group agents initiated.
The conferenced out calls include ACD and non-ACD calls. The value
ConferencedOutCallsToHalf
is counted when the agent drops off the call or the call becomes a
simple two-party call, and the database is updated every half hour.
NULLDBINT
The number of seconds agents associated with this skill group spent
handling a consultative call. The value is counted when the after-call
ConsultativeCallsTimeToHalf
work time associated with the consultative call (if any) is completed,
and the database is updated every half hour.
NULLDBINT
The number of consultative calls agents associated with the skill group
that ended in this half-hour. The count is counted when the after-call
ConsultativeCallsToHalf
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
The number of emergency assist requests either by the agent or by
the supervisor.
EmergencyAssistsToHalf
This field is applicable for IPCC Enterprise only.
NULLDBINT
The number of seconds that agents spent in TalkTime for calls
associated with this skill group that ended in this half-hour interval.
HandledCallsTalkTimeToHalf
This field is applicable for both ICM, IPCC Enterprise and
Outbound Option.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
378
Chapter 2: All Tables
Skill_Group_Half_Hour Table