Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFWUQUEUE


                             WFWUQUEUE FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WWQ-WORKUNIT           Numeric 12
Element: Workunit

WWQ-PROCESS-ID         Numeric 12
Element: Process Id

WWQ-ACTIVITY-ID        Alpha 20  (Lower Case)
Element: Activity Id

WWQ-WORK-DESC          Alpha 99  (Lower Case)
Element: Work Desc

WWQ-LIST-MESSAGE       Alpha 80  (Lower Case)
Element: List Message

WWQ-TOTAL-USER         Numeric 12
Element: Total User

WWQ-TOTAL-USER-ACT     Numeric 12
Element: Total User Act

WWQ-ACTION-LIST        Alpha 99  (Lower Case)
Element: Action List

WWQ-ACTION-TAKEN       Alpha 30  (Lower Case)
Element: Action Taken

WWQ-EXEC-LIST          Alpha 99  (Lower Case)
Element: Exec List

WWQ-PRE-EXEC           Alpha 99  (Lower Case)
Element: Pre Exec

WWQ-DISPLAY-EXEC       Alpha 99  (Lower Case)
Element: Display Exec

WWQ-RETURN-CODE        Alpha 1
Element: Return Code

WWQ-RETRY              Numeric 4
Element: Retry

WWQ-DISP-STATUS        Numeric 1
Element: Disp Status

WWQ-WAIT-HOURS1        Numeric 4
Element: Wait Hours1

WWQ-REMINDED1          Alpha 1
Element: Reminded1     Y = Yes
                       N = No

WWQ-WAIT-HOURS2        Numeric 4
Element: Wait Hours2

WWQ-REMINDED2          Alpha 1
Element: Reminded2     Y = Yes
                       N = No

WWQ-REASSIGN           Alpha 1
Element: Reassign      Y = Yes
                       N = No

WWQ-REASSIGN-TASK      Alpha 20
Element: Reassign Task

WWQ-REASSIGN-HOURS     Numeric 4
Element: Reassign Hours

WWQ-CATEGORY-VALUE     Alpha 20  (Lower Case)
Element: Category Value

WWQ-ROUTING-RULE       Alpha 250  (Lower Case)
Element: Routing Rule

WWQ-NOTIFY-ALL-1       Alpha 1  (Lower Case)
Element: Notify All 1

WWQ-ADDNOTIFYTYPE1     Numeric 2
Element: Addnotifytype1

WWQ-ADDNOTIFY-1        Alpha 20  (Lower Case)
Element: Addnotify 1

WWQ-NOTIFY-ALL-2       Alpha 1  (Lower Case)
Element: Notify All 2

WWQ-ADDNOTIFYTYPE2     Numeric 2
Element: Addnotifytype2

WWQ-ADDNOTIFY-2        Alpha 20  (Lower Case)
Element: Addnotify 2

WWQ-PRO-LOGIC-TYPE     Numeric 2
Element: Pro Logic Type

WWQ-PRO-LOGIC-VAL1     Alpha 30  (Lower Case)
Element: Pro Logic Val1

WWQ-PRO-LOGIC-VAL2     Alpha 30  (Lower Case)
Element: Pro Logic Val2

WWQ-TIME-OUT           Alpha 1
Element: Time Out

WWQ-TIME-OUT-HOUR      Numeric 4
Element: Time Out Hour

WWQ-TIMEOUT-ACTION     Alpha 30  (Lower Case)
Element: Timeout Action

WWQ-FAIL-ACTION        Alpha 30  (Lower Case)
Element: Fail Action

                         WFWUQUEUE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WWQSET1   WORKUNIT
          PROCESS-ID
          ACTIVITY-ID

WWQSET2   CATEGORY-VALUEKeyChange
          WORKUNIT
          PROCESS-ID
          ACTIVITY-ID

WWQSET3   DISP-STATUS   KeyChange
          WORKUNIT
          PROCESS-ID
          ACTIVITY-ID

WWQSET4   CATEGORY-VALUEKeyChange
          DISP-STATUS
          WORKUNIT
          PROCESS-ID
          ACTIVITY-ID

                         WFWUQUEUE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfactivity     WFACTIVITY   Required

                            WWQ-WORKUNIT       -> WAC-WORKUNIT  (WACSET1)
                            WWQ-PROCESS-ID     -> WAC-PROCESS-ID
                            WWQ-ACTIVITY-ID    -> WAC-ACTIVITY-ID

Wfproctran     WFPROCTRAN   Required

                            WWQ-WORKUNIT       -> WPT-WORKUNIT
                            WWQ-PROCESS-ID     -> WPT-PROCESS-ID

Wfworkunit     WFWORKUNIT   Required

                            WWQ-WORKUNIT       -> WFW-WORKUNIT

                         WFWUQUEUE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfmetrics      WFMETRICS

                            WWQ-WORKUNIT       -> WME-WORKUNIT
                            WWQ-PROCESS-ID     -> WME-PROCESS-ID
                            WWQ-ACTIVITY-ID    -> WME-ACTIVITY-ID
                                                  WME-STATUS
                                                  WME-WF-RM-ID
                                                  WME-TASK

Wfquetask      WFQUETASK

                            WWQ-WORKUNIT       -> WQT-WORKUNIT
                            WWQ-PROCESS-ID     -> WQT-PROCESS-ID
                            WWQ-ACTIVITY-ID    -> WQT-ACTIVITY-ID
                                                  WQT-STATUS
                                                  WQT-TASK

Wfwuquedtl     WFWUQUEDTL   Delete Cascades

                            WWQ-WORKUNIT       -> WQD-WORKUNIT
                            WWQ-PROCESS-ID     -> WQD-PROCESS-ID
                            WWQ-ACTIVITY-ID    -> WQD-ACTIVITY-ID
                                                  WQD-VAR-TYPE
                                                  WQD-VARIABLE-NAME