Cisco Cisco IP Contact Center Release 4.6.1 Références techniques
2-160
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Route_Call_Detail Table
CED
Caller-Entered Digits.
varchar(30)
NULL
ScriptID
Foreign key from Script table. Indicates the script
used to route the call. This unique identifier is
generated automatically by the ICM software.
used to route the call. This unique identifier is
generated automatically by the ICM software.
int
FK, NULL
FinalObjectID
Identifies the last script node executed to route
the call.
the call.
int
NULL
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 the length of
time the caller spent in the menu.
a private network call. For example, if the ICM
software handed the caller off to a menu of
choices, CallSegmentTime reflects the length of
time the caller spent in the menu.
int
NULL
NetQTime
Time in seconds the call spent in a network
queue.
queue.
int
NULL
CallTypeID
Foreign key from Call Type table. If a script
changed the call type, this is the final call type for
the call. This unique identifier is generated
automatically by the ICM software.
changed the call type, this is the final call type for
the call. This unique identifier is generated
automatically by the ICM software.
int
FK, NULL
RouterErrorCode
Error code from the ICM CallRouter process.
smallint
NULL
CallTrace
A trace of all script nodes traversed by the call.
The ICM software produces this information only
if a debugging option is set.
The ICM software produces this information only
if a debugging option is set.
image
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 of the Central Controller used for
DateTime.
DateTime.
int
NULL
NetworkTargetID
Identifies the skill target that was chosen by the
ICM software.
ICM software.
int
FK, NULL
LabelID
Identifies the label that was passed to the routing
client. For a translation routed call, this is the
label for the translation route, not the ultimate
destination.
client. For a translation routed call, this is the
label for the translation route, not the ultimate
destination.
int
FK, NULL
Originator
The origin of the route request.
varchar(8)
NULL
Variable6
Call segmentation variable.
varchar(40)
NULL
Variable7
Call segmentation variable.
varchar(40)
NULL
Variable8
Call segmentation variable.
varchar(40)
NULL
Variable9
Call segmentation variable.
varchar(40)
NULL
Variable10
Call segmentation variable.
varchar(40)
NULL
Table 2-139 Route_Call_Detail Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option