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

ET530     PR195     PR197     PR300     PR560     PR82.1
PR85.1    UK560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PSL-COMPANY            Numeric 4                                 ET530   PR195
Element: Company Hr                                              PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

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

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

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

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

PSL-PROCESS-LEVEL      Alpha 5                                   ET530   PR195
Element: Process Lev Hr                                          PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

PSL-CHECK-ID           Numeric 12                                ET530   PR195
Element: Check Id      Contains the payment identification       PR197   PR560
                       number (unique payment identifier used    PR82.1  PR85.1
                       in tracking payment information).         UK560

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

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

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

PSL-DED-CODE           Alpha 4                                   ET530   PR195
Element: Ded Code                                                PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

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

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

                         PR1099RSLH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PSLSET1   COMPANY                                                ET530   PR195
          EMPLOYEE                                               PR197   PR250
          PAYROLL-YEAR                                           PR251   PR253
          QUARTER                                                PR300   PR560
          REPORT-ENTITY                                          PR82.1  PR85.1
          PROCESS-LEVEL                                          UK560
          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