Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            WFHISWKUNI FILE

                       Workflow Work Unit History

The Workflow Work Unit History file contains work unit header 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

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

WFI-OBJECT-NAME      Alpha 15
Object Name          The object used to process this work
                     unit. Objects are defined on WF04.1
                     (Object Definition).

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

WFI-SERVICE          Alpha 15  (Lower Case)
Service              The service used to process this work
                     unit. Services are defined on WF05.1
                     (Service Definition).

WFI-AGENT            Alpha 15
Agent                The agent called by the service to
                     process this work unit. Agents are
                     defined on WF06.1 (Agent
                     Definition).

WFI-PROCEDURE        Alpha 20  (Lower Case)
Procedure            The procedure followed in processing
                     this work unit. Procedures are defined
                     on WF07.1 (Procedure
                     Definition).

WFI-WORK-USER-ID     Alpha 10  (Lower Case)
Work User Id         The user ID of the user associated with
                     this work unit. Users are defined on
                     WF12.1 (User Profile
                     Definition).

WFI-WORK-RETURN-ID   Alpha 60  (Lower Case)
Work Return Id       This field is reserved for future
                     development.

WFI-WORK-TITLE       Alpha 50  (Lower Case)
Work Title           The unique title assigned to the work
                     unit by the procedure that uses the
                     Start API.

WFI-WORK-CATEGORY    Alpha 15  (Lower Case)
Work Category        The category assigned to this work
                     unit. Categories refine the work
                     delivery process and can reduce the
                     amount of work seen by the user in
                     their work queue. Categories are
                     assigned by the Create Work Unit API
                     call that created the work unit.

WFI-WORK-CAT-VALUE   Alpha 20  (Lower Case)
Work Cat Value       The value assigned to a category for
                     this work unit. A user's category value
                     must match this value for the
                     work unit to be delivered to their
                     Inbasket. Category values are assigned
                     by the Create Work Unit API call
                     that created the work unit.

WFI-WORK-PRIORITY    Numeric 3
Work Priority        The relative importance of the work.
                     Work priority is assigned by the Create
                     Work Unit API call that
                     created the work unit.

WFI-WORK-COMMENT     Alpha 60  (Lower Case)
Work Comment         A narrative comment field.

WFI-START-DATE       Numeric 8  (yyyymmdd)
Start Date           The date when the work unit was created.

WFI-START-TIME       Numeric 6  (hhmmss)
Start Time           The time when the work unit was created.

WFI-CLOSE-DATE       Numeric 8  (yyyymmdd)
Close Date           The date when the work unit was
                     completed.

WFI-CLOSE-TIME       Numeric 6  (hhmmss)
Closing Time         The time when the work unit was created.

WFI-WF-STATUS        Numeric 2
Wf Status            The status of the work unit. For a
                     record to be created, the work unit must
                     have a status that includes a
                     completion factor.

WFI-ELAPSED-TIME     Numeric 8
Elapsed Time         The total life of a work unit from
                     start to finish.

                         WFHISWKUNI FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WFISET1   WORKUNIT

WFISET2   OBJECT-NAME   KeyChange
          KEY-STRING
          WORKUNIT

                         WFHISWKUNI FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfhisfoldr     WFHISFOLDR   Delete Cascades

                            WFI-WORKUNIT    -> WHF-WORKUNIT  (WHFSET1)
                                               WHF-SEQ-NBR

Wfhismsghd     WFHISMSGHD   Delete Cascades

                            WFI-WORKUNIT    -> WFM-WORKUNIT
                                               WFM-MESSAGE-ID

Wfhistask      WFHISTASK    Delete Cascades

                            WFI-WORKUNIT    -> WHT-WORKUNIT
                                               WHT-START-DATE
                                               WHT-START-TIME

Wfhisvar       WFHISVAR     Delete Cascades

                            WFI-WORKUNIT    -> WHV-WORKUNIT
                                               WHV-VARIABLE-NAME
                                               WHV-SEQ-NBR