Cisco Cisco IPCC Web Option Technical References
2-158
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Route_Call_Detail Table
Route_Call_Detail Table
Central database only.
Each row records information about a routing request received by the ICM software and the route it
choose for it.
choose for it.
The ICM software generates a Route_Call_Detail record for every routing request it processes.
Table 2-139 Route_Call_Detail Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DialedNumberID
Foreign key from the Dialed Number table.
int
FK, NULL
RouterCallKeyDay
The day that the call was taken and the
Route_Call_Detail record was created. This field
contains a value only for calls that were
translation-routed or post-routed to or from an
ACD. Together with RouterCallKey, the
RouterCallKeyDay value forms a unique 64-bit
key for the call. If possible, the Peripheral
Gateway uses this key in the termination call
detail. The PG might not have this information
for all calls, but if it does, it allows you to track
all states of a call between the Route_Call_Detail
and the Termination_Call_Detail tables by using
the Cradle-to-Grave call tracking facility.
Route_Call_Detail record was created. This field
contains a value only for calls that were
translation-routed or post-routed to or from an
ACD. Together with RouterCallKey, the
RouterCallKeyDay value forms a unique 64-bit
key for the call. If possible, the Peripheral
Gateway uses this key in the termination call
detail. The PG might not have this information
for all calls, but if it does, it allows you to track
all states of a call between the Route_Call_Detail
and the Termination_Call_Detail tables by using
the Cradle-to-Grave call tracking facility.
int
NOT NULL
RouterCallKey
A call key counter created and set by the ICM
software. This value forms the unique portion of
the 64-bit key for the call. The ICM software
resets this counter at midnight.
software. This value forms the unique portion of
the 64-bit key for the call. The ICM software
resets this counter at midnight.
int
NOT NULL
RouteID
Foreign key from the Route table. This ICM
software identifier specifies the route where the
call was sent. A route is a value returned by a
routing script that maps to a target at a peripheral.
This target can be a service, skill group, agent, or
translation route. The value (for example, 6), is
unique among all routes in the enterprise. It is
taken from the Route table in the ICM central
database. Route IDs are generated automatically
when a route is configured in the Route
Configuration window of Configure ICM.
software identifier specifies the route where the
call was sent. A route is a value returned by a
routing script that maps to a target at a peripheral.
This target can be a service, skill group, agent, or
translation route. The value (for example, 6), is
unique among all routes in the enterprise. It is
taken from the Route table in the ICM central
database. Route IDs are generated automatically
when a route is configured in the Route
Configuration window of Configure ICM.
int
FK, NULL
DateTime
The date and time when the call was routed.
datetime
IE1, NOT NULL
RequestType
Type of request:
1 = Pre-Routing
2 = Blind transfer or network VRU
3 = Announced transfer or MCI 800
number
4 = Overflow
5 = Re- route
6 = Post-Routing
2 = Blind transfer or network VRU
3 = Announced transfer or MCI 800
number
4 = Overflow
5 = Re- route
6 = Post-Routing
smallint
NOT NULL