Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 404
 
2-62
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Cfg_Mngr_Globals Table
Related tables:
Cfg Mngr User Desktop Snap (via DesktopSnapShotID)
Cfg_Mngr_Globals Table  
This table contains a single record that stores version information about the menu system that ICM 
Configuration Manager is currently using.
Cfg_Mngr_User_Desktop_Snap Table 
This table retains information on current Configuration Manager state for a particular user. 
POSY
The application’s Y position on the desktop.
smallint
NULL
ApplicationOpen
Valid options include:
Y = Indicates that the application was open when 
Configuration Manager was closed. 
N = The application was not open when Configuration 
Manager was closed.
char(1)
NOT NULL
Table 2-38 Cfg_Mngr_App_Snapshot_State Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-39 Cfg_Mngr_Globals Table
Field Name
Description
Data Type
Keys and Null 
Option
VersionID
A unique identifier for the version.
int
PK, NOT NULL
Version
Stores version information about the menu system the 
ICM Configuration Manager is currenlty using.
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL
Table 2-40 Cfg_Mngr_User_Desktop_Snap Table
Field Name
Description
Data Type
Keys and Null 
Option
DesktopSnapShotID
A unique identifier for the desktop snapshot. 
int
PK, NOT NULL
UserSettingsID
A foreign key to the Cfg_Mngr_User_Settings table.
int
FK, NOT NULL
MenuID
A unique identifier for the menu.
int
FK, NULL
DesktopSnapShotName
A name for the desktop snapshot.
varchar(32)
NOT NULL