Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 548
   
2-357
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Skill_Group_Five_Minute Table
Skill_Group_Five_Minute Table
Central database only.
Contains statistics about each skill group during the last five-minute interval.
The ICM generates Skill_Group_Five_Minute records for each skill group.
Table 2-357 Skill_Group_Five_Minute Table Constraints
Constraint
Field Name(s)
PK
DateTime
SkillTargetID
TimeZone
AK-1
RecoveryKey
FK
SkillTargetID
Table 2-358 Skill_Group_Five_Minute Table
Field Name
Description
Data Type
Keys and 
Null Option
Avail
Number of agents in group in the Available state at 
the end of the five-minute interval.
DBINT
NULL
AvailTimeTo5
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.
This field is applicable for both ICM and IPCC 
Enterprise.
DBINT
NULL
AvgHandledCallsTalkTimeTo5
Average talk time in seconds for calls counted as 
 by the skill group during the five-minute 
interval. 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.
This field is applicable for both ICM and IPCC 
Enterprise.
DBINT
NULL