Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-358
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Skill_Group_Five_Minute Table
AvgHandledCallsTimeTo5
The average talk time in seconds for calls counted
as
as
five-minute interval. This value is calculated as
follows:
follows:
HandledCallsTimeTo5 / CallsHandledTo5
The AvgHandledCallsTime value is updated in the
database when any after-call work time associated
with the call is completed.
database when any after-call work time associated
with the call is completed.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
BusyOther
Number of agents in the BusyOther state at the end
of the five-minute interval.
of the five-minute interval.
DBINT
NULL
BusyOtherTimeTo5
Number of seconds agents spent in the BusyOther
state. BusyOtherTime is included in the
calculation of LoggedOnTime.
state. BusyOtherTime is included in the
calculation of LoggedOnTime.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
CallsAnsweredTo5
Number of calls answered by agents in the skill
group during the past five minutes. The count for
CallsAnswered is updated at the time the call is
answered.
group during the past five minutes. The count for
CallsAnswered is updated at the time the call is
answered.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
CallsHandledTo5
Calls that by been answered and have completed
wrap-up by the skill group during the five-minute
interval.
wrap-up by the skill group during the five-minute
interval.
This field is applicable for both ICM, IPCC
Enterprise and Outbound Option.
Enterprise and Outbound Option.
A handled call is:
•
An incoming ACD call that was answered by
an agent, and then completed.
an agent, and then completed.
•
A call associated with Outbound Option that
the agent answered, and then completed.
the agent answered, and then completed.
•
A non-voice task that the agent started
working on then completed.
working on then completed.
A handled call/task is completed when the agent
associated with the call/task finishes the wrap-up
work associated with the call/task.
associated with the call/task finishes the wrap-up
work associated with the call/task.
DBINT
NULL
DateTime
Central Controller date and time at the start of the
five-minute interval.
five-minute interval.
DBSMALLDATE
PK
NOT NULL
Table 2-358 Skill_Group_Five_Minute Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option