Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFHISTASK


                             WFHISTASK FILE

                         Workflow Task History

The Workflow Task History file contains task data for completed work units.
Records are added to this file by the work unit clean-up routine.

REFERENCED BY

WF30.1    WF35.1

UPDATED BY

WF100     WF140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WHT-WORKUNIT           Numeric 12                                WF140
Element: Workunit      This the work unit number assigned by
                       the Workflow Management system.

WHT-END-DATE           Numeric 8  (yyyymmdd)                     WF140
Element: Ending Date   The date when the task was completed.

WHT-END-TIME           Numeric 6  (hhmmss)                       WF140
Element: End Time      The time when the task was completed.

WHT-START-DATE         Numeric 8  (yyyymmdd)
Element: Start Date    The date when the task began.

WHT-START-TIME         Numeric 6  (hhmmss)
Element: Start Time    The time when the task began.

WHT-ID                 Alpha 20  (Lower Case)
Element: Id

WHT-USER-NAME          Alpha 10  (Lower Case)                    WF140
Element: User Name     The user ID of the user who completed
                       the task.

WHT-TASK               Alpha 20  (Lower Case)                    WF140
Element: Task          The name of the task recorded. The task
                       is taken from the procedure the work
                       unit is following.

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

WHT-OPERATION          Alpha 15  (Lower Case)                    WF140
Element: Operation     The function provided as part of the
                       task.

WHT-COMMENT            Alpha 40  (Lower Case)                    WF140
Element: Comment       A narrative comment field.

WHT-WORK-CAT-VALUE     Alpha 20  (Lower Case)                    WF140
Element: Work Cat Value

                         WFHISTASK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WHTSET1   WORKUNIT                                               WF100   WF30.1
          END-DATE                                               WF35.1
          END-TIME
          START-DATE
          START-TIME

                         WFHISTASK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfhiswkuni     WFHISWKUNI   Required

                            WHT-WORKUNIT    -> WFI-WORKUNIT