McDewey

Storage Description Field Name varchar(40,0) NULL The contact information that the agent enters after the contact is handled through the Agent Desktop user interface. WrapupData smallint NOT NULL Default: 0 Disposition of the contact. contactdisposition varchar(18) Unique identifier of an agent login session. This identifier remains the same until the session ends. loginsessionid smallint Indicates the media session identifier assigned while assigning the contact. It can be 1 to 5 for ‘Chat’ media and 26 to 30 for ‘Email’ media, depending on the maximum sessions configured by the administrator in ‘Channel Parameter’ configuration page of AppAdmin. mediasessionid int Numeric identifier of the CSQ in which the agent received an email or chat contact. csqrecordid Related Topics TextContactDetail , on page 105 TextContactQueueDetail, on page 108 TextAgentStateDetails Database table name: TextAgentStateDetail The Unified CCX system creates a new record in the TextAgentStateDetail table each time the state of the agent changes while the agent is handling chat and email. The TextAgentStateDetail record contains information about the agent and about the event that caused the agent state to change. Table 75: TextCustomerDetail Table Fields Storage Description Field Name int NOT NULL Primary Key Identifier of the agent whose state has changed. agentID datetime year to fraction (3) NOT NULL Primary Key Date and time that the chat agent state changed. stateChangeDatetime Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 103 Database Schema TextAgentStateDetails