Technical References

Keys and
Null
Option:
Data Type:Description:Field Name:
of choices, CallSegmentTime reflects how long the caller spent in the
menu.
NULLDBINT
In ICM and IPCC Enterprise, indicates which call type, and therefore
which routing script, was used to route this call.
CallTypeID
Note: This field contains a value only if the call was translation-routed
or sent to an IPCC Enterprise agent.
NULLvarchar(30)
The Caller Entered Digits (CED) associated with the call. This is filled
for Outbound Option Reservation or Personal Callback Calls. The values
are:
CED
• ICM_BA_Reservation_Call - Reservation call
• Callback - Personal Callback customer call
This field is applicable for ICM and IPCC Enterprise.
NULLDBINT
The cumulative number of seconds that the call was in conference with
more than two parties. ConferenceTime is recorded for both ACD and
ConferenceTime
non-ACD calls. The value includes any HoldTime associated with the
call. It is updated when the agent drops off the call or the call becomes
a simple two-party call.
Depending on who initiated the call, ConferenceTime from
Termination_Call_Detail is used in the following Skill Group and Agent
Skill Group tables:
• ConferencedOutCallsTimeToHalf
• ConferencedInCallsTimeToHalf
AK-2, IE-1
NOT NULL
DBDATETIME
The date/time that the Termination_Call_Detail table record is generated
by the Peripheral Gateway (PG). The Termination_Call_Detail table
DateTime
record is generated by the PG when the call has either physically left
the PG (for example, IVR routes the call to an agent) or when wrap-up
is completed for the call after the call has left the agent device (either
by disconnect, or through transfer completion).
IE-2 NULLDBDATETIME
The current date and time stamp when the records are written to the
HDS database. The logger database has NULL for this column.
DbDateTime
NULLDBINT
The time in seconds that the call is active on the switch but not queued
to a skill group or trunk resource. For example, if a call arrives at an
DelayTime
ACD and an announcement is played before the call is queued, from
the time the call arrives at the ACD to the time the call gets queued is
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
410
Chapter 2: All Tables
Termination_Call_Detail Table