Lawson Insight Technical Documentation

                             PRTRDADJ FILE

UPDATED BY

BN66.1    ET530     PR140     PR189     PR195     PR80.1
PR89.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PTA-COMPANY            Numeric 4                                 ET530
Element: Company Hr

PTA-EMPLOYEE           Numeric 9                                 ET530
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PTA-ORIG-CHECK-ID      Numeric 12                                ET530
Element: Orig Check Id

PTA-ADJ-CHECK-ID       Numeric 12                                BN66.1  ET530
Element: Adj Check Id                                            PR140   PR189
                                                                 PR195   PR80.1
                                                                 PR89.1

PTA-TIME-SEQ           Numeric 12                                ET530
Element: Time Seq

                         PRTRDADJ FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTASET1   COMPANY
          EMPLOYEE
          ORIG-CHECK-ID
          TIME-SEQ

PTASET2   COMPANY                                                BN66.1  ET530
          EMPLOYEE                                               PR140   PR189
          TIME-SEQ                                               PR195   PR80.1
                                                                 PR89.1

                         PRTRDADJ FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Adjustment     PAYMASTR     Required

                            PTA-COMPANY          -> PYM-COMPANY
                            PTA-EMPLOYEE         -> PYM-EMPLOYEE
                            PTA-ADJ-CHECK-ID     -> PYM-CHECK-ID

Cur Timerecord TIMERECORD   Not Required

                            PTA-COMPANY          -> TRD-COMPANY
                            PTA-EMPLOYEE         -> TRD-EMPLOYEE
                            PTA-TIME-SEQ         -> TRD-TIME-SEQ

Employee       EMPLOYEE     Required

                            PTA-COMPANY          -> EMP-COMPANY
                            PTA-EMPLOYEE         -> EMP-EMPLOYEE

Original       PAYMASTR     Required

                            PTA-COMPANY          -> PYM-COMPANY
                            PTA-EMPLOYEE         -> PYM-EMPLOYEE
                            PTA-ORIG-CHECK-ID    -> PYM-CHECK-ID

Time Record    PRTIME       Not Required

                            PTA-COMPANY          -> PRT-COMPANY
                            PTA-EMPLOYEE         -> PRT-EMPLOYEE
                            PYM-PER-END-DATE     -> PRT-PER-END-DATE
                            PTA-ADJ-CHECK-ID     -> PRT-CHECK-ID
                            PTA-TIME-SEQ         -> PRT-TIME-SEQ

                         PRTRDADJ FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Adjustments    PRTRDADJ

                            PTA-COMPANY          -> PTA-COMPANY
                            PTA-EMPLOYEE         -> PTA-EMPLOYEE
                            PTA-ADJ-CHECK-ID     -> PTA-ORIG-CHECK-ID
                                                    PTA-TIME-SEQ