McDewey

Storage Description Field Name datetime year to fraction (3) NOT NULL Date and time that the call or the leg was transferred or disconnected. endDateTime smallint NOT NULL Primary Key For all the new calls that are coming to an agent’s extension through a route point, the value of qIndex is

1. Thereafter, the value of qIndex is incremented by 1, whenever there is a conference through the route point. Note The value of qIndex of an agent is 0, whenever an agent receives a call to the extension directly (by conference and transfer legs) instead of a route point. This is applicable only for the AgentConnectionDetail table. qIndex 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 smallint NULL Amount of time, in seconds, between the time the call or the leg first rang at the extension of an agent and one of the following events: • The agent answered the call or the leg • The caller stopped responding before the call or the leg was answered • The system retrieved the call or the leg before the call or the leg was answered ringTime int NULL Amount of time, in seconds, that passed from the time an agent answered the call or the leg to the time the call or the leg was disconnected or transferred, not including hold time. talkTime smallint NULL Amount of time, in seconds, that the call or the leg spent on hold. holdTime smallint NULL Amount of time, in seconds, that an agent spent in Work State after the call or the leg. workTime varchar(40) NULL After-call information that the agent enters through the Agent Desktop user interface while the agent is in the work state. callWrapupData Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 5 Database Schema AgentConnectionDetail