Technical References

Keys and
Null Option:
Data Type:Description:Field Name:
FK NULLDBINT
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.
CallTypeID
NULLvarchar(30)
Customer Database Provided Digits. Can be used to track the call
from the public network to the peripheral. ISDN is required to carry
the information to the switch.
CDPD
NULLvarchar(30)
Caller-Entered Digits.
CED
IE-1 NOT NULLDBDATETIME
The date and time when the call was routed.
DateTime
IE-2 NULLDBDATETIME
The current date and time stamp when the records are written to the
HDS database. The logger database has NULL for this column.
DbDateTime
FK NULLDBINT
Foreign key from the Dialed Number table.
DialedNumberID
NULLVNAME32
The dialed number for the call. If the dialed number for the call is
configured, this will be the same as the DialedNumberString of the
DialedNumberString
dialed number specified by DialedNumberID. If the dialed number
for the call is not configured, this is the dialed number string and
DialedNumberID will be NULL.
NULLDBINT
Identifies the node ID of the last script node executed to route the
call.
FinalObjectID
NULLVNAME32
Identifies the label that was passed to the routing client. For a
translation routed call, this is the label for the translation route, not
Label
the ultimate destination. If the label passed to the routing client for
the call is configured, this will be the same as the Label field of the
label specified by LabelID. If the label for the call is not configured,
this is the label passed back to the routing client and the LabelID
will be NULL.
FK NULLDBINT
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.
LabelID
NULLDBINT
An identifier for the Media Routing Domain in the ICM system
configuration
MRDomainID
NULLDBSMALLINT
The originator of the request:
MsgOrigin
• - 1 = Unspecified
• 1 = Switch
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
280
Chapter 2: All Tables
Route_Call_Detail Table