Cisco Cisco E-Mail Manager Unity Integration Option Technical References
Keys and
Null Option:
Null Option:
Data Type:
Description:
Field Name:
FK NULL
DBINT
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.
this is the final call type for the call. This unique identifier is
generated automatically by the ICM software.
CallTypeID
NULL
varchar(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.
from the public network to the peripheral. ISDN is required to carry
the information to the switch.
CDPD
NULL
varchar(30)
Caller-Entered Digits.
CED
IE-1 NOT NULL
DBDATETIME
The date and time when the call was routed.
DateTime
IE-2 NULL
DBDATETIME
The current date and time stamp when the records are written to the
HDS database. The logger database has NULL for this column.
HDS database. The logger database has NULL for this column.
DbDateTime
FK NULL
DBINT
Foreign key from the Dialed Number table.
DialedNumberID
NULL
VNAME32
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
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.
for the call is not configured, this is the dialed number string and
DialedNumberID will be NULL.
NULL
DBINT
Identifies the node ID of the last script node executed to route the
call.
call.
FinalObjectID
NULL
VNAME32
Identifies the label that was passed to the routing client. For a
translation routed call, this is the label for the translation route, not
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.
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 NULL
DBINT
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.
translation routed call, this is the label for the translation route, not
the ultimate destination.
LabelID
NULL
DBINT
An identifier for the Media Routing Domain in the ICM system
configuration
configuration
MRDomainID
NULL
DBSMALLINT
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