ATK_WATCHLIST_USER_PREF

This table stores user preferences for hiding categories or items in watchlist UI.

Details

• Schema: FUSION

• Object owner: ATK

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
ATK_WATCHLIST_USER_PREF_PK	WATCHLIST_USER_PREF_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
WATCHLIST_USER_PREF_ID	NUMBER		18	Yes	Watchlist User Preference Identifier.
USER_ID	VARCHAR2	64		Yes	User Identifier.
PREFERENCE_TYPE	VARCHAR2	30		Yes	Indicates the preference type. Valid values are EXCLUDE_CATEGORY, EXCLUDE_ITEM and EXCLUDE_USER_ITEM.
WATCHLIST_ITEM_CODE	VARCHAR2	100			Specifies the watchlist item that needs to be excluded from watchlist UI for this user. Required if PREFERENCE_TYPE = EXCLUDE_ITEM (null otherwise).
WATCHLIST_CATEGORY_CODE	VARCHAR2	100			Specifies the watchlist category that needs to be excluded from watchlist UI for this user. Required if PREFERENCE_TYPE = EXCLUDE_CATEGORY (null otherwise).
WATCHLIST_USER_ITEM_ID	NUMBER		18		Specifies the watchlist user-created item that needs to be excluded from watchlist UI for this user. Required if PREFERENCE_TYPE = EXCLUDE_USER_ITEM (null otherwise).
ENABLED	VARCHAR2	1			Enabled Flag - indicates if this watchlist category/item is enabled/active.
REFRESH_AGE	NUMBER		9		Defines the age for watchlist item count in seconds. After this many seconds have passed since the last refresh time, the watchlist UI would issue count recalculation request.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index	Uniqueness	Tablespace	Columns
ATK_WATCHLIST_USER_PREF_N1	Non Unique	Default	PREFERENCE_TYPE, WATCHLIST_CATEGORY_CODE, WATCHLIST_ITEM_CODE, ENABLED
ATK_WATCHLIST_USER_PREF_PK	Unique	Default	WATCHLIST_USER_PREF_ID
ATK_WATCHLIST_USER_PREF_U1	Unique	Default	USER_ID, PREFERENCE_TYPE, WATCHLIST_ITEM_CODE, WATCHLIST_CATEGORY_CODE, WATCHLIST_USER_ITEM_ID