Technical References

Keys and
Null
Option:
Data Type:Description:Field Name:
NULLDBFLT4
Percentage of Ready time that agents in the skill group spent talking
or doing call work during the five-minute window. This is the
PercentUtilizationTo5
percentage of time agents spend working on calls versus the time
agents were ready.
NULLDBINT
Number of agents in the skill group in the Ready state at the end of
the five-minute interval.
Ready
NOT NULLDBINT
Currently not used, set to zero (0).
RecoveryDay
AK-1 NOT
NULL
DBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NULLDBINT
Time agents in the skill group spent in the Reserved state during the
five-minute window. ReservedStateTime is included in the
calculation of LoggedOnTime.
ReservedStateTimeTo5
PK, FK NOT
NULL
DBINT
The SkillTargetID of the agent. Together with the
SkillGroupSkillTargetID, identifies the skill group member. Foreign
key from skill group table.
SkillTargetID
NULLDBINT
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).
TalkingIn
NULLDBINT
Number of agents in the skill group talking on internal calls (neither
inbound nor outbound) at the end of the five-minute interval.
TalkingOther
Examples of “other calls include agent-to-agent transfers and
supervisor calls.
NULLDBINT
Number of agents in the skill group talking on outbound calls at the
end of the five-minute interval.
TalkingOut
NULLDBINT
Number of seconds agents in the skill group were in the Talking
state during the five-minute window.
TalkTimeTo5
This field is applicable for ICM, IPCC Enterprise and Outbound
Option.
PK, NOT
NULL
DBINT
The time zone for the date and time. The value is the offset in minutes
from UTC (formerly called GMT).
TimeZone
NULLDBINT
This field is not used.
Unused1
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
370
Chapter 2: All Tables
Skill_Group_Five_Minute Table