Cisco Cisco IP Contact Center Release 4.6.1 Technical References

2-392

Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)

Chapter 2 Table Details

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-367 Termination_Call_Detail Table Constraints

Constraint

Field Name(s)

AK-1

RecoveryKey

AK-2

DateTime
PeripheralID
ICRCallKey

AgentSkillTargetID
MRDomainID
NetworkTargetID
PeripheralID
RouteID
SkillGroupSkillTargetID
SkillSkillTargetID
TrunkGroupID

IE-1

DateTime

IE-2

DbDateTime

Table 2-368 Termination_Call_Detail Table

Field Name

Description

Data Type

Keys and
Null Option

AgentPeripheralNumber

The peripheral number of the agent that the call.

varchar(32)

NULL

AgentSkillTargetID

Identifies which agent andled 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 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.

DBINT

NULL

ANI

The ANI value for the call.

varchar(32)

NULL