Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-122
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Device_Target Table
Device_Target Table
Each row represents one or more enterprise agents. When an enterprise agents logs on, the ICM software
dynamically assigns him or her to a device target. To route calls to an enterprise agent, you must have
defined a label associated with the device target.
dynamically assigns him or her to a device target. To route calls to an enterprise agent, you must have
defined a label associated with the device target.
Use ICM Configuration Manager to create, delete, and modify device targets.
Table 2-107 Device_Target Table Constraints
Constraint
Field Name(s)
PK
NetworkTargetID)
AK-1
EnterpriseName
AK-2
DeviceAddressType
GlobalAddress
GlobalAddress
FK
NetworkTargetID
Table 2-108 Device_Target Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ChangeStamp
Incremented when the record is changed in the central
database.
database.
DCHANGESTA
MP
MP
NOT NULL
ConfigParam
An optional string to be sent to the device during
initialization.
initialization.
varchar(255)
NULL
Description
Additional information about the device target.
DESCRIPTION
NULL
DeviceAddressType
Type of address defined in the GlobalAddressfield:
1 = Internet Protocol (IP).
1 = Internet Protocol (IP).
DBINT
AK-2
NOT NULL
DeviceTargetType
The type of the target:
1 = Voice
2 = FAX
3 = E- mail
2 = FAX
3 = E- mail
Note
Currently only Voice is supported.
DBINT
NOT NULL
EnterpriseName
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.
VNAME32
AK-1
NOT NULL
GlobalAddress
A unique identifier. This field is used to enforce validation
that the agent desktop and the agent phone 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.
that the agent desktop and the agent phone 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.
varchar(64)
AK-2
NOT NULL
NetworkTargetID
Unique identifier for the target.
DBINT
PK, FK
NOT NULL