Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-359
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Skill_Group_Five_Minute Table
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.
DBINT
NULL
LongestAvailAgent
Time in seconds that the longest available agent
for the skill group has been available.
for the skill group has been available.
DBINT
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.
DBINT
NULL
NotReadyTimeTo5
The total time in seconds that agents in the skill
group were in the Not Ready state for any skill
group during the five-minute interval.
NotReadyTime is included in the calculation of
LoggedOnTime.
group were in the Not Ready state for any skill
group during the five-minute interval.
NotReadyTime is included in the calculation of
LoggedOnTime.
DBINT
NULL
PercentUtilizationTo5
Percentage of Ready time that agents in the skill
group spent talking or doing call work during the
five-minute interval. This is the percentage of time
agents spend working on calls versus the time
agents were ready.
group spent talking or doing call work during the
five-minute interval. This is the percentage of time
agents spend working on calls versus the time
agents were ready.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBFLT4
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.
DBINT
NULL
RecoveryDay
Currently not used, set to zero (0).
DBINT
NOT NULL
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT 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.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
SkillTargetID
The SkillTargetID of the agent. Together with the
SkillGroupSkillTargetID, identifies the skill group
member. Foreign key from skill group table.
SkillGroupSkillTargetID, identifies the skill group
member. Foreign key from skill group table.
DBINT
PK, FK
NOT 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).
DBINT
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.
DBINT
NULL
Table 2-358 Skill_Group_Five_Minute Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option