Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-75
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Dial_Number_Plan Table
Dial_Number_Plan Table
Defines special dialing codes that allow enterprise agents to use the ICM software to place calls to
services, other agents, skill groups, enterprise skill groups, supervisors, the local public network, a
long-distance network, or to specific trunks.
services, other agents, skill groups, enterprise skill groups, supervisors, the local public network, a
long-distance network, or to specific trunks.
Use ICM Configuration Manager to add, update, and delete Dial_Number_Plan records.
Related tables:
Dialed Number (via DialedNumberID)
Routing Client (via RoutingClientID)
Table 2-59 Dialer_Number_Plan Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DialNumberPlanID
A unique identifier for the plan.
int
PK, NOT NULL
RoutingClientID
Identifies the routing client associated with the dial
number plan.
number plan.
smallint
FK, AK1, NOT
NULL
NULL
WildcardPattern
A string the ICM software compares to the dialed number
or dial string. The string can contain letters, digits,
asterisks (*), and number signs (#). It can also include the
wildcard characters ? and !. The ? character represents any
single letter. The ! character represents any string of
characters and can appear only at the end of the pattern.
or dial string. The string can contain letters, digits,
asterisks (*), and number signs (#). It can also include the
wildcard characters ? and !. The ? character represents any
single letter. The ! character represents any string of
characters and can appear only at the end of the pattern.
varchar(32)
AK1, NULL
PostRoute
Indicates whether to issue a Post-Routing request if the
dialed number supplied by the agent matches the
WildcardPattern:
dialed number supplied by the agent matches the
WildcardPattern:
Y = Yes, issue a Post-Routing request.
N = No, do not issue a Post-Routing request.
N = No, do not issue a Post-Routing request.
char(1)
NOT NULL
DialNumberPlanType
The type of the plan.
int
NULL
Description
Additional information about the dial number plan.
varchar(255)
NULL
DialedNumberID
Identifies the dialed number associated with the dial
number plan if PostRoute is Y, the dialed number is used
to determine a call type.
number plan if PostRoute is Y, the dialed number is used
to determine a call type.
int
FK, NULL
DialString
The dial string if PostRoute setting is N.
varchar(32)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL