Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRREGPARM


                             PRREGPARM FILE

REFERENCED BY

BN66.1    HR211     PR139     PR140     PR160     PR180
PR195     PR220     PR227     PR240     PR241     PR242
PR243     PR244     PR245     PR249     PR250     PR251
PR253     PR292     PR297     PR299     PR89.1    UK201


UPDATED BY

BN100     BN101     BN102     BN103     BN104     BN105
BN145     BN150     BN245     BN305     BN31.1    BN31.2
BN32.1    BN32.2    BN32.3    BN45.1    BN531     BN65.1
BN71.1    BN72.1    BS13.1    BS14.1    BS15.1    BS32.1
ET530     ETI1.1    ETI2.1    HR11.1    HR11.2    HR18.3
HR511     LP130     PA02.1    PA100     PA102     PA115
PA13.1    PA13.2    PA502     PA513     PA52.1    PA52.3
PA52.4    PA52.5    PR05.1    PR05.5    PR06.9    PR07.1
PR07.3    PR11.1    PR11.2    PR110     PR113     PR120
PR127     PR128     PR13.1    PR13.2    PR13.5    PR13.6
PR13.8    PR130     PR131     PR132     PR134     PR136
PR14.1    PR14.2    PR15.1    PR15.2    PR189     PR197
PR20.2    PR205     PR252     PR26.1    PR27.1    PR27.2
PR29.1    PR32.2    PR33.2    PR33.3    PR35.1    PR35.2
PR35.3    PR35.4    PR35.5    PR35.6    PR35.8    PR35.9
PR36.1    PR39.1    PR39.2    PR45.1    PR47.1    PR514
PR529     PR530     PR539     PR560     PR67.3    PR67.4
PR67.5    PR67.9    PR68.1    PR80.1    PR80.3    PR82.1
PR927     UK102     UK47.1    UK560     TA147

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RGP-COMPANY            Numeric 4                                 BN100   BN101
Element: Company Hr                                              BN102   BN103
                                                                 BN104   BN105
                                                                 BN145   BN150
                                                                 BN245   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR18.3
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR128
                                                                 PR13.1  PR13.2
                                                                 PR13.5  PR13.6
                                                                 ...

RGP-COUNTRY-CODE       Alpha 2                                   BN100   BN101
Element: Country Code  The country code.  Required for VAT and   BN102   BN103
                       intrastat reporting.  Must be defined in  BN104   BN105
                        IN01.1 (Country Maintenance).            BN145   BN150
                                                                 BN245   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR18.3
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR128
                                                                 PR13.1  PR13.2
                                                                 PR13.5  PR13.6
                                                                 ...

RGP-RECORD-TYPE        Alpha 1                                   BN100   BN101
Element: Record Type   This field identifies the type of         BN102   BN103
                       record defined.                           BN104   BN105
                                                                 BN145   BN150
                       Valid values are:                         BN245   BN305
                       S = Summary                               BN31.1  BN31.2
                       D = Detail                                BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR18.3
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR128
                                                                 PR13.1  PR13.2
                                                                 PR13.5  PR13.6
                                                                 ...

RGP-PAYROLL-YEAR       Numeric 4                                 BN100   BN101
Element: Payroll Year  Contains the payroll year in which the    BN102   BN103
                       allocation was taken.                     BN104   BN105
                                                                 BN145   BN150
                                                                 BN245   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR18.3
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR128
                                                                 PR13.1  PR13.2
                                                                 PR13.5  PR13.6
                                                                 ...

RGP-REPORT-ENTITY      Alpha 5                                   BN100   BN101
Element: Report Entity                                           BN102   BN103
                                                                 BN104   BN105
                                                                 BN145   BN150
                                                                 BN245   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR18.3
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR128
                                                                 PR13.1  PR13.2
                                                                 PR13.5  PR13.6
                                                                 ...

RGP-TAX-ID-CODE        Alpha 10                                  BN100   BN101
Element: Tax Id Code                                             BN102   BN103
                                                                 BN104   BN105
                                                                 BN145   BN150
                                                                 BN245   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR18.3
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR128
                                                                 PR13.1  PR13.2
                                                                 PR13.5  PR13.6
                                                                 ...

RGP-EMPLOYEE           Numeric 9                                 BN100   BN101
Element: Employee      Contains the employee number. Each        BN102   BN103
                       person employed by the company is         BN104   BN105
                       assigned a unique number. The system      BN145   BN150
                       uses the employee number to correlate     BN245   BN305
                       all of the information related to that    BN31.1  BN31.2
                       person.                                   BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR18.3
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR128
                                                                 PR13.1  PR13.2
                                                                 PR13.5  PR13.6
                                                                 ...

RGP-TOPIC              Alpha 2                                   BN100   BN101
Element: Topic                                                   BN102   BN103
                                                                 BN104   BN105
                                                                 BN145   BN150
                                                                 BN245   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR18.3
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR128
                                                                 PR13.1  PR13.2
                                                                 PR13.5  PR13.6
                                                                 ...

RGP-FLD-NBR            Numeric 4                                 BN100   BN101
Element: Fld Nbr       This field contains the PO dictionary     BN102   BN103
                       field number.                             BN104   BN105
                                                                 BN145   BN150
                                                                 BN245   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR18.3
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR128
                                                                 PR13.1  PR13.2
                                                                 PR13.5  PR13.6
                                                                 ...

RGP-SEQ-NBR            Numeric 4                                 BN100   BN101
Element: Seq Nbr       An automatically assigned sequence        BN102   BN103
                       number.                                   BN104   BN105
                                                                 BN145   BN150
                                                                 BN245   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR18.3
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR128
                                                                 PR13.1  PR13.2
                                                                 PR13.5  PR13.6
                                                                 ...

RGP-A-VALUE            Alpha 30  (Lower Case)                    BN305   HR11.1
Element: A Value                                                 HR11.2  HR18.3
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR05.1
                                                                 PR05.5  PR06.9
                                                                 PR07.3  PR11.1
                                                                 PR11.2  PR110
                                                                 PR113   PR120
                                                                 PR127   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR197
                                                                 PR20.2  PR27.1
                                                                 PR27.2  PR67.3
                                                                 PR67.5  PR68.1

RGP-S-VALUE            Signed 17.4                               BN100   BN101
Element: S Value                                                 BN102   BN103
                                                                 BN104   BN105
                                                                 BN145   BN150
                                                                 BN245   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 ET530   ETI1.1
                                                                 ETI2.1  HR11.1
                                                                 HR11.2  HR211
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR05.1  PR05.5
                                                                 PR06.9  PR07.1
                                                                 PR11.1  PR11.2
                                                                 PR110   PR113
                                                                 PR120   PR127
                                                                 PR128   PR13.1
                                                                 PR13.2  PR13.5
                                                                 PR13.6  PR13.8
                                                                 ...

RGP-D-VALUE            Numeric 8  (yyyymmdd)                     PR05.1  PR05.5
Element: D Value                                                 PR11.1  PR127
                                                                 PR197   PR20.2
                                                                 PR27.1  PR27.2
                                                                 PR67.9

RGP-DESCRIPTION        Alpha 30  (Lower Case)                    PR05.1  PR05.5
Element: Description   This field displays the description.      PR127   PR197
                                                                 PR20.2  PR227
                                                                 PR27.1

RGP-BUS-NBR-GRP        Alpha 4
Element: Bus Nbr Grp

                         PRREGPARM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RGPSET1   COMPANY                                                BN100   BN101
          COUNTRY-CODE                                           BN102   BN103
          PAYROLL-YEAR                                           BN104   BN105
          RECORD-TYPE                                            BN145   BN150
          REPORT-ENTITY                                          BN245   BN305
          TAX-ID-CODE                                            BN31.1  BN31.2
          EMPLOYEE                                               BN32.1  BN32.2
          TOPIC                                                  BN32.3  BN45.1
          FLD-NBR                                                BN531   BN65.1
          SEQ-NBR                                                BN66.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  ET530
                                                                 ETI1.1  ETI2.1
                                                                 HR11.1  HR11.2
                                                                 ...

RGPSET2   COMPANY                                                BN66.1  HR18.3
          COUNTRY-CODE                                           PR05.1  PR05.5
          RECORD-TYPE                                            PR06.9  PR07.1
          REPORT-ENTITY                                          PR07.3  PR127
          TAX-ID-CODE                                            PR139   PR140
          EMPLOYEE                                               PR189   PR195
          PAYROLL-YEAR                                           PR292   PR67.3
          TOPIC                                                  PR67.4  PR67.5
          FLD-NBR                                                PR67.9  PR68.1
          SEQ-NBR                                                PR80.1  PR89.1

RGPSET3   COMPANY       Subset                                   PR11.1  PR11.2
          COUNTRY-CODE  Where RECORD-TYPE = "E"                  PR127   PR243
          RECORD-TYPE                                            PR244   PR245
          EMPLOYEE                                               PR252   PR297
          REPORT-ENTITY                                          PR299
          PAYROLL-YEAR*
          TOPIC
          FLD-NBR
          SEQ-NBR

                         PRREGPARM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            RGP-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required
                            When RGP-RECORD-TYPE = "E"

                            RGP-COMPANY        -> EMP-COMPANY
                            RGP-EMPLOYEE       -> EMP-EMPLOYEE

Prtaxauth      PRTAXAUTH    Required
                            When RGP-TAX-ID-CODE != Spaces

                            RGP-TAX-ID-CODE    -> PRX-TAX-ID-CODE