Cisco Cisco IPCC Web Option Technische Referenzen
2-14
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Agent_Half_Hour Table
Related tables:
(via SkillTargetID)
(via MRDomainID)
MRDomainID
Identifies the Media Routing Domain.
DBINT
PK, FK
NOT NULL
NotReadyTimeToHalf
Total time, in seconds, the agent was in the Not
Ready state (a state in which agents are logged on,
but are neither involved in any call handling
activity, nor available to handle a call) with respect
to this Media Routing Domain during the half-
hour interval.
Ready state (a state in which agents are logged on,
but are neither involved in any call handling
activity, nor available to handle a call) with respect
to this Media Routing Domain during the half-
hour interval.
DBINT
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
RoutableInMRDTimeToHalf
The number of seconds in this half-hour interval
that this agent was routable with respect to this
MRD.
that this agent was routable with respect to this
MRD.
DBINT
NULL
SkillTargetID
Identifies the agent.
DBINT
PK, FK
NOT NULL
TalkOtherTimeToHalf
Total time, in seconds, the agent spent talking on
internal calls during the half- hour interval.
internal calls during the half- hour interval.
Only defined for voice media.
For non-voice media, this is set to zero.
DBINT
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.
DBINT
PK
NOT NULL
Table 2-12 Agent_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option