Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-129
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
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.
Table 2-115 Dial_Number_Plan Table Constraints
Constraint
Field Name(s)
PK
DialNumberPlanID
AK-1
RoutingClientID
WildcardPattern
WildcardPattern
FK
DialedNumberID
RoutingClientID
RoutingClientID
Table 2-116 Dial_Number_Plan Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
Description
Additional information about the dial number
plan.
plan.
DESCRIPTION
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.
dial number plan if PostRoute is Y, the dialed
number is used to determine a call type.
DBINT
FK
NULL
DialNumberPlanID
A unique identifier for the plan.
DBINT
PK
NOT NULL
DialNumberPlanType
The type of the plan.
DBINT
NULL
DialString
The dial string if PostRoute setting is N.
VNAME32
NULL
PostRoute
Indicates whether to issue a Post-Routing request
if the dialed number supplied by the agent matches
the WildcardPattern:
if the 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.
DBCHAR
NOT NULL
RoutingClientID
Identifies the routing client associated with the
dial number plan.
dial number plan.
DBSMALLINT
AK-1, FK
NOT 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.
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.
VNAME32
AK-1
NOT NULL