McDewey

Storage Description Field Name smallint NULL Outcome of the outbound dialer call. 1 = Voice (Customer answered and was connected to agent) 2 = Fax/Modem (Fax machine detected) 3 = Answering Machine (answering machine detected) 4 = Invalid (Number reported as invalid by the network) 5 = Do Not Call (customer does not want to be called again) 6 = Wrong Number (number successfully contacted but wrong number) 7 = Customer Not Home (number successfully contacted but reached the wrong person) 8 = Callback (customer requested regular callback) 9 = Agent Rejected (Agent has skipped or rejected a preview call) 10 = Agent Closed (Agent has skipped or rejected a preview call with the close option) 11 = Busy (busy signal detected) 12 = RNA (the agent lets the call go ring-no-answer) 20 = OB_XFER is default (the agent transfers or conferences the outbound call to another agent. callResult int NULL Unique identifier of a contact that is dialed for an outbound campaign. Links with DialingList.dialingListID dialinglistid Boolean Specifies if the call or the leg hasn’t been answered by an agent within the configured ring time. This equates to ’t’ if the call hasn’t been answered. rna varchar(18) Unique identifier of an agent login session. This identifier remains the same until the session ends. loginsessionid varchar(40) Unique identifier for all records related to a single call across various tables in Unified CCX. contactid int Numeric identifier of CSQ for CSQ-based calls, else -1 is stored. csqrecordid decimal (18, 0) This field is NOT NULL for conferenced or transferred agents through consult call. The value will be the sessionID of the consult call. consultsessionid Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 6 Database Schema AgentConnectionDetail