Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
• N = No, an agent cannot send data.
AK-1, FK NOT NULL
DBSMALLINT
The peripheral from which agent data is sent.
PeripheralID
Agent_Event_Detail Table
This table is one of the Agent Detail tables in the
. To see
database rules for these tables, click
This table can become very large. Running custom reporting queries against it while it is on the
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
Displays agent LOGIN, LOGOUT, and NOT_READY events.
Table 8: Related Tables for Agent_Event_Detail
(via MRDomainID)
(via SkillTargetID)
Table 9: Indexes for Agent_Event_Detail Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Agent_Event_Detail
DbDateTime
nonclustered located on PRIMARY
XIEIAgent_Event_Detail
DateTime, SkillTargetID, MRDomainID,
TimeZone
TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAgent_Event_Detail
Fields in Agent_Event_Detail Table :
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBDATETIME
The date and time (in Central Controller local time) that the transition for
the event occurred.
the event occurred.
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.
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.
Routing Domain.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
23
Chapter 2: All Tables
Agent_Event_Detail Table