user_preferences

Preferences to be associated with a particular user.

For home page Project preferences, user is a USERID. For home page Enterprise package preferences, user is an ECCM USERID.

Product code is 0 (ECCM) for Enterprise package preferences, or product specific for project preferences.

Column Name Column Datatype Column Null Option Column Comment
preference_userid integer not null Either a USERID or an ECCM USERID.

For Enterprise package preferences, this is an ECCM Userid.

For Project preferences this is a USERID.

preference_type integer not null Values for this release: 1=Project, 2=Enterprise Package
product_code integer not null A numeric field to identify products. 0 for ECCM, 1 for Harvest and 2 for Endevor
preference_value char(60) not null Value of the preference.
datetime_updated date not null Datetime of the last update

Product Name: AllFusion Change Manager Enterprise Workbench

Table Type: Table


Copyright © 2006 CA. All rights reserved.