McDewey

Storage Description Field Name int NOT NULL Numeric identifier of the selected CSQ for CSQ-based calls, else -1 is stored. csqrecordid ContactCallDetail Database table name: ContactCallDetail The Unified CCX system creates a new record in the ContactCallDetail table for each call or call leg that is processed by the system. A new call leg starts each time a call is transferred or redirected, except when a call is transferred from a Cisco CTI port to an agent. A ContactCallDetail record contains detailed information about the call or leg. A minimum of one such record will exist for each call. Table 27: ContactCallDetail Table Fields Storage Description Field Name decimal(18,0) NOT NULL Primary Key Identifier that the system assigned to the call. This identifier remains the same for all legs of the call. sessionID smallint NOT NULL Primary Key Session sequence number that the system assigned to the call or the leg. Each leg of a call is assigned a new sequence number. sessionSeqNum smallint NOT NULL Primary Key Unique identifier that is assigned to each server in the cluster. nodeID int NOT NULL Primary Key Identifier of the Unified CCX profile that is associated with this record. profileID Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 34 Database Schema ContactCallDetail