McDewey

Related Topics • ContactCallDetail, on page 34 (via sessionID, sessionSeqNum, nodeID, and profileID) • ContactRoutingDetail , on page 46 (via sessionID, sessionSeqNum, nodeID, profileID, and qIndex) • ContactQueueDetail (via sessionID, sessionSeqNum, nodeID, profileID, and qIndex) • DialingList , on page 61 (via dialingListID) • MonitoredResourceDetail, on page 73 (sessionSeqNum maps to monitoredSessionSeqNum, via profileID, and nodeID) • ProfileIDMapping, on page 75 (via profileID) • PurgeHistory, on page 76 (sessionID maps to monitoredSessionID, via profileID, and nodeID) • Resource, on page 81 (via resourceID and profileID) AgentStateDetail Database table name: AgentStateDetail The Unified CCX system creates a new record in the AgentStateDetail table each time the state of an agent changes. An AgentStateDetail record contains information about the agent and about the event that caused the agent state change. Table 2: AgentStateDetail 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 agent state changed. eventDateTime smallint NOT NULL Offset, in minutes, between the local time of the Unified CCX server and Greenwich Mean Time. As the time information is stored in GMT, this field will always be zero. gmtOffset Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 7 Database Schema AgentStateDetail