McDewey

Storage Description Field Name 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 int NOT NULL Primary Key Identifier of the agent whose ACD call details are stored. agentID int NOT NULL Identifier of the type of all incoming and outgoing calls of agents' ACD line extension. calltype BIG INT NOT NULL Primary Key Start date and time of the agent call details that are to be stored. startdatetime varchar (30) NOT NULL Identifier of the phone number of the calls that were handled by the agent. phonenumber int NULL Identifier of the contact disposition. disposition lvarchar (804) NULL Information that the agents enter in the desktop user interface after a call, while the agents are still in the work state. wrapupdata nvarchar (50) NULL Identifier of the CSQ name that the agent was assigned to. csqname BIG INT NOT NULL End date and time of the agent call details that are to be stored. enddatetime Related Topics Resource, on page 81 AgentStateDetailSnapshot Database table name: AgentStateDetailSnapshot The Unified CCX system stores the records of agent state change details in a day in the AgentStateDetailSnapshot table. All previous day records will be purged as part of the scheduled purge at mid-night. Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 9 Database Schema AgentStateDetailSnapshot