Technical References

Keys and
Null Option:
Data Type:Description:Field Name:
NOT NULLDBINT
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.
RouterCallKey
NOT NULLDBINT
A value indicating the day that the call was recievedand the
Route_Call_Detail record was created.
RouterCallKeyDay
NULLDBINT
A sequence number used for ordering rows for cradle-to-grave call
tracking. This number defines the order in which the route requests
RouterCallKeySequenceNumber
were created. This is not the order in which the Route_Call_Detail
records were created. For PG routing clients, this field defines the
Termination_Call_Detail instance that initiated the route request.
NULLDBSMALLINT
Error code from the ICM CallRouter process. For information about
a specific Router ErrorCode, refer to the Error Messages section of
the ICM Master Help.
RouterErrorCode
NULLDBINT
Number of seconds the call was held in the CallRouter queue.
RouterQueueTime
NULLDBINT
Call counter generated by the routing client in a private network.
The counter occasionally resets, so duplicate values do occur.
RoutingClientCallKey
FK NOT NULLDBSMALLINT
Foreign key from the Routing Client table. This is a unique identifier
for this routing client. The routing client ID is generated
RoutingClientID
automatically when the routing client is configured in the Routing
Client Configuration window of ICM Configuration Manager.
FK NULLDBINT
Foreign key from Script table. Indicates the script used to route the
call. This unique identifier is generated automatically by the ICM
software.
ScriptID
NULLVNAME32
The label associated with the ultimate target at the switch. For a
translation routed call, this is the label of the final destination, not
TargetLabel
of the translation route itself. If the label for the call is configured,
this will be the same as the Label field of the label specified by
TargetLabelID. If the label for the call is not configured, this is the
final label for the call and TargetLabelID will be NULL.
NULLDBINT
The label associated with the ultimate target at the switch. For a
translation routed call, this is the label of the final destination, not
of the translation route itself.
TargetLabelID
NULLDBINT
A numeric value representing the execution result of the routing
script. To see the list of values, click here (page 481).
TargetType
NULLDBINT
The time zone of the Central Controller used for DateTime.
TimeZone
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
282
Chapter 2: All Tables
Route_Call_Detail Table