Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
FK NULL
DBINT
If ANIWildCardType is 4 (Region), this is the foreign key of the region
from the Region table.
from the Region table.
RegionID
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.
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.
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:
supplied by the agent matches the WildcardPattern:
PostRoute
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
160
Chapter 2: All Tables
Dial_Number_Plan Table