Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Table 106: Indexes for ICR_Locks Table
index_keys
index_description
index_name
LockType, LockID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKICR_Locks
Fields in ICR_Locks Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central
database.
database.
ChangeStamp
NULL
varchar(255)
Additional information the ICM software maintains for
the lock.
the lock.
DataFld
NOT NULL
DBDATETIME
The date and time at which the lock was obtained.
DateTime
PK NOT NULL
DBINT
Identifies the object that is locked. For example, for a
Script lock, LockID holds the ScriptID value.
Script lock, LockID holds the ScriptID value.
LockID
NOT NULL
DESCRIPTION
The name of the object that is locked. For example, for
a Script lock, LockName holds the name of the script.
a Script lock, LockName holds the name of the script.
LockName
PK NOT NULL
DBINT
The type of the lock. To see values, click
LockType
NOT NULL
DBINT
Indicates whether the ICM software should
automatically release the lock when the associated data
are saved to the ICM database.
automatically release the lock when the associated data
are saved to the ICM database.
ReleaseOnSend
NOT NULL
VNAME32
The system from which the user obtained the lock.
SystemName
NOT NULL
varchar(64)
The name of the user who holds the lock.
UserName
ICR_Node Table
This table is part of the
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.
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.
Related table
(via ICRInstanceID)
Table 107: Indexes for ICR_Node Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1ICR_Node
ICRInstanceID
nonclustered located on PRIMARY
XIE1ICR_Node
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
175
Chapter 2: All Tables
ICR_Node Table