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
  • 1 = Active (adds this activity to the filter list)
  • 0 = inactive (removes this activity from the filter list)

* System required field

** Combination of (user_ekey, activity_internal_name) must be unique