Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 404
 
2-64
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Cfg_Mngr_User_Settings Table
Related tables:
Cfg Mngr View (via MenuID)
Cfg_Mngr_User_Settings Table
This table holds specific ICM Configuration Manager settings for each user of the Configuration 
Manager tool.
Related tables:
Cfg Mngr User Desktop Snap (via UserSettingsID)
Cfg_Mngr_View Table
This table holds the information necessary to produce the tree view structure for multiple default and 
custom menus within the ICM Configuration Manager.
Table 2-42 Cfg_Mngr_User_Settings Table
Field Name
Description
Data Type
Keys and Null 
Option
UserSettingsID
A unique identifier for the user settings.
int
PK, NOT NULL
LoginName
The unique login name of the user who owns these 
settings.
varchar(100)
AK1, NOT 
NULL
SaveSnapShotOnExit
Indicates whether or not to save the current desktop 
snapshot settings when the ICM Configuration Manager is 
closed:
Y = Yes, save settings on exit (the default). 
N = No, do not save settings on exit. 
char(1)
FK, NOT NULL
LastDesktopSnapShotID
Identifier for the last desktop snapshot that the user had 
opened before closing the Configuration Manager.
int
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL
Table 2-43 Cfg_Mngr_View Table
Field Name
Description
Data Type
Keys and Null 
Option
NodeID
A unique identifier for the node in the tree view. 
int
PK1, NOT 
NULL
MenuID
A unique identifier for the menu.
int
PK1, FK, NOT 
NULL
ApplicationID
Identifies the application.
int
NULL
PeerNodeID
Identifies the peer node in the tree view.
int
NULL