Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TMLEAVEDTL


                            TMLEAVEDTL FILE

REFERENCED BY

PR20.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TLD-COMPANY            Numeric 4
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

TLD-PLAN-NAME          Alpha 10
Element: From Plan NameThis field contains the plan name.

TLD-REM-UNITS          Numeric 5
Element: Rem Units

TLD-REM-PAY-CODE       Alpha 4
Element: Rem Pay Code

                         TMLEAVEDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TLDSET1   COMPANY                                                PR20.4
          PLAN-NAME
          REM-UNITS

TLDSET2   COMPANY
          PLAN-NAME
          REM-UNITS*

                         TMLEAVEDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TLD-COMPANY         -> PRS-COMPANY  (PRSSET1)
                            Spaces              -> PRS-PROCESS-LEVEL

Prpaycode      PRPAYCODE    Required

                            TLD-COMPANY         -> PCD-COMPANY
                            TLD-REM-PAY-CODE    -> PCD-PAY-CODE
                            Spaces              -> PCD-PROCESS-LEVEL
                            Spaces              -> PCD-JOB-CODE