McDewey

Table 73: TeamCSQMapping Table Fields Storage Description Field Name int NOT NULL Primary Key Numeric identifier for this record. recordID int NOT NULL Numeric identifier for the CSQ. csqID int NOT NULL Numeric identifier for the team. teamID int NOT NULL Primary Key Identifier of the Unified CCX profile that is associated with this record. profileID boolean NOT NULL Indicates whether the record is active in the Unified CCX system. A record becomes inactive if a team is deleted or updated. f = Inactive t = Active active datetime year to second NULL The date on which this record was deleted. dateInactive Related Tables • ContactServiceQueue , on page 47 (csqID maps to contactServiceQueueID, and via profileID) • ProfileIDMapping, on page 75 (via ProfileID) • Team, on page 99 (via teamID and profileID) TextAgentConnectionDetail Database table name: TextAgentConnectionDetail The Unified CCX system creates a new record in the TextAgentConnectionDetail table when an agent receives an email or chat. Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 101 Database Schema TextAgentConnectionDetail