Technical References

•
Media Routing Domain (page 234) (via MRDomainID)
Table 10: Indexes for Agent_Half_Hour Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAKIAgentHalfHour
DbDateTimenonclustered located on PRIMARYXIE1Agent_Half_Hour
DateTime, SkillTargetID, TimeZone,
MRDomainID
clustered, unique, primary key
located on PRIMARY
XPKAgent_Half_Hour
Fields in Agent_Half_Hour Table :
Keys and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
The number of seconds in the half-hour interval that this agent was
available with respect to this Media Routing Domain.
AvailableInMRDTimeToHalf
An agent is Available, or eligible to be assigned a task in this MRD,
if the agent meets all of these conditions:
• The agent is in any state other than Not Ready state for this MRD.
• The agent is not working on a non-interruptible task in another MRD.
Only eMail tasks are interruptible, meaning that ICM software can
assign the agent another task while s/he is working on an eMail.
Voice calls, single-session chat sessions, multi-session chat sessions,
and Blended Collaboration chat sessions cannot be interrupted.
• The agent has not reached the maximum task limit for this MRD.
For Voice, single-session chat, eMail and Blended Collaboration
MRDs, the task limit is always one task.
For the multi-session chat MRD, the task limit is customized through
the Web Collaboration Option administration application.
NULLDBINT
Total time, in seconds, the agent was in the NOT ACTIVE state during
the half- hour interval.
AvailTimeToHalf
PK NOT
NULL
DBSMALLDATE
The Central Controller date and time at the start of the interval.
DateTime
IE-1 NULLDBDATETIME
The current date and time stamp when the records are written to the
HDS database. The logger database has NULL for this column.
DbDateTime
NULLDBINT
Total time, in seconds, the agent was logged into this Media Routing
Domain during the half- hour interval.
LoggedOnTimeToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
25
Chapter 2: All Tables
Agent_Half_Hour Table