Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-13
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Agent_Half_Hour Table
Agent_Half_Hour Table
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.
in a given half-hour, then the agent will have three (3) rows in the table for that same half-hour.
Table 2-11
Agent_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
DateTime
MRDomainID
SkillTargetID
TimeZone
MRDomainID
SkillTargetID
TimeZone
AK-1
RecoveryKey
FK
MRDomainID
SkillTargetID
SkillTargetID
IE-1
DbDateTime
Table 2-12 Agent_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AvailableInMRDTimeToHalf
The number of seconds in this half-hour interval
that this agent was
that this agent was
with respect to this
Media Routing Domain.
DBINT
NULL
Available
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.
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.
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.
AvailTimeToHalf
Total time, in seconds, the agent was in the NOT
ACTIVE state during the half- hour interval.
ACTIVE state during the half- hour interval.
DBINT
NULL
DateTime
The Central Controller date and time at the start of
the interval.
the interval.
DBSMALLDATE
PK
NOT 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.
are written to the HDS database. The logger
database has NULL for this column.
DBDATETIME
IE-1
NULL
LoggedOnTimeToHalf
Total time, in seconds, the agent was logged into
this Media Routing Domain during the half- hour
interval.
this Media Routing Domain during the half- hour
interval.
DBINT
NULL