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
Company              The company number represents an
                     established company and is entered on
                     all function codes.

TLD-PLAN-NAME        Alpha 10                                    UK20.2
From Plan Name       This field contains the plan name.

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

TLD-REM-PAY-CODE     Alpha 4                                     UK20.2
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

Tmleave        TMLEAVE      Required

                            TLD-COMPANY         -> TLV-COMPANY
                            TLD-PLAN-NAME       -> TLV-PLAN-NAME