Cisco Cisco E-Mail Manager Unity Integration Option Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
A unique identifier for the instance.
ICRInstanceID
NULL
DBFLT8
Key value this instance received from the NAM with the last
configuration update.
LastUpdateKey
FK, IE-1 NULL
DBINT
The Network ICM instance, if any, associated with the instance.
NetworkICRInstanceID
NOT NULL
DBINT
The number the identifies the instance in ICM Setup.
Number
NOT NULL
DBSMALLINT
Indicates whether the instance is Network ICM or a Customer
ICM.
Type
ICR_Locks Table
This table is in the 
To see database rules for these tables, click 
Contains information about system locks currently held by users.
Table 107: Indexes for ICR_Locks Table
index_keys
index_description
index_name
LockType, LockID
clustered, unique, primary key
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.
ChangeStamp
NULL
varchar(255)
Additional information the ICM software maintains for 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.
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.
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.
ReleaseOnSend
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
213
Chapter 2:  All Tables
ICR_Locks Table