Cisco Cisco IP Contact Center Release 4.6.1 Références techniques

NULL

DBINT

The time zone used for DateTime. The value is the offset in minutes
from UTC (formerly called GMT).

TimeZone

NULL

DBINT

The number (as known to the peripheral) of the trunk on which the call
arrived.

Trunk

FK NULL

DBINT

The identifier of the trunk group on which the call arrived at the
peripheral.

TrunkGroupID

NULL

varchar(131)

ISDN User to User information for a private network call.

UserToUser

NULL

varchar(40)

First of five variables used for call segmentation. Can also contain data
entered during call wrap-up. (Maps to Aspect variable A.)

Variable1

NULL

varchar(40)

Call segmentation variable (maps to Aspect variable B).

Variable2

NULL

varchar(40)

Call segmentation variable (maps to Aspect variable C).

Variable3

NULL

varchar(40)

Call segmentation variable (maps to Aspect variable D).

Variable4

NULL

varchar(40)

Call segmentation variable (maps to Aspect variable 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 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.

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.

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)