ALEX_USER_WORK_ITEM_FILTER (Staging table)

Column name Data type Required Default update able Data target Comments
USER_EKEY VARCHAR (255) Yes* No alco_user_work_item_filter.user_id User external key --Primary Key
DATE_CREATED_AFTER DATETIME No No alco_user_work_item_filter. date_created_after Work item filter date created after.
DATE_CREATED_BEFORE DATETIME No No alco_user_work_item_filter. date_created_before Work item filter date created before.
DATE_MODIFIED_AFTER DATETIME No No alco_user_work_item_filter. date_modified_after Work item filter date modified after.
DATE_MODIFIED_BEFORE DATETIME No No alco_user_work_item_filter. date_modified_before Work item filter date modified before.
DATE_ENTERED_QUEUE_AFTER DATETIME No No alco_user_work_item_filter. date_entered_queue_after Work item filter date entered queue after.
DATE_ENTERED_QUEUE_BEFORE DATETIME No No alco_user_work_item_filter. date_entered_queue_before Work item filter date entered queue before.
DOCUMENT_TITLE VARCHAR (255) No No alco_user_work_item_filter. document_title Work item filter document title.
DOCUMENT_TITLE_OPERATOR INTEGER No No alco_user_work_item_filter. document_title_operator Work item filter document title operator. Set to 6, the only value supported by the user’s GUI, to perform a “like” query.
OWNER_EKEY VARCHAR (255) No No alco_user_work_item_filter. owner_id Work item filter document owner external key.
OWNER_OPERATOR INTEGER No No alco_user_work_item_filter. owner_id_operator Work item filter document owner operator. Set to 0, the only value supported by the user’s GUI, to perform an “equal to” query.
DOCUMENT_TYPE INTEGER No No alco_user_work_item_filter.document_type Work item filter document type.
  • 100 = Expense Management
  • 57000 = Timesheet
  • 76000 = Travel Plan
  • 135000 = Purchase Requisition
  • 99910220 = Check Request
DOCUMENT_TYPE_OPERATOR INTEGER No No alco_user_work_item_filter.document_type_operator Work item filter document type operator. Set to 0, the only value supported by the user’s GUI, to perform an “equal to” query.
DOCUMENT_ID VARCHAR (255) No No alco_user_work_item_filter.document_id Work item filter document ID.
DOCUMENT_ID_OPERATOR INTEGER No No alco_user_work_item_filter.document_id_operator Work item filter document id operator. Set to 6, the only value supported by the user’s GUI, to perform a “like” query.
AUDIT_INDICATOR VARCHAR (255) No No alco_user_work_item_filter. audit_indicator Work item filter audit indicator.
AUDIT_INDICATOR_OPERATOR INTEGER No No alco_user_work_item_filter. audit_indicator_operator Work item filter audit indicator operator. Set to 6, the only value supported by the user’s GUI, to perform a “like” query.
ACTIVITY_OPERATOR INTEGER No No alco_user_work_item_filter.activity_number_operator Work item filter activity operator.
  • 10 = Include work items in the list of activities specified in alex_wi_filter_activity
  • 14 = Exclude work items in the list of activities specified in alex_wi_filter_activity

* System required field

** Value must be unique