Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFUSERCAT


                             WFUSERCAT FILE

                         Workflow User Category

The Workflow User Category file associates a category and category value with
a user. Categories are a filter for work presented in the Inbasket utility.
Categories and their values are assigned as part of the user profile
definition.

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WFT-WF-RM-ID           Alpha 80  (Lower Case)
Element: Wf Rm Id

WFT-TASK               Alpha 20  (Lower Case)
Element: Task

WFT-WORK-CATEGORY      Alpha 15  (Lower Case)
Element: Work Category The category assigned to the user. More
                       than one category can be assigned to the
                       user, if necessary.
                       Categories are defined on WF12.1 (User
                       Profile Definition).

WFT-WORK-CAT-VALUE     Alpha 20  (Lower Case)
Element: Work Cat ValueThe value of the assigned category.
                       Category values are assigned in WF12.1
                       (User Profile Definition).

                         WFUSERCAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WFTSET1   WF-RM-ID
          TASK
          WORK-CATEGORY
          WORK-CAT-VALUE

WFTSET2   WF-RM-ID
          TASK
          WORK-CAT-VALUE
          WORK-CATEGORY

WFTSET3   TASK
          WORK-CATEGORY
          WORK-CAT-VALUE
          WF-RM-ID

WFTSET4   TASK
          WORK-CAT-VALUE
          WORK-CATEGORY
          WF-RM-ID

WFTSET5   TASK
          WORK-CAT-VALUE
          WF-RM-ID
          WORK-CATEGORY

                         WFUSERCAT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfusertask     WFUSERTASK   Required

                            WFT-WF-RM-ID    -> WUT-WF-RM-ID  (WUTSET1)
                            WFT-TASK        -> WUT-TASK

Wfusrrpofl     WFUSRPROFL   Required

                            WFT-WF-RM-ID    -> WFU-WF-RM-ID