Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFHISWKUNI


                            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.

REFERENCED BY

WF30.1    WF31.1    WF32.1    WF33.1    WF35.1

UPDATED BY

WF100     WF140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

WFI-OBJECT-NAME        Alpha 15                                  WF140
Element: 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)                    WF140
Element: Key String    A comma-separated string of key field
                       data.

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

WFI-EVENT-TYPE         Alpha 15  (Lower Case)                    WF140
Element: Event Type

WFI-PROCESS-NAME       Alpha 20  (Lower Case)                    WF140
Element: Process Name

WFI-WORK-USER-ID       Alpha 10  (Lower Case)                    WF140
Element: 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)
Element: Work Return IdThis field is reserved for future
                       development.

WFI-WORK-TITLE         Alpha 50  (Lower Case)                    WF140
Element: 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)                    WF140
Element: 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)                    WF140
Element: Work Cat ValueThe 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                                 WF140
Element: 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)                    WF140
Element: Work Comment  A narrative comment field.

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

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

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

WFI-CLOSE-TIME         Numeric 6  (hhmmss)                       WF140
Element: Close Time    The time when the work unit was created.

WFI-WF-STATUS          Numeric 2
Element: 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
Element: Elapsed Time  The total life of a work unit from
                       start to finish.

WFI-CRITERION-1        Alpha 30  (Lower Case)
Element: Criterion 1

WFI-CRITERION-2        Alpha 30  (Lower Case)
Element: Criterion 2

WFI-CRITERION-3        Alpha 30  (Lower Case)
Element: Criterion 3

                         WFHISWKUNI FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WFISET1   WORKUNIT                                               WF100   WF30.1
                                                                 WF31.1  WF32.1
                                                                 WF33.1  WF35.1

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-END-DATE
                                               WHT-END-TIME
                                               WHT-START-DATE
                                               WHT-START-TIME

Wfhisvar       WFHISVAR     Delete Cascades

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