Cisco Cisco IP Contact Center Release 4.6.2 Technical References
Skill_Group_Five_Minute Table
. 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 196: 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.
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 during the five-minute interval.
AvailTime is included in the calculation of LoggedOnTime.
Available state for any skill group during the five-minute interval.
AvailTime is included in the calculation of LoggedOnTime.
AvailTimeTo5
NULL
DBINT
Average talk time in seconds for calls counted as handled by the
skill group during the five-minute window. This value is calculated
as follows: HandledCallsTalkTimeTo5 / CallsHandledTo5
skill group during the five-minute window. This value is calculated
as follows: HandledCallsTalkTimeTo5 / CallsHandledTo5
AvgHandledCallsTalkTimeTo5
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.
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 window. This value is calculated
as follows: HandledCallsTalkTimeTo5 / CallsHandledTo5
skill group during the five-minute window. This value is calculated
as follows: HandledCallsTalkTimeTo5 / CallsHandledTo5
AvgHandledCallsTimeTo5
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
368
Chapter 2: All Tables
Skill_Group_Five_Minute Table