Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-17
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Related Tables
•
(via sessionID, sessionSeqNum, nodeID, and profileID)
•
(via campaignID)
•
(via session ID, sessionSeqNum, nodeID, profileID)
•
(via sessionID, sessionSeqNum, nodeID, and profileID)
•
(sessionSeqNum maps to monitoredSessionSeqNum, via
sessionID, profileID, and nodeID)
•
(via profileID)
•
(sessionID maps to monitoredSessionID, via sessionID,
sessionSeqNum, profileID, and nodeID)
•
(via originatorID/destinationID maps to resourceID when
originatorType/destinationType is 1, via profileID)
ContactQueueDetail
Database table name: ContactQueueDetail
The Unified CCX system writes the record when the call is queued for CSQs; then one of the following
happens:
happens:
•
Call is abandoned while queued for CSQs
•
Call is being dequeued
•
Caller is connected to an agent
The Contact Queue Detail table contains the fields shown in
.
6.
IVR = Interactive Voice Response
Table 1-7
ContactQueueDetail Table Fields
Field Name
Description
Storage
sessionID
Identifier that the system assigned to the call. This identifier
remains the same for all legs of the call.
remains the same for all legs of the call.
decimal(18,0)
NOT NULL
Primary Key
sessionSeqNum
Session sequence number that the system assigned to the call or
the leg. Each leg of a call is assigned a new sequence number.
the leg. Each leg of a call is assigned a new sequence number.
smallint
NOT NULL
Primary Key
profileID
Identifier of the Unified CCX profile that is associated with this
record.
record.
int
NOT NULL
Primary Key
nodeID
Unique identifier assigned to each server in the cluster.
smallint
NOT NULL
Primary Key