Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PR1099RSLH


                            PR1099RSLH FILE

REFERENCED BY

PR250     PR251     PR253

UPDATED BY

PR197     PR560     PR82.1    PR85.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PSL-COMPANY            Numeric 4                                 PR197   PR560
Element: Company Hr    Identifies the AP company if the          PR82.1  PR85.1
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PSL-EMPLOYEE           Numeric 9                                 PR197   PR560
Element: Employee      Contains the employee number. Each        PR82.1  PR85.1
                       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.

PSL-PAYROLL-YEAR       Numeric 4                                 PR197   PR560
Element: Current PayrolContains the payroll year in which the    PR82.1  PR85.1
                       allocation was taken.

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

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

PSL-PROCESS-LEVEL      Alpha 5                                   PR197   PR560
Element: Process Lev HrThis field contains the process level,    PR82.1  PR85.1
                       which is the reporting hierarchy below
                       company.

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

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

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

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

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

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

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

                         PR1099RSLH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PSLSET1   COMPANY                                                PR197   PR250
          EMPLOYEE                                               PR251   PR253
          PAYROLL-YEAR                                           PR560   PR82.1
          QUARTER                                                PR85.1
          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