Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFHISFOLDR


                            WFHISFOLDR FILE

                        Workflow Folder History

The Workflow Folder History file contains folder 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

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

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

WHF-DOCUMENT-ID        Alpha 10  (Lower Case)
Element: Document Id   A user-supplied identifier for the
                       folder item.

WHF-FORM               Alpha 10
Element: Form          A form ID for Lawson application forms.

WHF-KEY-STRING         Alpha 70  (Lower Case)
Element: Key String    A comma separated string of key field
                       data.

WHF-START-DATE         Numeric 8  (yyyymmdd)
Element: Start Date    This is the date when the folder item
                       was attached to the work unit.

WHF-START-TIME         Numeric 6  (hhmmss)
Element: Start Time    This is the time when the folder item
                       was attached to the work unit.

WHF-WF-DESCRIPTION     Alpha 50  (Lower Case)
Element: Wf Description

WHF-WF-FILE-NAME       Alpha 30
Element: Wf File Name

WHF-DELETE-FL          Alpha 1
Element: Delete Fl     This is a Boolean flag indicating
                       whether or not a folder item is hidden
                       from Inbasket. If the file still exists,

                       it can be restored by resetting this
                       flag.
                       N = No
                       Y = Yes

WHF-ATTACH-BY          Alpha 30  (Lower Case)
Element: Attach By     The user ID of the user who attached
                       the folder item to the work unit.

                         WFHISFOLDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WHFSET1   WORKUNIT
          WF-SEQ-NBR

                         WFHISFOLDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfhiswkuni     WFHISWKUNI   Required

                            WHF-WORKUNIT    -> WFI-WORKUNIT  (WFISET1)