Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.1
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Download
Page of 404
 
2-113
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
ICR_Node Table
ICR_Node Table
Each row represents a real- time distributor associated with an ICM instance. On a Network ICM, you 
must configure the distributors associated with each Customer ICM. The Network ICM needs this 
information to forward certain configuration changes.
Use ICM Configuration Manager to create, modify, or delete an ICM node.
LockName
The name of the object that is locked. For example, 
for a Script lock, LockName holds the name of the 
script.
varchar(255)
NOT NULL
DateTime
The date and time at which the lock was obtained.
datetime
NOT NULL
UserName
The name of the user who holds the lock.
varchar(32)
NOT NULL
SystemName
The system from which the user obtained the lock.
varchar(32)
NOT NULL
DataFld
Additional information the ICM software maintains 
for the lock.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL
ReleaseOnSend
Indicates whether the ICM software should 
automatically release the lock when the associated 
data are saved to the ICM database.
int
NOT NULL
Table 2-90 ICR_Locks Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-91 ICR_Node Table
Field Name
Description
Data Type
Keys and Null 
Option
ICRNodeID
A unique identifier for the node.
int
PK, NOT NULL
ICRInstanceID
The ICM instance associated with the node.
int
IE1, FK, NOT 
NULL
EnterpriseName
An enterprise name for the node. This name must be 
unique for all nodes in the enterprise.
varchar(32)
AK1, NOT 
NULL
Type
The type of node: 
1 = Primary Distributor
2 = Backup Distributor
smallint
NOT NULL
DomainName
The name of the NT domain that contains the node.
varchar(32)
NOT NULL
SystemName
The host name of the machine on which the node runs. varchar(32)
NOT  NULL
ConfigParam
Parameters to be passed to the node at initialization.
varchar(255)
NULL
Description
Additional information about the node.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL