Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and
Null
Option:
Null
Option:
Data Type:
Description:
Field Name:
NULL
varchar(40)
Call segmentation variable (maps to Aspect variable
D).
D).
Variable4
NULL
varchar(40)
Call segmentation variable (maps to Aspect variable
E).
E).
Variable5
NULL
varchar(40)
Call segmentation variable.
Variable6
NULL
varchar(40)
Call segmentation variable.
Variable7
NULL
varchar(40)
Call segmentation variable.
Variable8
NULL
varchar(40)
Call segmentation variable.
Variable9
NULL
varchar(40)
Call segmentation variable.
Variable10
NULL
DBINT
The cumulative number of seconds of after-call work
time associated with the call. After-call work includes
time associated with the call. After-call work includes
WorkTime
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.
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.
NULL
varchar(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.
Termination_Call_Detail table and HandleTime in the
ICM Service, Route, and Call_Type tables.
Termination_Call_Variable Table
Central database only.
Each row records the value of an expanded call variable for a call handled at a peripheral. If the
expanded call variable is an array, one Termination_Call_Variable row is generated for each
element of the array.
expanded call variable is an array, one Termination_Call_Variable row is generated for each
element of the array.
The ICM software generates a Termination_Call_Variable record for each enabled expanded
call variable for every call processed at a peripheral.
call variable for every call processed at a peripheral.
This table can become very large. Running custom reporting queries against it while it is on the
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
352
Chapter 2: - All Tables
Termination_Call_Variable Table