McDewey

Storage Description Field Name smallint NULL Destination of the call or the leg: • 1—Agent. Call presented to an agent. • 2—Device. Call presented to a route point. • 3—Unknown. Call presented to an outside destination through a gateway or to an unknown device. • Null if no destination. destinationType int NULL Numeric identifier of the agent who received the call or the leg. Used only if destinationType is 1. destinationID nvarchar(30) NULL If the destinationType is 1 and the call was received by an agent using the non-IPCC extension, then this field contains the non-IPCC extension, else it contains an empty character (''). If destinationType is 2, this field shows the CTI port number. If destinationType is 3, this field shows the telephone number called, if available. An empty character ('') if destinationType is 1. destinationDN datetime year to fraction (3) NOT NULL For an incoming call or a leg, date and time that the call or the leg started to ring in the system. For an internal call or for an outgoing call, date and time that the call originated. For a transferred call or a leg, endDateTime of the transferring call or leg. startDateTime datetime year to fraction (3) NOT NULL Date and time that this call or the leg was transferred or was disconnected. endDateTime smallint NOT NULL Offset, in minutes, between the local time of the Unified CCX server and Greenwich Mean Time. As the time information is stored in GMT, this field will always be zero. gmtOffset Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 37 Database Schema ContactCallDetail