Cisco Cisco Administrative Workstation Technical References
2-261
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Termination_Call_Detail Table
Termination_Call_Detail Table
Central database only.
Contains information about how each call was handled at a peripheral.
The ICM software generates a Termination_Call_Detail record for each call that arrives at the peripheral.
Table 2-180 Termination_Call_Detail Table
Field Name
Description
Data Type
Keys and Null
Option
Option
MRDomainID
An identifier for the Media Routing Domain in
the ICM system configuration.
the ICM system configuration.
int
FK, NULL
AgentSkillTargetID
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 Agent table in the ICM central database.
AgentSkillTargetIDs are generated
automatically when the agent is first
configured in the Agent Configuration window
of Configure ICM.
value (for example, 5001), is unique among all
skill targets in the enterprise. It is taken from
the Agent table in the ICM central database.
AgentSkillTargetIDs are generated
automatically when the agent is first
configured in the Agent Configuration window
of Configure ICM.
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.
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.
int
FK, NULL
SkillGroupSkillTargetID
Identifies which skill group handled the call.
This value (for example, 10) 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 Configure ICM.
This value (for example, 10) 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 Configure ICM.
If the call is handled by a non-configured skill
group, this field is set to null.
group, this field is set to null.
int
FK, NULL
ServiceSkillTargetID
Identifies which service handled the call. This
value (for example, 4), is unique among all
skill targets in the enterprise. It is taken from
the Service table in the ICM central database.
ServiceSkillTargetIDs are generated
automatically when a service is configured in
the Service Configuration window of
Configure ICM. 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).
value (for example, 4), is unique among all
skill targets in the enterprise. It is taken from
the Service table in the ICM central database.
ServiceSkillTargetIDs are generated
automatically when a service is configured in
the Service Configuration window of
Configure ICM. 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).
int
FK, NULL