Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
FK NULLDBINT
If ANIWildCardType is 4 (Region), this is the foreign key of the region
from the Region table.
RegionID
Dial_Number_Plan Table
This is in the Device (page 441) category. For database rules, click here (page 504).
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.
Related tables
Dialed Number (page 156) (via DialedNumberID)
Routing Client (page 297) (via RoutingClientID)
Table 76: Indexes for Dial_Number_Plan Table
index_keysindex_descriptionindex_name
RoutingClientID, WildcardPatternnonclustered, unique, unique key
located on PRIMARY
XAK1Dial_Number_Plan
DialNumberPlanIDclustered, unique, primary key
located on PRIMARY
XPKDial_Number_Plan
Fields in Dial_Number_Plan Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the dial number plan.
Description
FK NULLDBINT
Identifies the dialed number associated with the dial number plan if
PostRoute is Y, the dialed number is used to determine a call type.
DialedNumberID
PK NOT NULLDBINT
A unique identifier for the plan.
DialNumberPlanID
NULLDBINT
The type of the plan.
DialNumberPlanType
NULLVNAME32
he dial string if PostRoute setting is N.
DialString
NOT NULLDBCHAR
Indicates whether to issue a Post-Routing request if the dialed number
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