Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-127
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Dialed_Number_Map Table
Dialed_Number_Map Table
Describes the call qualifier values (dialed number, calling line ID, and caller-entered digits) associated
with each call type.
with each call type.
Use the Call Type Directory dialog of the Script Editor to add, update, and delete Dialed_Number_Map
records.
records.
Table 2-113 Dialed_Number_Map Table Constraints
Constraint
Field Name(s)
PK
DialedNumberID
Item
Item
FK
CallTypeID
DialedNumberID
RegionID
DialedNumberID
RegionID
IE-1
CallTypeID
RegionID
RegionID
Table 2-114 Dialed_Number_Map Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ANIWildCard
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.
prefix of any length (the leading digits of the
telephone number) or a complete telephone
number.
varchar(30)
NULL
ANIWildCardType
Indicates what type the ANIWildCard is:
0 = Unknown
1 = NPA
2 = NPANXX
3 = 10-digit telephone number
4 = Region
5 = Match all
6 = Prefix
1 = NPA
2 = NPANXX
3 = 10-digit telephone number
4 = Region
5 = Match all
6 = Prefix
DBSMALLINT
NOT NULL
CallTypeID
Foreign key from Call Type table.
DBINT
FK
NOT NULL
CEDWildCard
Value to match against CED:
‘_A’ = All
‘_NR’ = None Required
‘_NE’ = None Entered
‘_N’ = None Required or Entered
‘_NR’ = None Required
‘_NE’ = None Entered
‘_N’ = None Required or Entered
varchar(30)
NULL
Description
Additional information about the mapping of these
call qualifiers to this call type.
call qualifiers to this call type.
DESCRIPTION
NULL