Technical References
Keys and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Identifies which agent handled the call. This value (for example, 5001),
is unique among all skill targets in the enterprise. It is taken from the
AgentSkillTargetID
Agent table in the ICM central database. AgentSkillTargetIDs are
generated automatically when the agent is first configured in the Agent
Configuration window of ICM Configuration Manager.
The AgentSkillTargetID is used only if agents are configured. If agents
are not configured, the value for AgentSkillTargetID is null. If agents
are not configured, you can use the AgentPeripheralNumber to
determine the peripheral number for the agent that handled the call.
NULLvarchar(32)
The ANI value for the call.
ANI
NULLDBCHAR
Indicates whether the call was answered with the service level defined
for the service:
AnsweredWithinServiceLevel
• Y = yes
• N= no
NULLvarchar(100)
Additional data passed in the End Task message for this task.
ApplicationData
NULLDBINT
A field passed in the End Task message for this task. This is an
application-specific code that indicates why the task was ended. For
ApplicationTaskDisposition
example, E-Mail Manager might use the ApplicationTaskDisposition
field to indicate that the task ended because an agent closed an e-mail
without responding to it.
NULLDBCHAR
Indicates whether the call was marked as bad by the agent. Stored as a
character:
BadCallTag
• Y = the call was marked “bad”
• N = the call was not marked “bad”
NULLDBSMALLINT
Reserved for future use.
BillRate
NOT NULLDBSMALLINT
The final disposition of call (or how the call terminated). To see the list
of values, click here (page 491).
CallDisposition
NULLDBINT
A series of flags providing detail on the call disposition. To see the list
of values, click here (page 491).
CallDispositionFlag
NULLDBINT
Time, in seconds, that the system took to segment a private network
call. For example, if the ICM software handed the caller off to a menu
CallSegmentTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
409
Chapter 2: All Tables
Termination_Call_Detail Table