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.

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

WFI-PRODUCT            Alpha 14
Element: Product

WFI-DATA-AREA          Alpha 14
Element: Data Area

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

WFI-SERVICE            Alpha 15  (Lower Case)
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)
Element: Event Type

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

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

WFI-WF-RM-ID           Alpha 80  (Lower Case)
Element: Wf Rm Id

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)
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)
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)
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
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)
Element: Work Comment  A narrative comment field.

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

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

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

WFI-CLOSE-TIME         Numeric 6  (hhmmss)
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-LST-MSG-NBR        Numeric 4
Element: Lst Msg Nbr

WFI-LST-FOLDER-NBR     Numeric 4
Element: Lst Folder Nbr

WFI-LST-ERROR-NBR      Numeric 4
Element: Lst Error Nbr

WFI-LST-VAR-NBR        Numeric 4
Element: Lst Var Nbr

WFI-METRICS-LOGING     Alpha 1
Element: Metrics Loging

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

WFI-TASK               Alpha 20  (Lower Case)
Element: Task

                         WFHISWKUNI FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WFISET1   WORKUNIT

WFISET2   OBJECT-NAME   KeyChange
          KEY-STRING
          WORKUNIT

WFISET3   SERVICE       KeyChange
          PROCESS-NAME
          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-WF-SEQ-NBR

Wfhismsghd     WFHISMSGHD   Delete Cascades

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

Wfhisvar       WFHISVAR     Delete Cascades

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