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.

REFERENCED BY

WF30.1    WF31.1

UPDATED BY

WF100     WF140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

WHF-SEQ-NBR            Numeric 6                                 WF140
Element: Seq Nbr       An automatically assigned sequence
                       number.

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

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

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

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

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

WHF-DESCRIPTION        Alpha 50  (Lower Case)                    WF140
Element: Description   A description of the attached item.

WHF-FILE-NAME          Alpha 30                                  WF140
Element: File Name     A file specification for the attached
                       item.

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)                    WF140
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                                               WF100   WF30.1
          SEQ-NBR                                                WF31.1

                         WFHISFOLDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfhiswkuni     WFHISWKUNI   Required

                            WHF-WORKUNIT    -> WFI-WORKUNIT