Cisco Cisco IP Contact Center Release 4.6.1 Technical References

NOT_READY: Number of seconds the agent was in the NotReady State
with respect to the Media Routing Domain. To compute the time the agent
initially went into the NotReady state, subtract the Duration from the
DateTime field.

NOT NULL

DBINT

Event transition that occurred. This value represents the event that is
triggered and does not correlate with Agent State values.

Event

• 1 = LOGIN Agent logged in to the Media Routing Domain,

• 2 = LOGOUT Agent logged out of the Media Routing Domain,

• 3 = NOT_READY Agent transitioned out of the NOT_READY state.

NOT NULL

DBDATETIME

DateTime (in Central Control local time) when the agent initially logged
into the Media Routing Domain.

LoginDateTime

PK NOT NULL

DBINT

The ID of the Media Routing Domain with which the event is associated.

MRDomainID

NULL

DBINT

The ReasonCode associated with the event. Refer to the Reason_Code
table.

ReasonCode

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

PK NOT NULL

DBINT

The SkillTargetID of the agent.

SkillTargetID

PK NOT NULL

DBINT

The time zone for the dates and time. The value is the offset in minutes
from UTC (formerly called GMT).

TimeZone

Agent_Half_Hour Table

. To see database rules for these tables, click

Central database only.

Each row in the table is for an agent/MRD pair. For example, if the agent was logged into three
(3) MRDs in a given half-hour, then the agent will have three (3) rows in the table for that same
half-hour.

Related Tables for Agent_Half_Hour

•

(via SkillTargetID)

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)