Cisco Cisco IP Contact Center Release 4.6.1 Riferimenti tecnici
Keys and
Null
Option:
Null
Option:
Data Type:
Description:
Field Name:
AK-1 NOT
NULL
NULL
DBFLT8
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.
RecoveryKey
NULL
DBINT
Time agents in the skill group spent in the Reserved
state during the five-minute window.
state during the five-minute window.
ReservedStateTimeTo5
ReservedStateTime is included in the calculation
of LoggedOnTime.
of LoggedOnTime.
PK, FK
NOT
NULL
NOT
NULL
DBINT
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.
SkillTargetID
NULL
DBINT
Number of agents in the skill group talking on
inbound calls at the end of the five-minute interval.
inbound calls at the end of the five-minute interval.
TalkingIn
Inbound calls are ACD calls arriving on trunks (that
is, calls that are not internally generated).
is, calls that are not internally generated).
NULL
DBINT
Number of agents in the skill group talking on
internal calls (neither inbound nor outbound) at the
internal calls (neither inbound nor outbound) at the
TalkingOther
end of the five-minute interval. Examples of “other
calls include agent-to-agent transfers and supervisor
calls.
calls include agent-to-agent transfers and supervisor
calls.
NULL
DBINT
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.
TalkingOut
NULL
DBINT
Number of seconds agents in the skill group were
in the Talking state during the five-minute window.
in the Talking state during the five-minute window.
TalkTimeTo5
This field is applicable for ICM, IPCC Enterprise
and Outbound Option.
and Outbound Option.
PK, NOT
NULL
NULL
DBINT
The time zone for the date and time. The value is
the offset in minutes from UTC (formerly called
GMT).
the offset in minutes from UTC (formerly called
GMT).
TimeZone
NULL
DBINT
This field is not used.
Unused1
NULL
DBINT
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.
WorkNotReady
NULL
DBINT
Number of seconds agents in the skill group were
in the Work Not Ready state during the five-minute
in the Work Not Ready state during the five-minute
WorkNotReadyTimeTo5
window. WorkNotReadyTime is included in the
calculation of LoggedOnTime.
calculation of LoggedOnTime.
NULL
DBINT
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.
WorkReady
NULL
DBINT
Number of seconds agents in the skill group were
in the Work Ready state during the five-minute
in the Work Ready state during the five-minute
WorkReadyTimeTo5
interval. WorkReadyTime is included in the
calculation of LoggedOnTime.
calculation of LoggedOnTime.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
319
Chapter 2: All Tables
Skill_Group_Five_Minute Table