Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-7
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
•
(via resourceID and profileID)
AgentStateDetail
Database table name: AgentStateDetail
The Unified CCX system creates a new record in the AgentStateDetail table each time the state of an
agent changes. An AgentStateDetail record contains information about the agent and about the event that
caused the agent state change.
agent changes. An AgentStateDetail record contains information about the agent and about the event that
caused the agent state change.
The AgentStateDetail table contains the fields shown in
Related Tables
•
(via profileID)
•
(agentID maps to resourceID and via profileID)
Table 1-2
AgentStateDetail Table Fields
Field Name
Description
Storage
agentID
Identifier of the agent whose state has changed.
int
NOT NULL
Primary Key
eventDateTime
Date and time that the agent state changed.
datetime year to
fraction (3)
fraction (3)
NOT NULL
Primary Key
gmtOffset
Offset, in minutes, between the local time of the Unified CCX
server and Greenwich Mean Time. As the time information is
stored in GMT, this field will always be zero.
server and Greenwich Mean Time. As the time information is
stored in GMT, this field will always be zero.
smallint
NOT NULL
eventType
Event that triggered the agent state change:
1—Log In
2—Not Ready
3—Ready
4—Reserved
5—Talking
6—Work
7—Log Out
smallint
NOT NULL
Primary Key
reasonCode
Code, as set up in the Cisco Desktop Administrator, for the
reason that the agent changed to Not Ready State or to Log Out
State.
reason that the agent changed to Not Ready State or to Log Out
State.
Null if a reason code is not configured.
smallint
NOT NULL
Primary Key
profileID
Identifier of the Unified CCX profile that is associated with this
record.
record.
int
NOT NULL
Primary Key