Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFTIMER


                              WFTIMER FILE

UPDATED BY

WF48.1    WF140     WF20.1    WF20.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WTM-WORKUNIT           Numeric 12                                WF48.1
Element: Workunit

WTM-PROCESS-ID         Numeric 12                                WF48.1
Element: Process Id

WTM-ACTIVITY-ID        Alpha 20  (Lower Case)                    WF48.1
Element: Activity Id

WTM-END-DATE           Numeric 8  (yyyymmdd)                     WF48.1
Element: Ending Date   The ending date in a range of dates.

WTM-END-TIME           Numeric 6  (hhmmss)                       WF48.1
Element: End Time

                         WFTIMER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WTMSET1   WORKUNIT                                               WF140   WF20.1
          PROCESS-ID                                             WF20.2  WF48.1
          ACTIVITY-ID

WTMSET2   END-DATE*
          END-TIME*
          WORKUNIT
          PROCESS-ID
          ACTIVITY-ID

                         WFTIMER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfworkunit     WFWORKUNIT   Required

                            WTM-WORKUNIT    -> WFW-WORKUNIT  (WFWSET1)