McDewey

Table 4: AgentStateDetailSnapshot Table Fields Storage Description Field Name int NOT NULL Primary Key Identifier of the agent whose state has changed. agentID BIG INT NOT NULL Primary Key Date and time that the agent state changed. eventDateTime smallint NOT NULL Primary Key Event that triggered the agent state change: 1—Log In 2—Not Ready 3—Ready 4—Reserved 5—Talking 6—Work 7—Log Out eventType smallint NOT NULL Primary Key Code, as set up in the Cisco Desktop Administrator, for the reason that the agent changed to Not Ready State or to Log Out State. Null if a reason code is not configured. reasonCode lvarchar (804) NULL After-call information that the agent enters through the Agent Desktop user interface while the agent is in the work state. wrapupData Related Tables • Resource, on page 81 (agentID maps to resourceID and via profileID) Application Prompt Map Database table name: ApplicationPromptMap The Unified CCX system creates a new record in the applicationpromptmap table when an administrator is associating prompt files, a folder of prompts, or a combination of prompt files and folders to an application. Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 10 Database Schema Application Prompt Map