Technical References

Keys and
Null
Option:
Data Type:Description:Field Name:
the DelayTime. DelayTime includes all time the call spent on
announcements. For ACDs that can de-queue calls, a call can go back
into the delay state and DelayTime can begin accumulating again.
DelayTime is used to calculate Duration in the Termination_Call_Detail
record. It is also used to calculate the following fields in the Service
and Route half-hour tables:
• DelayQAbandTimeToHalf
• LongestCallAbandTimeToHalf
• AnswerWaitTimeToHalf
NULLvarchar(40)
The digits dialed for an outbound call initiated on the ACD. These digits
are not provided by all ACDs. Currently, only IVRs, the Aspect
DigitsDialed
CallCenter, and the DEFINITY ECS provide values in the DigitsDialed
field. In addition, if a call is translation routed, the receiving PG also
reports this field even though the call is inbound.
This field is set for IPCC Enterprise.
NULLVNAME32
The DNIS value, provided by the ACD, that arrives with the call.
DNIS
NULLDBINT
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:
Duration
LocalQTime + RingTime + TalkTime + WorkTime + HoldTime +
DelayTime + NetQTime
NULLDBINT
The cumulative time, in seconds, that the call was put on hold by at
least one agent device. A call may be put on hold by more than one
HoldTime
agent device during its duration. The call might be finished by being
abandoned, transferred, handled to completion, etc.
Note: This is used in CallHandleTimeHalf field of the
Call_Type_Half_Hour table only when there is a valid CallTypeID in
the Termination_Call_Detail table.
AK-2 NOT
NULL
DBINT
A unique number generated at the PG. Values are reused after about
250 million calls.
ICRCallKey
NULLDBINT
Link to the ICRCallKey field of a child call (used for transfers and
multiple-way conference calls).
ICRCallKeyChild
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
411
Chapter 2: All Tables
Termination_Call_Detail Table