Lawson Insight Technical Documentation

                             PRTRDADJ FILE

UPDATED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PTA-COMPANY          Numeric 4                                   AC542
Company              The company number represents an
                     established company and is entered on
                     all function codes.


PTA-EMPLOYEE         Numeric 9                                   AC542
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                                  AC542
Orig Check Id

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

PTA-TIME-SEQ         Numeric 12                                  AC542
Sequence Number

                         PRTRDADJ FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTASET1   COMPANY
          EMPLOYEE
          ORIG-CHECK-ID
          TIME-SEQ

PTASET2   COMPANY                                                AC542   BN66.1
          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

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