Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
index_keys
index_description
index_name
UserSettingsID
clustered, unique, primary key
located on PRIMARY
XPKCfg_Mngr_User_Settings
Fields in Cfg_Mngr_User_Settings 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
DBINT
Identifier for the last desktop snapshot that the user had opened
before closing the Configuration Manager.
LastDesktopSnapShotID
AK-1 NOT NULL
varchar(128)
The unique login name of the user who owns these settings.
LoginName
NOT NULL
DBCHAR
Indicates whether or not to save the current desktop snapshot
settings when the ICM Configuration Manager is closed:
SaveSnapShotOnExit
• Y = Yes, save settings on exit (the default).
• N = No, do not save settings on exit.
PK NOT NULL
DBINT
A unique identifier for the user settings.
UserSettingsID
Cfg_Mngr_View Table
This table is part of the 
To see database rules for this table,
click 
This table holds the information necessary to produce the tree view structure for multiple default
and custom menus within the ICM Configuration Manager. The Primary Key (PK) is
nonclustered.
Related table
 (via MenuID)
Table 62: Indexes for Cfg_Mngr_View Table
index_keys
index_description
index_name
PeerNodeID
nonclustered located on PRIMARY
XIE1Cfg_Mngr_View
ChildNodeID
clustered located on PRIMARY
XIE2Cfg_Mngr_View
NodeID, MenuID
nonclustered, unique, primary key
located on PRIMARY
XPKCfg_Mngr_View
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
147
Chapter 2:  All Tables
Cfg_Mngr_View Table