Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note

 (sessionID maps to monitoredSessionID, via profileID and 

nodeID)

 (targetID maps to resourceID when targetType is 1, and via profileID)

Database table name: ContactRoutingDetail

The Unified CCX system creates a new record in the ContactRoutingDetail table for each Unified CCX 
call or call leg that is queued for one or more CSQs. A new call leg starts each time that a call is 
transferred or redirected, except when a call is transferred from a Cisco CTI port to an agent. The system 
also creates a new record in the ContactRoutingDetail table if a call is conferenced to a Unified CCX 
script.

A ContactRoutingDetail record contains information about call priority and accumulated queue time. 
This differs from the ContactQueueDetail record which shows individual queue time for each CSQ. 

The Contact Routing Detail table contains the fields shown in 

sessionID

Identifier that the system assigned to the call. This identifier 
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.

smallint

NOT NULL

Primary Key

nodeID

Unique identifier assigned to each server in the cluster.

smallint

NOT NULL

Primary Key

profileID

Identifier of the Unified CCX profile that is associated with 
this record.

int

NOT NULL

Primary Key

qIndex

A new qIndex is created whenever the Unified CCX call is 
conferenced to a Unified CCX route point.

smallint

NOT NULL

Primary Key

origPriority

Priority level assigned to the call or the leg when it was first 
queued. 

Null if a priority was not assigned.

smallint

NULL

finalPriority

Priority level of the call or the leg when it ended. 

Null if a priority was not assigned.

smallint

NULL