Cisco Cisco IP Contact Center Release 4.6.1 Technische Referenzen
2-277
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Termination_Call_Detail Table
NetworkTargetID
The identifier of the peripheral target to which
the call was delivered.
the call was delivered.
int
FK, NULL
TrunkGroupID
The identifier of the trunk group on which the
call arrived at the peripheral.
call arrived at the peripheral.
int
FK, NULL
DNIS
The DNIS value that arrived with the call.
varchar(32)
NULL
InstrumentPortNumber
Instrument number or extension number of the
device that handled the call at the peripheral.
device that handled the call at the peripheral.
int
NULL
AgentPeripheralNumber
The peripheral number of the agent that
handled the call.
handled the call.
varchar(32)
NULL
ICRCallKey
A unique number generated at the PG. Values
are reused after about 250 million calls.
are reused after about 250 million calls.
int
AK2, NULL
ICRCallKeyParent
Link to the ICRCallKey field of a parent call
(used for transfers and conference calls).
(used for transfers and conference calls).
int
NULL
ICRCallKeyChild
Link to the ICRCallKey field of a child call
(used for transfers and three-way conference
calls).
(used for transfers and three-way conference
calls).
int
NULL
Variable6
Call segmentation variable.
varchar(40)
NULL
Variable7
Call segmentation variable.
varchar(40)
NULL
Variable8
Call segmentation variable.
varchar(40)
NULL
Variable9
Call segmentation variable.
varchar(40)
NULL
Variable10
Call segmentation variable.
varchar(40)
NULL
ANI
The ANI value for the call.
varchar(32)
NULL
AnsweredWithinServiceLevel
Indicates whether the call was answered with
the service level defined for the service: Y =
yes; N= no.
the service level defined for the service: Y =
yes; N= no.
char(1)
NULL
Priority
Used by the DEFINITY ECS to indicate the
priority of the call.
priority of the call.
smallint
NULL
Trunk
The number (as known to the peripheral) of the
trunk on which the call arrived.
trunk on which the call arrived.
int
NULL
WrapupData
Data entered by the agent during call wrap- up. varchar(40)
NULL
SourceAgentPeripheralNumber
Peripheral number of agent that initiated the
call.
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.
call. This value is set only if the agent
associated with
SourceAgentPeripheralNumber is configured
in the ICM software.
int
NULL
CallDispositionFlag
A series of flags providing detail on the call
disposition.
disposition.
int
NULL
Table 2-180 Termination_Call_Detail Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option