McDewey

• TextCustomerDetails, on page 109, contains customer-related information corresponding to the chat contact. • WorkflowTask , on page 111, contains records written for workflow tasks that are completed. • ConsultLegDetail, on page 33, contains records of agents corresponding to the consult call details. AgentConnectionDetail Database table name: AgentConnectionDetail The Unified CCX system creates a new record in the AgentConnectionDetail table when an agent disconnects a call or a leg by stop responding or by transferring the call. (A new call leg starts each time that a call is transferred, except when a call is transferred from a Cisco Computer Telephony Interface [CTI] port to an agent.) An AgentConnectionDetail record contains information relating to the agent who handled the call or call leg. Table 1: AgentConnectionDetail Table Fields Storage Description Field Name decimal(18, 0) NOT NULL Primary Key Identifier that the system assigns 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 smallint NOT NULL Primary Key Unique identifier assigned to each Unified CCX server in the cluster. nodeID int NOT NULL Primary Key Identifier of the Unified CCX profile that is associated with this record. profileID int NOT NULL Primary Key Identifier of the agent who handled the call. resourceID datetime year to fraction (3) NOT NULL Primary Key Date and time that the call or the leg started ringing at the device of an agent. startDateTime Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 4 Database Schema AgentConnectionDetail