McDewey

Storage Description Field Name varchar(100,0) NULL Reason for disposition. • 1—System Error • 2—Consult Transfer • 3—Blind Transfer • 5—Blind Transfer to Experience Management for IVR Survey • 6—SIPURI Retrieval Failure for Experience Management Survey • 7—JTAPI Transfer Failure for Experience Management Survey • 8—Notified Experience Management for SMS/Email Survey dispositionReason smallint NOT NULL Originator of the call or the leg: • 1—Agent. Call originated by an agent. • 2—Device. Call originated by a simulated caller (used for testing) and an agent phone where the agent is not currently logged in. • 3—Unknown. Call originated by an outside caller through a gateway or by an unknown device. originatorType int NULL Numeric identifier of the agent who originated the call or the leg. Used only if originatorType is 1. originatorID nvarchar(30,0) NULL If originatorType is 1 and the call was placed by the agent using the non-IPCC extension then this field contains the non-IPCC extension, else it contains an empty character (''). If originatorType is 2, this field shows the CTI port number. If originatorType is 3, this field shows the telephone number of the caller as received by the Unified CM, if available. An empty character ('') if originatorType is 1. This is not applicable for agent based progressive and predictive outbound calls. originatorDN Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 36 Database Schema ContactCallDetail