Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-76
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Dialed_Number Table
Dialed_Number Table
Each row describes a dialed number serviced by the ICM software.
Use ICM Configuration Manager to add, update, and delete Dialed_Number records.
Related tables:
Customer Definition (via CustomerDefinitionID)
Dialed Number Label (via DialedNumberID)
Dialed Number Map (via DialedNumberID)
Label (via LabelID)
Media Routing Domain (via MRDomainID)
Route Call Detail (via DialedNumberID)
Routing Client (via RoutingClientID)
Table 2-60 Dialed Number Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DialedNumberID
A unique identifier for this dialed number.
int
PK, NOT NULL
CustomerDefinitionID
Identifies the customer definition associated with the
dialed number.
dialed number.
int
IE2, FK, NULL
LabelID
References the default label for this dialed number.
int
IE1, FK, NULL
EnterpriseName
An enterprise name for the number. This name must be
unique among all dialed numbers in the database.
unique among all dialed numbers in the database.
varchar(32)
AK1, NOT
NULL
NULL
RoutingClientID
References the routing client that services this dialed
number.
number.
smallint
AK2, FK, NOT
NULL
NULL
DialedNumberString
The string the routing client passes to the ICM software to
represent this dialed number.
represent this dialed number.
varchar(32)
AK2, NOT
NULL
NULL
Description
Additional information about the dialed number.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
char(1)
NOT NULL
MRDomainID
The Media Routing Domain associated with this dialed
number.
number.
int
FK NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL