Cisco Cisco Unified Contact Center Enterprise 9.0(2) テクニカルリファレンス
Each row records information about a routing request received by the ICM software and the
route it choose for it.
route it choose for it.
The ICM software generates a Route_Call_Detail record for every routing request it processes.
Related tables
NetworkTargetID)
(via
DialedNumberID)
CallTypeID)
RoutingClientID)
(RecoveryKey maps to
Route_Call_Variable.RCDRecoveryKey)
Route_Call_Variable.RCDRecoveryKey)
(via RouteID)
(via
Day + RouterCallKey)
FinalObjectID)
(via ScriptID)
Table 159: Indexes for Route_Call_Detail Table
index_keys
index_description
index_name
DateTime
nonclustered located on PRIMARY
XIE1Route_Call_Detail
DbDateTime
nonclustered located on PRIMARY
XIE2Route_Call_Detail
DateTime, RouterCallKey,
RouterCallKeySequenceNumber
RouterCallKeySequenceNumber
clustered located on PRIMARY
XIE3Route_Call_Detail
RecoveryKey
nonclustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKRoute_Call_Detail
Fields in Route_Call_Detail Table:
Keys and
Null Option:
Null Option:
Data Type:
Description:
Field Name:
NULL
VNAME32
Automatic Number Identification, identifies the calling party.
ANI
NULL
DBDATETIME
A new time stamp that indicates when the call entered the current
CallType..
CallType..
BeganCallTypeDateTime
NULL
DBDATETIME
A new time stamp that indicates when the first route request was
received for this call.
received for this call.
BeganRoutingDateTime
NULL
DBINT
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
call. For example, if the ICM software handed the caller off to a
CallSegmentTime
menu of choices, CallSegmentTime reflects the length of time the
caller spent in the menu.
caller spent in the menu.
NULL
image
The ICM software does not populate this field. It is reserved for
future use.
future use.
CallTrace
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
279
Chapter 2: All Tables
Route_Call_Detail Table