Cisco Cisco E-Mail Manager Unity Integration Option 技术参考
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
SkillTargetID
TimeZone
AK-1
RecoveryKey
FK
SkillTargetID
Table 2-358 Skill_Group_Five_Minute Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
Avail
Number of agents in group in the Available state at
the end of the five-minute interval.
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.
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.
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.
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.
Enterprise.
DBINT
NULL