Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-4
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
•
, contains records written for resources configured for a supervisor’s
remote monitoring allowed list on the Unified CCX Administration user interface.
•
, contains records written for remote monitoring supervisors configured on the
Unified CCX Administration user interface.
•
, contains real-time statistics for configured CSQs.
•
, contains Unified CCX summary statistics.
•
, contains records written for skills configured on the Unified CCX Administration
user interface.
•
, is a relationship table between skills and CSQs.
•
, contains records written for supervisors configured on the Unified CCX
Administration user interface.
•
, contains records written for teams configured on the Unified CCX Administration
user interface.
•
, is a relationship table between teams and CSQs.
•
, contains records written for workflow tasks that are executed.
•
, contains one row for each email message being processed by an agent.
•
, contains one row for each email message currently in the system.
•
, contains one row for each Email state change for an agent.
•
, contains descriptive text (in English only) for each possible
email status.
•
, (associates an agent and an email message, contains one record
for each email message an agent is working on.
•
, contains descriptive text (in English only) for each possible
reason code.
•
, contains descriptive text (in English only) for each email state.
•
, contains a single row indicating the version of the EEM database
tables. This is used when upgrading from a previous version.
AgentConnectionDetail
Database table name: AgentConnectionDetail
The Unified CCX system creates a new record in the AgentConnectionDetail table when an agent
disconnects a call or a leg by hanging up or by transferring the call. (A new call leg starts each time that
a call is transferred, except when a call is transferred from a Cisco Computer Telephony Interface [CTI]
port to an agent.)
disconnects a call or a leg by hanging up or by transferring the call. (A new call leg starts each time that
a call is transferred, except when a call is transferred from a Cisco Computer Telephony Interface [CTI]
port to an agent.)
An AgentConnectionDetail record contains information relating to the agent who handled the call or call
leg.
leg.
The AgentConnectionDetail table contains the fields shown
.