Cisco Cisco IPCC Web Option Technische Referenzen

Seite von 404
 
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.
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.
Depending on who initiated the call, 
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.) 
varchar(40)
NULL
Variable2
Call segmentation variable (maps to Aspect 
variable B).
varchar(40)
NULL
Variable3
Call segmentation variable (maps to Aspect 
variable C).
varchar(40)
NULL
Variable4
Call segmentation variable (maps to Aspect 
variable D).
varchar(40)
NULL
Variable5
Call segmentation variable (maps to Aspect 
variable E).
varchar(40)
NULL
UserToUser
ISDN User to User information for a private 
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.
char(1)
NULL
RecoveryDay
A value used internally by the ICM software to 
track virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to 
track virtual time.
float
AK1, NOT 
NULL
TimeZone
The time zone used for DateTime. The value is 
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