Cisco Cisco Administrative Workstation Referências técnicas
2-413
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Termination_Call_Detail Table
Related Tables:
(AgentSkillTargetID maps to Agent.SkillTargetID; SourceAgentSkillTargetID maps to
Agent.SkillTargetID)
(via CallTypeID)
(via MRDomainID)
(via PeripheralID)
(via RouteID)
(via Day + RouterCallKey)
(SkillGroupSkillTargetID maps to Skill_Group.SkillTargetID)
Termination_Call_Variable.TCDRecoveryKey)
Variable1
First of five variables used for call segmentation.
Can also contain data entered during call wrap-up.
(Maps to Aspect variable A.)
Can also contain data entered during call wrap-up.
(Maps to Aspect variable A.)
varchar(40)
NULL
Variable2
Call segmentation variable (maps to Aspect
variable B).
variable B).
varchar(40)
NULL
Variable3
Call segmentation variable (maps to Aspect
variable C).
variable C).
varchar(40)
NULL
Variable4
Call segmentation variable (maps to Aspect
variable D).
variable D).
varchar(40)
NULL
Variable5
Call segmentation variable (maps to Aspect
variable E).
variable E).
varchar(40)
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
WorkTime
The cumulative number of seconds of after-call
work time associated with the call. After-call work
includes post-call activities such as completing
paperwork or consulting with associates. Work
time is a completed call time, not an agent state
time.
work time associated with the call. After-call work
includes post-call activities such as completing
paperwork or consulting with associates. Work
time is a completed call time, not an agent state
time.
WorkTime is used to calculate Duration in the
Termination_Call_Detail table and HandleTime in
the ICM Service, Route, and Call_Type tables.
Termination_Call_Detail table and HandleTime in
the ICM Service, Route, and Call_Type tables.
DBINT
NULL
WrapupData
Data entered by the agent during call wrap- up.
varchar(40)
NULL
Table 2-368 Termination_Call_Detail Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option