Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-124
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
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.
Table 2-109 Dialed Number Table Constraints
Constraint
Field Name(s)
PK
DialedNumberID
AK-1
EnterpriseName
AK-2
DialedNumberString
RoutingClientID
RoutingClientID
FK
CustomerDefinitionID
LabelID
MRDomainID
RoutingClientID
LabelID
MRDomainID
RoutingClientID
IE-1
LabelID
IE-2
CustomerDefinitionID
Table 2-110 Dialed Number Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
CustomerDefinitionID
Identifies the customer definition associated with
the dialed number.
the dialed number.
DBINT
IE-2, FK
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
Description
Additional information about the dialed number.
DESCRIPTION
NULL
DialedNumberID
A unique identifier for this dialed number.
DBINT
PK
NOT NULL
DialedNumberString
The string the routing client passes to the ICM
software to represent this dialed number.
software to represent this dialed number.
VNAME32
AK-2
NOT NULL
EnterpriseName
An enterprise name for the number. This name
must be unique among all dialed numbers in the
database.
must be unique among all dialed numbers in the
database.
VNAME32
AK-1
NOT NULL
LabelID
References the default label for this dialed
number.
number.
DBINT
IE-1, FK
NULL