Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             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.

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

WHT-TASK             Alpha 20
Task                 The name of the task recorded. The task
                     is taken from the procedure the work
                     unit is following.

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

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

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

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

WHT-ROLE             Alpha 15  (Lower Case)
Role                 The role responsible for completing the
                     task. Roles are defined on WF08.1 (Role
                     Definition).

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

WHT-COMMENT          Alpha 40  (Lower Case)
Comment Line         A narrative comment field.

                         WFHISTASK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WHTSET1   WORKUNIT
          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  (WFISET1)