Cisco Cisco IP Contact Center Release 4.6.1 Technical References
index_keys
index_description
index_name
ICRNodeID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKICR_Node
Fields in ICR_Node Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NULL
varchar(255)
Parameters to be passed to the node at initialization.
ConfigParam
NULL
DESCRIPTION
Additional information about the node.
Description
NOT NULL
varchar(64)
The name of the NT domain that contains the node.
DomainName
AK-1 NOT NULL
VNAME32
An enterprise name for the node. This name must be
unique for all nodes in the enterprise.
unique for all nodes in the enterprise.
EnterpriseName
FK, IE-1 NOT NULL
DBINT
The ICM instance associated with the node.
ICRInstanceID
PK NOT NULL
DBINT
A unique identifier for the node.
ICRNodeID
NOT NULL
VNAME32
The host name of the machine on which the node
runs.
runs.
SystemName
NOT NULL
DBSMALLINT
The type of node:
Type
• 1 = Primary Distributor
• 2 = Backup Distributor
ICR_View Table
Each ICR_View describes how the ICM software interprets the data imported for a schedule.
The individual columns within the view are described in associated View_Column rows.
The individual columns within the view are described in associated View_Column rows.
Related table
(via ICRViewID)
(via ICRViewID)
Table 108: Indexes for ICR_View Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1ICR_View
ICRViewID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKICR_View
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
176
Chapter 2: - All Tables
ICR_View Table