Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRTRDADJ


                             PRTRDADJ FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PTA-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.

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

PTA-ADJ-CHECK-ID       Numeric 12
Element: Adj Check Id

PTA-TIME-SEQ           Numeric 12
Element: Sequence Number

                         PRTRDADJ FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTASET1   COMPANY
          EMPLOYEE
          ORIG-CHECK-ID
          TIME-SEQ

PTASET2   COMPANY
          EMPLOYEE
          TIME-SEQ

                         PRTRDADJ FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Adjustment     PAYMASTR     Required

                            PTA-COMPANY          -> PYM-COMPANY  (PYMSET1)
                            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