Cisco Cisco Administrative Workstation Technical References
2-412
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Termination_Call_Detail Table
SkillGroupSkillTargetID
value (for example, 5010) is unique among all skill
targets in the enterprise. It is taken from 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.
targets in the enterprise. It is taken from 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.
group, this field is set to null.
DBINT
FK
NULL
SourceAgentPeripheralNumber
Peripheral number of agent that initiated the call.
varchar(32)
NULL
SourceAgentSkillTargetID
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.
This value is set only if the agent associated with
SourceAgentPeripheralNumber is configured in
the ICM software.
DBINT
NULL
TalkTime
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.
in a talking state on the destination device.
TalkTime is a completed call time, not an agent
state time.
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.
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.
Skill_Group, and Agent_Skill_Group
tables, TalkTime does not include
HoldTime; however, in the Services and
Route tables, TalkTime does include
HoldTime.
DBINT
NULL
TimeToAband
The elapsed time in seconds before the call was
abandoned. This can include DelayTime,
LocalQTime, and RingTime, depending on when
the call was abandoned. This value is set only
when the call is not answered by an agent or trunk
resource.
abandoned. This can include DelayTime,
LocalQTime, and RingTime, depending on when
the call was abandoned. This value is set only
when the call is not answered by an agent or trunk
resource.
DBINT
NULL
TimeZone
The time zone used for DateTime. The value is the
offset in minutes from GMT.
offset in minutes from GMT.
DBINT
NULL
Trunk
The number (as known to the peripheral) of the
trunk on which the call arrived.
trunk on which the call arrived.
DBINT
NULL
TrunkGroupID
The identifier of the trunk group on which the call
arrived at the peripheral.
arrived at the peripheral.
DBINT
FK
NULL
UserToUser
ISDN User to User information for a private
network call.
network call.
varchar(131)
NULL
Table 2-368 Termination_Call_Detail Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option