ATK_WATCHLIST_ITEMS
Watchlist User Items: stores the actual watchlist item counts against users or roles.
Details
-
Schema: FUSION
-
Object owner: ATK
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ATK_WATCHLIST_ITEMS_PK |
WATCHLIST_USER_ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WATCHLIST_USER_ITEM_ID | NUMBER | 18 | Yes | Watchlist User Item Identifier | |
| WATCHLIST_ITEM_CODE | VARCHAR2 | 100 | Yes | Watchlist Item Code: references the item code from the watchlist setup table (ATK_WATCHLIST_SETUP.WATCHLIST_ITEM_CODE). | |
| USER_ID | VARCHAR2 | 64 | Globally Unique User Identifier. | ||
| WATCHLIST_ITEM_NAME | VARCHAR2 | 400 | User-created saved search name. Required if WATCHLIST_ITEM_TYPE = USER_SAVED_SEARCH for this item in setup table. | ||
| SAVED_SEARCH_VIEW_CRITERIA_ID | VARCHAR2 | 400 | Internal identifier for user-created saved search. Required if WATCHLIST_ITEM_TYPE = USER_SAVED_SEARCH for this item in setup table. | ||
| REFRESH_STATUS | VARCHAR2 | 30 | Indicates the status of last refresh request for this item. Valid values are PENDING and COMPLETE. Required if WATCHLIST_ITEM_TYPE != TXN_FLOW_BASED. | ||
| LAST_REFRESH_REQUEST_TIME | TIMESTAMP | Date and time of the last refresh request for this item. Required if WATCHLIST_ITEM_TYPE != TXN_FLOW_BASED. | |||
| ITEM_COUNT | NUMBER | 9 | The actual count for this item shown to the user in Watchlist UI. Required if REFRESH_STATUS != PENDING (empty only during initial refresh request for user). | ||
| LAST_REFRESH_COMPLETION_DATE | TIMESTAMP | Watchlist item counts are calculated periodically by the product web services.This column represents the date when the item was last refreshed. | |||
| CATEGORY_ENABLED_FLAG | VARCHAR2 | 1 | This flag is used to determine if the category has been disabled by the user using the watchlist preferences UI. | ||
| ITEM_ENABLED_FLAG | VARCHAR2 | 1 | This flag is used to determine if the watchlist itesm has been disabled by the user using the watchlist preferences UI. | ||
| ENABLE_ZERO_ITEMS_FLAG | VARCHAR2 | 1 | This flag is used to identify whether the items with zero count are shown or hidden. | ||
| 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_ITEMS_N1 | Non Unique | Default | WATCHLIST_ITEM_CODE, USER_ID, WATCHLIST_ITEM_NAME, SAVED_SEARCH_VIEW_CRITERIA_ID, REFRESH_STATUS, LAST_REFRESH_REQUEST_TIME, ITEM_COUNT, LAST_REFRESH_COMPLETION_DATE, CATEGORY_ENABLED_FLAG, ITEM_ENABLED_FLAG, ENABLE_ZERO_ITEMS_FLAG |
| ATK_WATCHLIST_ITEMS_PK | Unique | Default | WATCHLIST_USER_ITEM_ID |
| ATK_WATCHLIST_ITEMS_U1 | Unique | Default | WATCHLIST_ITEM_CODE, USER_ID, SAVED_SEARCH_VIEW_CRITERIA_ID |