Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Each row defines an ICM instance. For a Network Applications Manager (NAM), you should
con
figure an instance for each associated Customer ICM. Use ICM Configuration Manager to
create, update, or delete an ICM instance.
Related tables
 (via ICRInstanceID)
Table 105: Indexes for ICR_Instance Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1ICR_Instance
NetworkICRInstanceID
nonclustered located on PRIMARY
XIE1ICR_Instance
ICRInstanceID
clustered, unique,primary key located
on PRIMARY
XPKICR_Instance
Fields in ICR_Instance 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
DESCRIPTION
Any additional information about the instance.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for the instance. This name
must be unique for all ICM instances in the
enterprise.
EnterpriseName
PK NOT NULL
DBINT
A unique identifier for the instance.
ICRInstanceID
NULL
DBFLT8
Key value this instance received from the NAM
with the last con
figuration 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
Contains information about system locks currently held by users.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
174
Chapter 2: -  All Tables
ICR_Locks Table