Technical References

Keys and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
The time zone used for DateTime. The value is the offset in minutes
from UTC (formerly called GMT).
TimeZone
NULLDBINT
The number (as known to the peripheral) of the trunk on which the call
arrived.
Trunk
FK NULLDBINT
The identifier of the trunk group on which the call arrived at the
peripheral.
TrunkGroupID
NULLvarchar(131)
ISDN User to User information for a private network call.
UserToUser
NULLvarchar(40)
First of five variables used for call segmentation. Can also contain data
entered during call wrap-up. (Maps to Aspect variable A.)
Variable1
NULLvarchar(40)
Call segmentation variable (maps to Aspect variable B).
Variable2
NULLvarchar(40)
Call segmentation variable (maps to Aspect variable C).
Variable3
NULLvarchar(40)
Call segmentation variable (maps to Aspect variable D).
Variable4
NULLvarchar(40)
Call segmentation variable (maps to Aspect variable E).
Variable5
NULLvarchar(40)
Call segmentation variable.
Variable6
NULLvarchar(40)
Call segmentation variable.
Variable7
NULLvarchar(40)
Call segmentation variable.
Variable8
NULLvarchar(40)
Call segmentation variable.
Variable9
NULLvarchar(40)
Call segmentation variable.
Variable10
NULLDBINT
The cumulative number of seconds of after-call work time associated
with the call. After-call work includes post-call activities such as
WorkTime
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.
NULLvarchar(40)
Data entered by the agent during call wrap- up.
WrapupData
WorkTime is used to calculate Duration in the Termination_Call_Detail
table and HandleTime in the ICM Service, Route, and Call_Type tables.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
416
Chapter 2: All Tables
Termination_Call_Detail Table