Technical References

Skill_Group_Five_Minute Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
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
Skill Group (page 364) (via SkillTargetID)
Table 196: Indexes for Skill_Group_Five_Minute Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Skill_Group_Five_Minute
DateTime, SkillTargetID, TimeZoneclustered, unique, primary key
located on PRIMARY
XPKSkill_Group_Five_Minute
Fields in Skill_Group_Five_Minute Table:
Keys and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Number of agents in group in the Available state at the end of the
five-minute interval.
Avail
NULLDBINT
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.
AvailTimeTo5
NULLDBINT
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
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.
NULLDBINT
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
AvgHandledCallsTimeTo5
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
368
Chapter 2: All Tables
Skill_Group_Five_Minute Table