Technical References

Keys and Null Option:Data Type:Description:Field Name:
PK NOT NULLDBINT
A unique identifier for the instance.
ICRInstanceID
NULLDBFLT8
Key value this instance received from the NAM with the last
configuration update.
LastUpdateKey
FK, IE-1 NULLDBINT
The Network ICM instance, if any, associated with the instance.
NetworkICRInstanceID
NOT NULLDBINT
The number the identifies the instance in ICM Setup.
Number
NOT NULLDBSMALLINT
Indicates whether the instance is Network ICM or a Customer
ICM.
Type
ICR_Locks Table
This table is in the System category (page 460). To see database rules for these tables, click here
(page 511).
Contains information about system locks currently held by users.
Table 107: Indexes for ICR_Locks Table
index_keysindex_descriptionindex_name
LockType, LockIDclustered, unique, primary key
located on PRIMARY
XPKICR_Locks
Fields in ICR_Locks Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLvarchar(255)
Additional information the ICM software maintains for the lock.
DataFld
NOT NULLDBDATETIME
The date and time at which the lock was obtained.
DateTime
PK NOT NULLDBINT
Identifies the object that is locked. For example, for a Script lock,
LockID holds the ScriptID value.
LockID
NOT NULLDESCRIPTION
The name of the object that is locked. For example, for a Script lock,
LockName holds the name of the script.
LockName
PK NOT NULLDBINT
The type of the lock. To see values, click here (page 477).
LockType
NOT NULLDBINT
Indicates whether the ICM software should automatically release
the lock when the associated data are saved to the ICM database.
ReleaseOnSend
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
213
Chapter 2: All Tables
ICR_Locks Table