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

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

PSL-EMPLOYEE           Numeric 9                                 AC542   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                                 AC542   PR195
Element: Current PayrolContains the payroll year in which the    PR197   PR560
                       allocation was taken.                     PR82.1  PR85.1
                                                                 UK560

PSL-QUARTER            Numeric 1                                 AC542   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                                   AC542   PR195
Element: Process Level                                           PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

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

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

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

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

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

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

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

PSL-TAX-WAGE-AMT       Signed 15.2                               AC542   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                                                AC542   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