Technical References

Keys and
Null
Option:
Data Type:Description:Field Name:
There are a few scenarios where the RouterCallKeySequenceNumber
may not be unique for a given RouterCallKey (specifically when
translation routing to a Service Controlled IVR).
FK NULLDBINT
Identifies which service handled the call. This value (for example, 5004)
is unique among all skill targets in the enterprise. It is taken from the
ServiceSkillTargetID
Service table in the ICM central database. ServiceSkillTargetIDs are
generated automatically when a service is configured in the Service
Configuration window of ICM Configuration Manager. If the call is
handled by a non-configured service, this field is set to null. In addition,
if the call is not associated with a service, the field is set to null (for
example, in the case of non-ACD calls).
FK NULLDBINT
Identifies which skill group handled the call. This value (for example,
5010) is unique among all skill targets in the enterprise. It is taken from
SkillGroupSkillTargetID
the Skill_Group table in the ICM central database.
SkillGroupSkillTargetIDs are generated automatically when a skill
group is configured in the Skill Group Configuration window of ICM
Configuration Manager.
If the call is handled by a non-configured skill group, this field is set
to null.
NULLvarchar(32)
Peripheral number of agent that initiated the call.
SourceAgentPeripheralNumber
NULLDBINT
The identifier for the agent that initiated the call. This value is set only
if the agent associated with SourceAgentPeripheralNumber is configured
in the ICM software.
SourceAgentSkillTargetID
NULLDBINT
The cumulative time, in seconds, that the call was in a talking state on
the destination device. TalkTime is a completed call time, not an agent
state time.
TalkTime
TalkTime is used in the calculation of Duration in the
Termination_Call_Detail record. It is also used to calculate TalkTime
in the Services and Route tables.
Note: In the Termination_Call_Detail, Skill_Group, and
Agent_Skill_Group tables, TalkTime does not include HoldTime;
however, in the Services and Route tables, TalkTime does include
HoldTime.
NULLDBINT
The elapsed time in seconds before the call was abandoned. This can
include DelayTime, LocalQTime, and RingTime, depending on when
TimeToAband
the call was abandoned. This value is set only when the call is not
answered by an agent or trunk resource.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
415
Chapter 2: All Tables
Termination_Call_Detail Table