McDewey

• ProfileIDMapping, on page 75 (via profileID) • PurgeHistory, on page 76 (sessionID maps to monitoredSessionID, via sessionID, sessionSeqNum, profileID, and nodeID) • Resource, on page 81 (via originatorID/destinationID maps to resourceID when originatorType/destinationType is 1, via profileID) ContactHoldDetail Database table name: ContactHoldDetail The Unified CCX system creates a new record in the ContactHoldDetail table each time a contact is put on hold. Table 28: ContactHoldDetail Storage Description Field Name varchar(40) NOT NULL A unique identifier for the contact. This is used to identify all call records pertaining to a single customer whose call details are stored across various tables within Unified CCX. contact id decimal(18,0) NOT NULL An identifier that the system assigns to the call. This identifier remains the same for all legs of the call. sessionID smallint NOT NULL A session sequence number that the system assigns to the call or the call leg. Each leg of the call is assigned a new sequence number. sessionSeqNum datetime year to fraction(3) NOT NULL Date and time the call was put on hold. startDateTime datetime year to fraction(3) NOT NULL Date and time the call changed from hold state to retrieved or disconnected state. endDateTime smallint NOT NULL Indicates the hold initiation type. • 1 - Agent Initiated • 2 - System Initiated type int NOT NULL Identifier of the agent who has put the call on hold. resourceid ConfigSchema Database table name: ConfigSchema Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 42 Database Schema ContactHoldDetail