Cisco Cisco ICM Web Tools Referencia técnica
2-11
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Agent_Event_Detail Table
Agent_Event_Detail Table
Historical Table.
Each row displays agent LOGIN, LOGOUT, and NOT_READY events.
Security: Global
Table 2-9
Agent_Event_Detail Table Constraints
Constraint
Field Name(s)
PK
DateTime
SkillTargetID
MRDomainID
TimeZone
SkillTargetID
MRDomainID
TimeZone
AK-1
RecoveryKey
IE-1
DbDateTime
Table 2-10
Agent_Event_Detail Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
DateTime
The date and time (in Central Controller local
time) that the transition for the event occurred.
time) that the transition for the event occurred.
DBDATETIME
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
Duration
Duration in seconds associated with the EVENT:
LOGIN: Typically set to zero
LOGOUT: Number of seconds the agent was
logged into the Media Routing Domain.
logged into the Media Routing Domain.
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.
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.
DBINT
NULL
Event
Event transition that occurred:
1 = LOGIN Agent logged in to the Media Routing
Domain,
Domain,
2 = LOGOUT Agent logged out of the Media
Routing Domain,
Routing Domain,
3 = NOT_READY Agent transitioned out of the
NOT_READY state.
NOT_READY state.
DBINT
NOT NULL
LoginDateTime
DateTime (in Central Control local time) when the
agent initially logged into the Media Routing
Domain.
agent initially logged into the Media Routing
Domain.
DBDATETIME
NOT NULL