Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 548
   
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
AK-1
RecoveryKey
IE-1
DbDateTime
Table 2-10
Agent_Event_Detail Table
Field Name
Description
Data Type
Keys and 
Null Option
DateTime
The date and time (in Central Controller local 
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.
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.
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.
DBINT
NULL
Event
Event transition that occurred: 
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.
DBINT
NOT NULL
LoginDateTime
DateTime (in Central Control local time) when the 
agent initially logged into the Media Routing 
Domain.
DBDATETIME
NOT NULL