Lawson Insight Technical Documentation

                            PR1099RSLH FILE

UPDATED BY

PR195     PR197     PR560     PR82.1    PR85.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PSL-COMPANY          Numeric 4                                   PR195   PR197
Company              The company number represents an            PR560   PR82.1
                     established company and is entered on       PR85.1
                     all function codes.

PSL-EMPLOYEE         Numeric 9                                   PR195   PR197
Employee             Contains the employee number. Each          PR560   PR82.1
                     person employed by the company is           PR85.1
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.

PSL-PAYROLL-YEAR     Numeric 4                                   PR195   PR197
Current Payroll Year Contains the payroll year in which the      PR560   PR82.1
                     allocation was taken.                       PR85.1

PSL-QUARTER          Numeric 1                                   PR195   PR197
Quarter              Contains the fiscal quarter for the         PR560   PR82.1
                     data stored in this record.                 PR85.1

PSL-REPORT-ENTITY    Alpha 5                                     PR195   PR197
Report Entity                                                    PR560   PR82.1
                                                                 PR85.1

PSL-PROCESS-LEVEL    Alpha 5                                     PR195   PR197
Process Level        This field contains the process level,      PR560   PR82.1
                     which is the reporting hierarchy below      PR85.1
                     company.

PSL-CHECK-ID         Numeric 12                                  PR195   PR197
Internal Check ID    Contains the payment identification         PR560   PR82.1
Number               number (unique payment identifier used      PR85.1
                     in tracking payment information).

PSL-PENS-DIST-CODE   Alpha 1                                     PR195   PR197
Pens Dist Code                                                   PR560   PR82.1
                                                                 PR85.1

PSL-PENS-DST-CODE2   Alpha 1                                     PR195   PR197
Pens Dst Code2                                                   PR560   PR82.1
                                                                 PR85.1

PSL-PENS-SEQ-NBR     Numeric 4                                   PR195   PR197
Pens Seq Nbr                                                     PR560   PR82.1
                                                                 PR85.1

PSL-DED-CODE         Alpha 4                                     PR195   PR197
Deduction Code                                                   PR560   PR82.1
                                                                 PR85.1

PSL-TAX-AMT          Signed 15.2                                 PR195   PR197
Tax Amt                                                          PR560   PR82.1
                                                                 PR85.1

PSL-TAX-WAGE-AMT     Signed 15.2                                 PR195   PR197
Tax Wage Amt                                                     PR560   PR82.1
                                                                 PR85.1

                         PR1099RSLH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PSLSET1   COMPANY                                                PR195   PR197
          EMPLOYEE                                               PR560   PR82.1
          PAYROLL-YEAR                                           PR85.1
          QUARTER
          REPORT-ENTITY
          PROCESS-LEVEL
          PENS-DIST-CODE
          PENS-DST-CODE2
          CHECK-ID
          PENS-SEQ-NBR
          DED-CODE

                         PR1099RSLH FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PSL-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Ded Code       DEDCODE      Required

                            PSL-COMPANY          -> DDC-COMPANY
                            PSL-DED-CODE         -> DDC-DED-CODE

Employee       EMPLOYEE     Required

                            PSL-COMPANY          -> EMP-COMPANY
                            PSL-EMPLOYEE         -> EMP-EMPLOYEE

Paymastr       PAYMASTR     Not Required

                            PSL-COMPANY          -> PYM-COMPANY
                            PSL-EMPLOYEE         -> PYM-EMPLOYEE
                            PSL-CHECK-ID         -> PYM-CHECK-ID

Prcheck        PRCHECK      Not Required

                            PSL-COMPANY          -> PCH-COMPANY
                            PSL-EMPLOYEE         -> PCH-EMPLOYEE
                            PSL-PENS-SEQ-NBR     -> PCH-PENS-SEQ-NBR
                            PSL-CHECK-ID         -> PCH-CHECK-ID

Process Level  PRSYSTEM     Required

                            PSL-COMPANY          -> PRS-COMPANY
                            PSL-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Prpenhist      PRPENHIST    Not Required

                            PSL-COMPANY          -> PNH-COMPANY
                            PSL-EMPLOYEE         -> PNH-EMPLOYEE
                            PSL-CHECK-ID         -> PNH-CHECK-ID
                            PSL-PENS-SEQ-NBR     -> PNH-PENS-SEQ-NBR

                         PR1099RSLH FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Prpenfsrch     PRPENFSRCH

                            PSL-COMPANY          -> PFH-COMPANY
                            PSL-EMPLOYEE         -> PFH-EMPLOYEE
                            PSL-CHECK-ID         -> PFH-CHECK-ID
                            PSL-PENS-SEQ-NBR     -> PFH-PENS-SEQ-NBR
                                                    PFH-FUNDING-SOURCE