Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-77
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Dialed_Number_Label Table
Dialed_Number_Label Table
Indicates which Label values are valid for each Dialed_Number value.
Use ICM Configuration Manager to add, update, and delete Dialed_Number_Label records.
Related tables:
Dialed Number (via DialedNumberID)
Label (via LabelID)
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-61 Dialer_Number_Label Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DialedNumberID
Foreign key from the Dialed Number table.
int
PK, FK, NOT
NULL
NULL
LabelID
Foreign key from the Label table.
int
PK, FK, NOT
NULL
NULL
Table 2-62 Dialer_Number_Map Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DialedNumberID
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 and Item together form an alternate key
that is used by the ICM software to determine the order in
which to match the wildcards.
int
PK, FK, NOT
NULL
NULL
Item
The order in which the rows for a dialed number are tested
against the call qualifiers.
against the call qualifiers.
int
PK, NOT NULL
CallTypeID
Foreign key from Call Type table.
int
FK, NOT NULL
RegionID
If ANIWildCardType is 4 (Region), this is the foreign key
of the region from the Region table.
of the region from the Region table.
int
FK, 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