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.

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

WHT-END-TIME           Numeric 6  (hhmmss)
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-WF-RM-ID           Alpha 80  (Lower Case)
Element: Wf Rm Id

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

WHT-TASK               Alpha 20  (Lower Case)
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)
Element: Operation     The function provided as part of the
                       task.

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

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

                         WFHISTASK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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