Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFHISVAR


                             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
Element: Workunit      The work unit number assigned by the
                       Workflow Management system.

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

WHV-WF-SEQ-NBR         Numeric 6
Element: Wf Seq Nbr

WHV-VARIABLE-VALUE     Alpha 250  (Lower Case)
Element: Variable ValueThe value of the variable when the work
                       unit was completed.

WHV-VARIABLE-TYPE      Alpha 1
Element: 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
          WF-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)