Technical References

Each row records information about a routing request received by the ICM software and the
route it choose for it.
The ICM software generates a Route_Call_Detail record for every routing request it processes.
Related tables
Network Target (page 238) (via
NetworkTargetID)
Dialed Number (page 156) (via
DialedNumberID)
Call Type (page 74) (via
CallTypeID)
Routing Client (page 297) (via
RoutingClientID)
Route_Call_Variable (page 283)
(RecoveryKey maps to
Route_Call_Variable.RCDRecoveryKey)
Route (page 277) (via RouteID)
Termination Call Detail (page 407) (via
Day + RouterCallKey)
Script Cross Reference (page 318) (via
FinalObjectID)
Script (page 317) (via ScriptID)
Table 159: Indexes for Route_Call_Detail Table
index_keysindex_descriptionindex_name
DateTimenonclustered located on PRIMARYXIE1Route_Call_Detail
DbDateTimenonclustered located on PRIMARYXIE2Route_Call_Detail
DateTime, RouterCallKey,
RouterCallKeySequenceNumber
clustered located on PRIMARYXIE3Route_Call_Detail
RecoveryKeynonclustered, unique, primary key
located on PRIMARY
XPKRoute_Call_Detail
Fields in Route_Call_Detail Table:
Keys and
Null Option:
Data Type:Description:Field Name:
NULLVNAME32
Automatic Number Identification, identifies the calling party.
ANI
NULLDBDATETIME
A new time stamp that indicates when the call entered the current
CallType..
BeganCallTypeDateTime
NULLDBDATETIME
A new time stamp that indicates when the first route request was
received for this call.
BeganRoutingDateTime
NULLDBINT
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
CallSegmentTime
menu of choices, CallSegmentTime reflects the length of time the
caller spent in the menu.
NULLimage
The ICM software does not populate this field. It is reserved for
future use.
CallTrace
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
279
Chapter 2: All Tables
Route_Call_Detail Table