Lawson Insight Technical Documentation

                            TMLEAVEDTL FILE

REFERENCED BY

PR20.4    UK120     UK220     UK60.1    UK70.1

UPDATED BY

UK20.1    UK20.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TLD-COMPANY            Numeric 4                                 UK20.2
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

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

TLD-REM-UNITS          Numeric 5                                 UK20.2
Element: Rem Units

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

                         TMLEAVEDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TLDSET1   COMPANY                                                PR20.4  UK120
          PLAN-NAME                                              UK20.1  UK20.2
          REM-UNITS                                              UK220   UK60.1
                                                                 UK70.1

TLDSET2   COMPANY                                                UK120
          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
                            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