Technical References
Keys and Null
Option:
Data Type:Description:Field Name:
• Y = (Default) Yes, allow multiple instances to run at once.
• N = No, do not allow multiple instances.
NOT NULLDBCHAR
Indicates whether or not the tools should automatically retrieve
data when they start:
AutoRetrieve
• Y = Yes, automatically retrieve data at startup.
• N = (Default) No, do not automatically retrieve data.
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
PK NOT NULLDBINT
A unique identifier for the desktop snapshot.
DesktopSnapShotID
NOT NULLvarchar(128)
A name for the desktop snapshot.
DesktopSnapShotName
FK NULLDBINT
A unique identifier for the menu.
MenuID
NOT NULLDBCHAR
Determines whether tools should be reopened when a snapshot
is loaded:
OpenAppsOnLoad
• Y = Yes, reopen tool when snapshot is loaded.
• N = (Default) No, do not reopen tool.
NOT NULLDBCHAR
Indicates whether or not the application should start in the screen
position it was in when it was last run by the user:
SaveApplicationPositions
• Y = Yes, start application is same position.
• N = (Default) No, start it in application’s default position.
NOT NULLDBCHAR
Deternimes whether or not filter settings should be saved for all
tools:
SaveFilterData
• Y = (Default) Yes, save filter settings.
• N = No, do not save filter settings.
FK NOT NULLDBINT
A foreign key to the Cfg_Mngr_User_Settings table.
UserSettingsID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
145
Chapter 2: All Tables
Cfg_Mngr_User_Desktop_Snap Table