Technical References

Label (page 226) (via LabelID)
Media Routing Domain (page 234) (via MRDomainID)
Route Call Detail (page 278)(via DialedNumberID)
Routing Client (page 297) (via RoutingClientID)
Table 73: Indexes for Dialed_Number Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Dialed_Number
RoutingClientID, DialedNumberStringnonclustered, unique, unique key
located on PRIMARY
XAK2Dialed_Number
LabelIDnonclustered located on PRIMARYXIE1Dialed_Number
CustomerDefinitionIDnonclustered located on PRIMARYXIE2Dialed_Number
DialedNumberIDclustered, unique, primary key
located on PRIMARY
XPKDialed_Number
Fields in Dialed_Number Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central
database.
ChangeStamp
IE-2, FK NULLDBINT
Identifies the customer definition associated with the dialed
number.
CustomerDefinitionID
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y= Yes
• N =No
NULLDESCRIPTION
Additional information about the dialed number.
Description
PK NOT NULLDBINT
A unique identifier for this dialed number.
DialedNumberID
AK-2 NOT NULLVNAME32
The string the routing client passes to the ICM software to
represent this dialed number.
DialedNumberString
AK-1 NOT NULLVNAME32
An enterprise name for the number. This name must be unique
among all dialed numbers in the database.
EnterpriseName
IE-1, FK NULLDBINT
References the default label for this dialed number.
LabelID
FK NOT NULLDBINT
The Media Routing Domain associated with this dialed
number.
MRDomainID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
157
Chapter 2: All Tables
Dialed_Number Table