/mcpStorage Description Field Name datetime year to fraction (3) Date and time of an incoming call that is dequeued from a particular CSQ. endDateTime varchar(40) A unique identifier for all the records related to a single call across various tables in Unified CCX. contactid 7 For aborted calls, ContactQueueDetail.disposition = 1 and the corresponding ContactCallDetail.contactDisposition = 4 (aborted). Related Topics • AgentConnectionDetail, on page 4 (via sessionID, sessionSeqNum, nodeID, profileID and qIndex) • ContactCallDetail, on page 34 (via sessionID, sessionSeqNum, nodeID, and profileID) • ContactRoutingDetail , on page 46 (via sessionID, sessionSeqNum, nodeID, profileID, and qIndex) • ContactServiceQueue , on page 47 (targetID maps to recordID when targetType is 0, via profileID) • MonitoredResourceDetail, on page 73 (sessionSeqNum maps to monitoredSessionSeqNum, via profileID, and nodeID) • ProfileIDMapping, on page 75 (via profileID) • RemoteMonitoringDetail , on page 79 (sessionID maps to monitoredSessionID, via profileID and nodeID) • Resource, on page 81 (targetID maps to resourceID when targetType is 1, and via profileID) ContactRoutingDetail Database table name: ContactRoutingDetail The Unified CCX system creates a new record in the ContactRoutingDetail table for each Unified CCX call or call leg that is queued for one or more CSQs. A new call leg starts each time that a call is transferred or redirected, except when a call is transferred from a Cisco CTI port to an agent. The system also creates a new record in the ContactRoutingDetail table if a call is conferenced to a Unified CCX script. A ContactRoutingDetail record contains information about call priority and accumulated queue time. This differs from the ContactQueueDetail record which shows individual queue time for each CSQ. Table 33: ContactRoutingDetail 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 Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 46 Database Schema ContactRoutingDetail