Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Skill_Group_Five_Minute Table
This table is in the
. To see database rules for these tables, click
Central database only.
Contains statistics about each skill group during the five-minute interval.
The ICM generates Skill_Group_Five_Minute records for each skill group.
Related table
(via SkillTargetID)
Table 195: Indexes for Skill_Group_Five_Minute Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Skill_Group_Five_Minute
DateTime, SkillTargetID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKSkill_Group_Five_Minute
Fields in Skill_Group_Five_Minute Table:
Keys and
Null
Option:
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of agents in group in the Available state at
the end of the five-minute interval.
the end of the five-minute interval.
Avail
NULL
DBINT
The total time, in seconds, that agents in the skill
group were in the Available state for any skill group
group were in the Available state for any skill group
AvailTimeTo5
during the five-minute interval. AvailTime is
included in the calculation of LoggedOnTime.
included in the calculation of LoggedOnTime.
NULL
DBINT
Average talk time in seconds for calls counted as
handled by the skill group during the five-minute
handled by the skill group during the five-minute
AvgHandledCallsTalkTimeTo5
window. This value is calculated as follows:
HandledCallsTalkTimeTo5 / CallsHandledTo5
AvgHandledCallsTalkTime is calculated only for
handled calls, which are calls that are finished (that
is, any after-call work associated with the call has
been completed). This field is updated in the
database when any after-call work associated with
the call is completed.
HandledCallsTalkTimeTo5 / CallsHandledTo5
AvgHandledCallsTalkTime is calculated only for
handled calls, which are calls that are finished (that
is, any after-call work associated with the call has
been completed). This field is updated in the
database when any after-call work associated with
the call is completed.
NULL
DBINT
Average talk time in seconds for calls counted as
handled by the skill group during the five-minute
handled by the skill group during the five-minute
AvgHandledCallsTimeTo5
window. This value is calculated as follows:
HandledCallsTalkTimeTo5 / CallsHandledTo5
HandledCallsTalkTimeTo5 / CallsHandledTo5
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
317
Chapter 2: All Tables
Skill_Group_Five_Minute Table