Technical References

Describes the call qualifier values (dialed number, calling line ID, and caller-entered digits)
associated with each call type. Use the Call Type Directory dialog of the Script Editor to add,
update, and delete Dialed_Number_Map records.
Related tables
Call Type (page 74) (via CallTypeID)
Dialed Number (page 156) (via DialedNumberID)
Region (page 272) (via RegionID)
Table 75: Indexes for Dialed_Number_Map Table
index_keysindex_descriptionindex_name
CallTypeID, RegionIDnonclustered located on PRIMARYXIE1Dialed_Number_Map
DialedNumberID, Itemclustered, unique, primary key
located on PRIMARY
XPKDialed_Number_Map
Fields in Dialed_Number_Map Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLvarchar(30)
ANI value or region name. An ANI value can be a prefix of any length
(the leading digits of the telephone number) or a complete telephone
number.
ANIWildCard
NOT NULLDBSMALLINT
Indicates what type the ANIWildCard is. To see the list of values, click
here (page 471).
ANIWildCardType
FK NOT NULLDBINT
Foreign key from Call Type table.
CallTypeID
NULLvarchar(30)
Value to match against CED:
CEDWildCard
• ‘_A’ = All
• ‘_NR’= None Required
• ‘_NE’ = None Entered
• ‘_N’ = None Required or Entered
NULLDESCRIPTION
Additional information about the mapping of these call qualifiers to
this call type.
Description
PK, FK NOT NULLDBINT
Foreign key from the Dialed Number table. DialedNumberID and Item
together form an alternate key that is used by the ICM software to
determine the order in which to match the wildcards.
DialedNumberID
PK NOT NULLDBINT
The order in which the rows for a dialed number are tested against the
call qualifiers.
Item
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
159
Chapter 2: All Tables
Dialed_Number_Map Table