Technical References

Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBCHAR
Used to indicate if remote routing by a CTI client (ACMI) is
permitted on this dialed number.
PermitApplicationRouting
Default = 'N'.
NOT NULLDBCHAR
Used for queuing on the Simplified IPCC PG only.
ReservedByIVR
Stored as 'Y' or 'N'. Default = 'N'.
AK-2, FK NOT NULLDBSMALLINT
References the routing client that services this dialed number.
RoutingClientID
Dialed_Number_Label Table
This table is in the Route category (page 447). To see database rules for these tables, click here
(page 507).
It indicates which Label values are valid for each Dialed_Number value. Use ICM Configuration
Manager to add, update, and delete Dialed_Number_Label records.
Related tables
Dialed Number (page 156) (via DialedNumberID)
Label (page 226) (via LabelID)
Table 74: Indexes for Dialed_Number_Label Table
index_keysindex_descriptionindex_name
LabelIDnonclustered located on PRIMARYXIE1Dialed_Number_Label
DialedNumberID, LabelIDclustered, unique, primary key
located on PRIMARY
XPKDialed_Number_Label
Fields in Dialed_Number_Label Table:
Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
Foreign key from the Dialed Number table.
DialedNumberID
PK, FK NOT NULLDBINT
Foreign key from the Label table.
LabelID
Dialed_Number_Map Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
158
Chapter 2: All Tables
Dialed_Number_Label Table