Cisco Cisco Unified Intelligent Contact Management Software Technical References

Page of 404
 
2-273
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Termination_Call_Detail Table
CallDisposition
(continued)
51 = Task Ended During Application Init. 
The application instance notified the ICM 
software that a task that existed prior to the loss 
of connection was not initialized by the 
application once connection was restored.
52 = Called Party Disconnected. 
Note
To more accurately reflect call status, 
CallDisposition will be set to 15 
(Redirected) instead of 4 (Abandon 
Delay) in the following cases:
- When a call leaves a CTI route point 
to be sent to IVR.
- When agent transfers call to another 
skillgroup and there is no agent 
available, so the call has to be sent to 
IVR.
smallint
NOT NULL
NetworkTime
The number of seconds between the PG 
receiving a “pre-call message from the 
CallRouter for the task and an Offer Task (or 
Start Task, if an Offer Task is not sent) message 
for the task. 
int
NULL
Duration
Duration of the call in seconds. This is the time 
that the switch is processing the call. The 
Duration field comprises several fields of the 
Termination_Call_Detail table:
LocalQTime + RingTime + TalkTime + 
WorkTime + HoldTime + DelayTime 
int
NULL
RingTime
The number of seconds that the call spent 
ringing at the agent’s teleset before it was 
answered. Ring time occurs after any 
DelayTime and LocalQTime. For diverted calls 
(that is, calls that rang at an agent's teleset 
before being redirected on failure to answer), 
RingTime is the sum of the time that the call 
spent ringing at each teleset.
RingTime is added to the 
AbandonedRingTimeToHalf Skill Group and 
Agent Skill Group half-hour tables when the 
call completes.
RingTime is also used to compute the 
following Route and Service half hour values:
- DelayQAbandTimeToHalf
- LongestCallDelayQTimeToHalf
- LongestCallAbandTimeToHalf
int
NULL
Table 2-180 Termination_Call_Detail Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option