Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
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.
to the HDS database. The logger database has NULL for this
column.
DbDateTime
NULL
DBINT
Duration in seconds associated with the EVENT:
Duration
LOGIN
: Typically set to zero
LOGOUT
: Number of seconds the agent was logged into the
Media Routing Domain.
NOT_READY
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.
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.
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.
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.
is associated.
MRDomainID
NULL
DBINT
The ReasonCode associated with the event. Refer to the
Reason_Code table.
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.
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).
in minutes from UTC (formerly called GMT).
TimeZone
Agent_Half_Hour Table
This table is in the
. 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.
(3) MRDs in a given half-hour, then the agent will have three (3) rows in the table for that same
half-hour.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
28
Chapter 2: - All Tables
Agent_Half_Hour Table