Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Dial_Number_Plan Table
category. For database rules, click
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. Use ICM Configuration Manager to
add, update, and delete Dial_Number_Plan records.
to 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
(via DialedNumberID)
(via RoutingClientID)
Table 76: Indexes for Dial_Number_Plan Table
index_keys
index_description
index_name
RoutingClientID, WildcardPattern
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Dial_Number_Plan
DialNumberPlanID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKDial_Number_Plan
Fields in Dial_Number_Plan Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central
database.
database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the dial number plan.
Description
FK NULL
DBINT
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.
DialedNumberID
PK NOT NULL
DBINT
A unique identifier for the plan.
DialNumberPlanID
NULL
DBINT
The type of the plan.
DialNumberPlanType
NULL
VNAME32
he dial string if PostRoute setting is N.
DialString
NOT NULL
DBCHAR
Indicates whether to issue a Post-Routing request if
the dialed number supplied by the agent matches the
WildcardPattern:
the dialed number supplied by the agent matches the
WildcardPattern:
PostRoute
• Y = Yes, issue a Post-Routing request.
• N = No, do not issue a Post-Routing request.
AK-1, FK NOT
NULL
NULL
DBSMALLINT
Identifies the routing client associated with the dial
number plan.
number plan.
RoutingClientID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
129
Chapter 2: All Tables
Dial_Number_Plan Table