McDewey

Storage Description Field Name boolean NULL Did the call meet the service level: t = met service level f = no Note: Reserved for future use. metServiceLevel int NULL Unique identifier of the campaign that generated this call. campaignID Varchar(32) NULL Unique identifier to identify a call leg that enters the Unified CCX system. This is used to trace a call which has traversed from some product to the Unified CCX. OrigProtocolCallRef Varchar(32) NULL Unique Identifier to identify a call leg that exits the Unified CCX system. This is used to trace a call which has traversed from Unified CCX to some other product. DestProtocolCallRef smallint NULL The result of an IVR based or agent based progressive or predictive outbound call. CallResult int NULL Unique identifier of a contact that is dialed for an outbound campaign. Links with DialingList.dialingListID. dialingListID varchar(40) A unique identifier for all the records related to a single call across various tables in Unified CCX. contactid boolean Indicates whether this is the last leg corresponding to the original call. lastleg 1 For aborted calls, the corresponding value in ContactQueueDetail.disposition = 1 (abandoned) 2 VoIP = Voice over Internet Protocol 3 PSTN = Public Switched Telephone Network 4 TDM = Time-Division Multiplexing 5 Private Branch Exchange 6 Interactive Voice Response Related Topics • AgentConnectionDetail, on page 4 (via sessionID, sessionSeqNum, nodeID, and profileID) • Campaign, on page 18 (via campaignID) • ContactQueueDetail (via sessionID, sessionSeqNum, nodeID, profileID) • ContactRoutingDetail , on page 46 (via sessionID, sessionSeqNum, nodeID, and profileID) • MonitoredResourceDetail, on page 73 (sessionSeqNum maps to monitoredSessionSeqNum, via sessionID, profileID, and nodeID) Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 41 Database Schema ContactCallDetail