Cisco Cisco IP Contact Center Release 4.6.1 Referencia técnica

•

RecoveryKey

nonclustered, unique, unique key
located on PRIMARY

XAKIAgentHalfHour

DbDateTime

nonclustered located on PRIMARY

XIE1Agent_Half_Hour

DateTime, SkillTargetID, TimeZone,
MRDomainID

clustered, unique, primary key
located on PRIMARY

XPKAgent_Half_Hour

NULL

DBINT

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.

NULL

DBINT

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 NULL

DBDATETIME

The current date and time stamp when the records are written to the
HDS database. The logger database has NULL for this column.

DbDateTime

NULL

DBINT

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)