Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-235
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Skill_Group_Five_Minute Table
Skill Target (via SkillTargetID)
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-175 Skill_Group_Five_Minute Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
Central Controller date and time at the start of the
five-minute interval.
five-minute interval.
smalldatetime
PK, NOT NULL
SkillTargetID
Foreign key from skill group table.
int
PK, FK, NOT
NULL
NULL
TimeZone
The time zone for the date and time. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
int
PK, NOT NULL
LoggedOn
Number of agents in the skill group logged on at
the end of the five-minute interval.
the end of the five-minute interval.
int
NULL
Avail
Number of agents in group in the Available state
at the end of the five-minute interval.
at the end of the five-minute interval.
int
NULL
Ready
Number of agents in the skill group in the Ready
state at the end of the five-minute interval.
state at the end of the five-minute interval.
int
NULL
NotReady
Number of agents in the skill group in the Not
Ready state at the end of the five-minute interval.
Ready state at the end of the five-minute interval.
int
NULL
TalkingIn
Number of agents in the skill group talking on
inbound calls at the end of the five-minute
interval. Inbound calls are ACD calls arriving on
trunks (that is, calls that are not internally
generated).
inbound calls at the end of the five-minute
interval. Inbound calls are ACD calls arriving on
trunks (that is, calls that are not internally
generated).
int
NULL
TalkingOut
Number of agents in the skill group talking on
outbound calls at the end of the five-minute
interval.
outbound calls at the end of the five-minute
interval.
int
NULL
TalkingOther
Number of agents in the skill group talking on
internal calls (neither inbound nor outbound) at
the end of the five-minute interval. Examples of
“other calls include agent-to-agent transfers and
supervisor calls.
internal calls (neither inbound nor outbound) at
the end of the five-minute interval. Examples of
“other calls include agent-to-agent transfers and
supervisor calls.
int
NULL
WorkReady
Number of agents in the skill group in the Work
Ready state at the end of the five-minute interval.
Ready state at the end of the five-minute interval.
int
NULL
WorkNotReady
Number of agents in the skill group in the Work
Not Ready state at the end of the five-minute
interval.
Not Ready state at the end of the five-minute
interval.
int
NULL