Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-112
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
ICR_Instance Table
ICR_Instance Table
Each row defines an ICM instance. For a Network Applications Manager (NAM), you should configure
an instance for each associated Customer ICM.
an instance for each associated Customer ICM.
Use ICM Configuration Manager to create, update, or delete an ICM instance.
Related tables:
Application Gateway (via ICRInstanceID)
Customer Definition (via ICRInstanceID)
ICR Node (via ICRInstanceID)
ICR_Locks Table
Contains information about system locks currently held by users.
Field Name
Description
Data Type
Keys and Null
Option
Option
ICRInstanceID
A unique identifier for the instance.
int
PK, NOT
NULL
NULL
NetworkICRInstanceID
The Network ICM instance, if any, associated with
the instance.
the instance.
int
IE1, FK,
NULL
NULL
EnterpriseName
An enterprise name for the instance. This name must
be unique for all ICM instances in the enterprise.
be unique for all ICM instances in the enterprise.
varchar(32)
AK1, NOT
NULL
NULL
Number
The number the identifies the instance in ICM Setup.
int
NOT NULL
Type
Indicates whether the instance is Network ICM or a
Customer ICM.
Customer ICM.
smallint
NOT NULL
LastUpdateKey
Key value this instance received from the NAM with
the last configuration update.
the last configuration update.
float
NULL
Description
Any additional information about the instance.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
int
NOT NULL
Table 2-90 ICR_Locks Table
Field Name
Description
Data Type
Keys and Null
Option
Option
LockType
The type of the lock.
int
PK, NOT NULL
LockID
Identifies the object that is locked. For example, for a
Script lock, LockID holds the ScriptID value.
Script lock, LockID holds the ScriptID value.
int
PK, NOT NULL