Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-276
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Termination_Call_Detail Table
CallSegmentTime
Time, in seconds, that the system took to
segment a private network call. For example, if
the ICM software handed the caller off to a
menu of choices, CallSegmentTime reflects
how long the caller spent in the menu.
segment a private network call. For example, if
the ICM software handed the caller off to a
menu of choices, CallSegmentTime reflects
how long the caller spent in the menu.
int
NULL
ConferenceTime
The cumulative number of seconds that the call
was in conference with more than two parties.
ConferenceTime is recorded for both ACD and
non-ACD calls. The value includes any
HoldTime associated with the call. It is updated
when the agent drops off the call or the call
becomes a simple two-party call.
was in conference with more than two parties.
ConferenceTime is recorded for both ACD and
non-ACD calls. The value includes any
HoldTime associated with the call. It is updated
when the agent drops off the call or the call
becomes a simple two-party call.
Depending on who initiated the call,
ConferenceTime from
Termination_Call_Detail is used in the
following Skill Group and Agent Skill Group
tables:
ConferenceTime from
Termination_Call_Detail is used in the
following Skill Group and Agent Skill Group
tables:
- ConferencedOutCallsTimeToHalf
- ConferencedInCallsTimeToHalf
int
NULL
Variable1
First of five variables used for call
segmentation. Can also contain data entered
during call wrap-up. (Maps to Aspect variable
A.)
segmentation. 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
UserToUser
ISDN User to User information for a private
network call.
network call.
varchar(131)
NULL
NewTransaction
Call has been re-classified via transfer,
overflow, or new transaction. Indicates that
there is at least one more row in Termination
Call Detail for this call.
overflow, or new transaction. Indicates that
there is at least one more row in Termination
Call Detail for this call.
char(1)
NULL
RecoveryDay
A value used internally by the ICM software to
track virtual time.
track virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to
track virtual time.
track virtual time.
float
AK1, NOT
NULL
NULL
TimeZone
The time zone used for DateTime. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
int
NULL
Table 2-180 Termination_Call_Detail Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option