ALEX_WI_FILTER_ACTIVITY (Staging table)
Column name | Data type | Required | Default updateable | Data target | Comments |
---|---|---|---|---|---|
USER_EKEY** | VARCHAR (255) | Yes* | No | alco_wi_filter_activity.user_work_item_filter_id | User external key. |
ACTIVITY_INTERNAL_NAME** | VARCHAR (255) | Yes* | No | alco_wi_filter_activity.activity_id | Work item filter activity internal name. |
ACTIVE_STATUS | SMALLINT | Yes* | Yes | N/A |
|
* System required field
** Combination of (user_ekey, activity_internal_name) must be unique