Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-184
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
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:
(via ICRInstanceID)
(via ICRInstanceID)
(via ICRInstanceID)
Table 2-179 ICR_Instance Table Constraints
Constraint
Field Name(s)
PK
ICRInstanceID
AK-1
EnterpriseName
FK
NetworkICRInstanceID
IE-1
NetworkICRInstanceID
Table 2-180 ICR_Instance 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
Description
Any additional information about the instance.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for the instance. This name
must be unique for all ICM instances in the
enterprise.
must be unique for all ICM instances in the
enterprise.
VNAME32
AK-1
NOT NULL
ICRInstanceID
A unique identifier for the instance.
DBINT
PK
NOT NULL
LastUpdateKey
Key value this instance received from the NAM
with the last configuration update.
with the last configuration update.
DBFLT8
NULL
NetworkICRInstanceID
The Network ICM instance, if any, associated with
the instance.
the instance.
DBINT
FK, IE-1
NULL
Number
The number the identifies the instance in ICM
Setup.
Setup.
DBINT
NOT NULL
Type
Indicates whether the instance is Network ICM or
a Customer ICM.
a Customer ICM.
DBSMALLINT
NOT NULL