Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Table 72: Indexes for Device_Target Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Device_Target
DeviceAddressType, GlobalAddress
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK2Device_Target
NetworkTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKDevice_Target
Fields in Device_Target Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central
database.
database.
ChangeStamp
NULL
varchar(255)
An optional string to be sent to the device during
initialization.
initialization.
ConfigParam
NULL
DESCRIPTION
Additional information about the device target.
Description
AK-2 NOT NULL
DBINT
Type of address defined in the GlobalAddressfield: 1
= Internet Protocol (IP).
= Internet Protocol (IP).
DeviceAddressType
NOT NULL
DBINT
The type of the target.
DeviceTargetType
AK-1 NOT NULL
VNAME32
An enterprise name for the target. This name must be
unique among all device targets in the enterprise.
unique among all device targets in the enterprise.
EnterpriseName
AK-2 NOT NULL
varchar(64)
A unique identifier. This field is used to enforce
validation that the agent desktop and the agent phone
validation that the agent desktop and the agent phone
GlobalAddress
are at the same IP address for media terminated agent
desktops, including Enterprise Agent. The decimal
format for an IP address is xxx.xxx.xxx.xxx. For
example, 128.127.500.224. If validating the IP address
of an agent desktop and agent phone is not the case,
then the global address can be set to any unique string.
desktops, including Enterprise Agent. The decimal
format for an IP address is xxx.xxx.xxx.xxx. For
example, 128.127.500.224. If validating the IP address
of an agent desktop and agent phone is not the case,
then the global address can be set to any unique string.
PK, FK NOT NULL
DBINT
Unique identifier for the target.
NetworkTargetID
Dialed_Number Table
This table is in the
Each row describes a dialed number serviced by the ICM software. Use ICM Configuration
Manager to add, update, and delete Dialed_Number records.
Manager to add, update, and delete Dialed_Number records.
Related tables
(via CustomerDefinitionID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
125
Chapter 2: All Tables
Dialed_Number Table