Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            WFWORKUNIT FILE

                           Workflow Work Unit

The Workflow Work Unit file describes work units. This is the main file in
the Workflow Management system. A work unit is a request for work to be done;
for example, to approve an invoice. The agent that performs the service for
the requested work creates a case for each work unit record in the Workflow
Management system.

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

WFW-OBJECT-NAME      Alpha 15
Object               The object associated with the selected
                     service. Objects are defined on WF04.1
                     (Object Definition).

WFW-KEY-STRING       Alpha 70  (Lower Case)
Key String           A string of key values in the primary
                     file record associated with the object.
                     For example, the company
                     number, vendor, invoice number, invoice
                     suffix, and cancel sequence associated
                     with a specific invoice.

WFW-SERVICE          Alpha 15  (Lower Case)
Service              The service that associates an object
                     with a procedure. Services are defined
                     on WF05.1 (Service
                     Definition).

WFW-AGENT            Alpha 15
Agent                The agent that provides a procedure.
                     For example, the VW Agent. Agents are
                     defined on WF06.1 (Agent
                     Definition).

WFW-PROCEDURE        Alpha 20  (Lower Case)
Procedure            The procedure that performs the
                     required activity.

WFW-WORK-USER-ID     Alpha 10  (Lower Case)
Work User Id         A unique identifier for the work unit
                     in the workflow engine (FileNET PANAGON
                     Visual WorkFlo 3.0).

WFW-WORK-RETURN-ID   Alpha 60  (Lower Case)
Work Return Id       This field is required to track the
                     work unit as a Work Object in the
                     FileNET PANAGON Visual WorkFlo
                     3.0 engine.

WFW-WORK-TITLE       Alpha 50  (Lower Case)
Work Title           The unique title assigned to the work
                     unit by the procedure that creates the
                     work unit.

WFW-WORK-CATEGORY    Alpha 15  (Lower Case)
Work Category        The category assigned to the work unit.
                     This category and its associated value
                     must match the user's
                     category and value before the user will
                     see the work unit in their Inbasket
                     queue.

WFW-WORK-CAT-VALUE   Alpha 20  (Lower Case)
Work Cat Value       The value assigned to the category.

WFW-WORK-PRIORITY    Numeric 3
Work Priority        The priority assigned to this work
                     unit. The lower the value, the lower the
                     priority.

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

WFW-START-DATE       Numeric 8  (yyyymmdd)
Start Date           The system date the work unit was
                     created in the Workflow Management
                     system.

WFW-START-TIME       Numeric 6  (hhmmss)
Start Time           The system time the work unit was
                     created in the Workflow Management
                     system.

WFW-CLOSE-DATE       Numeric 8  (yyyymmdd)
Close Date           The system date the work unit was
                     closed in the Workflow Management
                     system.

WFW-CLOSE-TIME       Numeric 6  (hhmmss)
Close Time           The system time the work unit was
                     closed in the Workflow Management
                     system.

WFW-WF-STATUS        Numeric 2
Status               The status of the work unit in the
                     Workflow Management system.
                     01 = Ready for processing
                     02 = Processing in progress
                     03 = Processing failed
                     04 = Processing completed
                     05 = Cancellation requested
                     06 = Cancellation in progress
                     07 = Cancellation failed
                     08 = Cancellation completed

WFW-LST-MSG-NBR      Numeric 4
Last Message Number  The last message number associated with
                     the Workflow Work Unit record. This is a
                     message counter for
                     the Workflow Message file.

WFW-LST-FOLDER-NBR   Numeric 4
Lst Folder Nbr       The number of the last folder file
                     added to the work unit. This is a
                     counter of the items in the work unit
                     folder.

WFW-LST-ERROR-NBR    Numeric 4
Lst Error Nbr        The number of the last error added to
                     the work unit. This is a counter of the
                     errors generated by the work
                     unit.

WFW-LST-VAR-NBR      Numeric 4
Lst Var Nbr          The last number assigned to a variable
                     in this work unit. This is a counter of
                     the variables used by this
                     work unit.

WFW-METRICS-LOGING   Alpha 1
Metrics Loging       This field indicates whether or not
                     metrics are stored for this work unit.
                     Y = Yes
                     N = No

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

                         WFWORKUNIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WFWSET1   WORKUNIT

WFWSET10  AGENT         KeyChange
          WORKUNIT*

WFWSET2   OBJECT-NAME   KeyChange
          KEY-STRING
          WORKUNIT*

WFWSET3   AGENT         KeyChange, Subset
          WORKUNIT      Where WF-STATUS = 1
                        Or    WF-STATUS = 5

WFWSET4   WORKUNIT      Subset
                        Where WF-STATUS = 1
                        Or    WF-STATUS = 5

WFWSET5   WORKUNIT      Subset
                        Where WF-STATUS = 3
                        Or    WF-STATUS = 7

WFWSET6   WORKUNIT      Subset
                        Where WF-STATUS = 4
                        Or    WF-STATUS = 8

WFWSET7   WORKUNIT      Subset
                        Where WF-STATUS = 2

WFWSET8   SERVICE
          WORKUNIT      KeyChange

                         WFWORKUNIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfagent        WFAGENT      Required

                            WFW-AGENT          -> WFA-AGENT  (WFASET1)

Wfobject       WFOBJECT     Required

                            WFW-OBJECT-NAME    -> WFO-OBJECT-NAME

Wfservice      WFSERVICE    Required

                            WFW-AGENT          -> WFS-SERVICE

                         WFWORKUNIT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Messagedtl     WFMSGDTL     Delete Cascades

                            WFW-WORKUNIT       -> WDT-WORKUNIT
                                                  WDT-MESSAGE-ID
                                                  WDT-MESSAGE-SEQ

Messagehdr     WFMSGHDR     Delete Cascades

                            WFW-WORKUNIT       -> WFH-WORKUNIT
                                                  WFH-MESSAGE-ID

Wfagentproc    WFAGNTPROC   Required

                            WFW-AGENT          -> WFP-AGENT
                                                  WFP-PROCEDURE
                                                  WFP-SERVICE
                                                  WFP-CRITERION-1
                                                  WFP-CRITERION-2
                                                  WFP-CRITERION-3

Wferrormsg     WFERRORMSG

                            WFW-WORKUNIT       -> WFX-WORKUNIT
                                                  WFX-MESSAGE-NBR

Wffolder       WFFOLDER

                            WFW-WORKUNIT       -> WFF-WORKUNIT
                                                  WFF-SEQ-NBR

Wftask         WFTASK       Delete Cascades

                            WFW-WORKUNIT       -> WTA-WORKUNIT
                                                  WTA-START-DATE
                                                  WTA-START-TIME

Wfvariable     WFVARIABLE

                            WFW-WORKUNIT       -> WFV-WORKUNIT
                                                  WFV-VARIABLE-NAME
                                                  WFV-SEQ-NBR