Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             WFHISVAR FILE

                       Workflow Variable History

The Workflow Variable History file contains data about variables from
completed work units. Records are added to this file by the work unit clean-up
routine.

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WHV-WORKUNIT         Numeric 12
Workunit             The work unit number assigned by the
                     Workflow Management system.

WHV-VARIABLE-NAME    Alpha 20  (Lower Case)
Variable Name        The name of the variable.

WHV-SEQ-NBR          Numeric 4
Sequence Number      An automatically assigned sequence
                     number.

WHV-VARIABLE-VALUE   Alpha 60  (Lower Case)
Variable Value       The value of the variable when the work
                     unit was completed.

WHV-VARIABLE-TYPE    Alpha 1
Variable Type        The type of variable. Variables are
                     either system or user type.

                         WFHISVAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WHVSET1   WORKUNIT
          VARIABLE-NAME
          SEQ-NBR

                         WFHISVAR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfhiswkuni     WFHISWKUNI   Required

                            WHV-WORKUNIT    -> WFI-WORKUNIT  (WFISET1)