McDewey

Table 74: TextAgentConnectionDetail Table Fields Storage Description Field Name varchar (64,0) NOT NULL Primary Key Alphanumeric identifier for the contact. ContactID smallint NOT NULL Primary Key Contact sequence number that the system assigned to the contact or the leg. Each leg of a contact is assigned a new contact sequence number. To be used later. ContactSeqNum smallint NOT NULL Numeric identifier for the node. nodeID int NOT NULL Primary Key Numeric identifier for the resource. resourceID datetime year to fraction (3) NOT NULL Primary Key Date and time that the contact or leg entered the system. startDateTime datetime year to fraction (3) NOT NULL Date and time that the contact or the leg was transferred or disconnected. endDateTime smallint NOT NULL A new qIndex is created whenever a Unified CCX contact is conferenced to a Unified CCX route point. To be used later. qIndex smallint NULL Amount of time, in seconds, that passed from the time a contact or leg was presented to an agent and the agent answered the contact. acceptTime smallint NULL Amount of time, in seconds, that passed from the time an agent answered the contact or the leg to the time the contact or the leg was disconnected or transferred, not including hold time. talkTime smallint NULL Amount of time, in seconds, that an agent spent in Work State after the contact or the leg. To be used later. workTime Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 102 Database Schema TextAgentConnectionDetail