Cisco Cisco Administrative Workstation Technical References
2-185
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
ICR_Locks Table
ICR_Locks Table
Contains information about system locks currently held by users.
Table 2-181 ICR_Locks Table Constraints
Constraint
Field Name(s)
PK
LockID
LockType
LockType
Table 2-182 ICR_Locks Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
DataFld
Additional information the ICM software
maintains for the lock.
maintains for the lock.
varchar(255)
NULL
DateTime
The date and time at which the lock was obtained. DBDATETIME
NOT NULL
LockID
Identifies the object that is locked. For example,
for a Script lock, LockID holds the ScriptID value.
for a Script lock, LockID holds the ScriptID value.
DBINT
PK
NOT NULL
LockName
The name of the object that is locked. For
example, for a Script lock, LockName holds the
name of the script.
example, for a Script lock, LockName holds the
name of the script.
DESCRIPTION
NOT NULL
LockType
The type of the lock.
DBINT
PK
NOT NULL
ReleaseOnSend
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.
DBINT
NOT NULL
SystemName
The system from which the user obtained the lock. VNAME32
NOT NULL
UserName
The name of the user who holds the lock.
VNAME32
NOT NULL