Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Leaflet
9
Cisco Customer Response Solutions Database Schema
Database Schema
Database Table Details
•
(via sessionID, sessionSeqNum, nodeID,
profileID, and qIndex)
•
(sessionSeqNum maps to
monitoredSessionSeqNum, via profileID, and nodeID)
•
(via profileID)
•
(sessionID maps to monitoredSessionID,
via profileID, and nodeID)
•
(via resourceID and profileID)
AgentStateDetail
Database table name: AgentStateDetail
The Cisco CRS system creates a new record in the AgentStateDetail table each
time the state of an agent changes.
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.
event that caused the agent state change.
The AgentStateDetail table contains the fields shown in
.
Table 1-3
AgentStateDetail Table Fields
Field Name
Description
Storage
agentID
Identifier of the agent whose state has
changed.
changed.
int
NOT NULL
Primary Key
eventDateTime
Date and time that the agent state
changed.
changed.
datetime
NOT NULL
Primary Key
gmtOffset
Offset, in minutes, between local time
of the Cisco CRS server and Greenwich
Mean Time.
of the Cisco CRS server and Greenwich
Mean Time.
smallint
NOT NULL