Cisco Cisco Administrative Workstation Referencia técnica
2-237
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Skill_Group_Five_Minute Table
Related tables:
Skill Group (via SkillTargetID)
TalkTimeTo5
Number of seconds agents in the skill group were
in the Talking state during the five-minute
interval.
in the Talking state during the five-minute
interval.
int
NULL
WorkReadyTimeTo5
Number of seconds agents in the skill group were
in the Work Ready state during the five-minute
interval. WorkReadyTime is included in the
calculation of LoggedOnTime.
in the Work Ready state during the five-minute
interval. WorkReadyTime is included in the
calculation of LoggedOnTime.
int
NULL
WorkNotReadyTimeTo5
Number of seconds agents in the skill group were
in the Work Not Ready state during the
five-minute interval. WorkNotReadyTime is
included in the calculation of LoggedOnTime.
in the Work Not Ready state during the
five-minute interval. WorkNotReadyTime is
included in the calculation of LoggedOnTime.
int
NULL
RecoveryDay
A value used internally by the ICM software to
track virtual time.
track virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to
track virtual time.
track virtual time.
float
AK1, NOT
NULL
NULL
BusyOther
Number of agents in the BusyOther state at the
end of the five-minute interval.
end of the five-minute interval.
int
NULL
BusyOtherTimeTo5
Number of seconds agents spent in the
BusyOther state. BusyOtherTime is included in
the calculation of LoggedOnTime.
BusyOther state. BusyOtherTime is included in
the calculation of LoggedOnTime.
int
NULL
CallsAnsweredTo5
Number of calls answered by agents in the skill
group during the past five minutes. The count for
CallsAnswered is updated in the database at the
time the call is answered.
group during the past five minutes. The count for
CallsAnswered is updated in the database at the
time the call is answered.
int
NULL
ReservedStateTimeTo5
Time agents in the skill group spent in the
Reserved state during the past five minutes.
ReservedStateTime is included in the calculation
of LoggedOnTime.
Reserved state during the past five minutes.
ReservedStateTime is included in the calculation
of LoggedOnTime.
int
NULL
LongestAvailAgent
Time in seconds that the longest available agent
for the skill group has been available.
for the skill group has been available.
int
NULL
Table 2-175 Skill_Group_Five_Minute Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option