McDewey

Storage Description Field Name 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 int NOT NULL Primary Key Identifier of the Unified CCX profile that is associated with this record. profileID varchar(18) Unique identifier of an agent login session. This identifier remains the same until the session ends. loginsessionid varchar(40) Unique identifier for all records related to a single call across various tables in Unified CCX. contactid Related Topics • ProfileIDMapping, on page 75 (via profileID) • Resource, on page 81 (agentID maps to resourceID and via profileID) AgentCallDetailSnapshot Database table name: AgentCallDetailSnapshot The Unified CCX system stores the records of agent call details in a day in the AgentCallDetailSnapshot table. All previous day records will be purged as part of the scheduled purge at mid-night. Table 3: AgentCallDetailSnapshot Table Fields Storage Description Field Name int NOT NULL Primary Key Alphanumeric identifier for the contact. contactid Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 8 Database Schema AgentCallDetailSnapshot