Cisco Cisco IPCC Web Option Technical References

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.

Dialed Number (via DialedNumberID)

Routing Client (via RoutingClientID)

DialNumberPlanID

A unique identifier for the plan.

int

PK, NOT NULL

RoutingClientID

Identifies the routing client associated with the dial 
number plan.

smallint

FK, AK1, 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.

varchar(32)

AK1, NULL

PostRoute

Indicates whether to issue a Post-Routing request 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.

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.

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.

int

NOT NULL