Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-69
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Default_Call_Type Table
Default_Call_Type Table
Each row specifies the default call type. You can associate a default call type with each routing client.
Note
You can also create a general default call type in the ICR_Globals table.
To add, update, and delete Default_Call_Type records, use ICM Configuration Manager to modify the
Routing Client configuration.
Routing Client configuration.
Related tables:
Call Type (via CallTypeID)
Routing Client (via RoutingClientID)
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-52 Default_Call_Type Table
Field Name
Description
Data Type
Keys and Null
Option
Option
RoutingClientID
The routing client.
smallint
PK, FK, NOT
NULL
NULL
CallTypeID
The call type.
int
FK, NOT NULL
Table 2-53 Device_Table Table
Field Name
Description
Data Type
Keys and Null
Option
Option
NetworkTargetID
Unique identifier for the target.
int
PK, FK, NOT
NULL
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.
varchar(32)
AK1, NOT
NULL
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.
int
NOT NULL
DeviceAddressType
Type of address defined in the GlobalAddressfield:
1 = Internet Protocol (IP).
1 = Internet Protocol (IP).
int
AK0, NOT
NULL
NULL