Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PSGRELATE FILE

                     Pay Class/Pay Sum Grp Relation

Contains records that define which pay summary groups are linked to a pay
class.  PR20.3 (Pay Summary Group Relationship) is the primary program that
updates this file.

REFERENCED BY

AC541     AC542     BN100     BN101     BN102     BN103
BN105     BN145     BN150     BN245     BN31.1    BN31.2
BN32.1    BN32.2    BN32.3    BN340     BN345     BN45.1
BN500     BN531     BN66.1    BN71.1    BN72.1    BS12.1
BS13.1    BS14.1    BS15.1    BS32.1    HCOP.1    HR170
HR70.1    PBWC.1    PR128     PR131     PR132     PR134
PR135     PR136     PR139     PR195     PR220     PR270
PR278     PR282     PR290     PR291     PR292     PR297
PR298     PR32.2    PR32.1    PR33.2    PR33.3    PR33.1
PR35.1    PR35.2    PR35.3    PR35.4    PR35.5    PR35.6
PR35.8    PR36.1    PR418     PR530     PR560     PR82.1
PR85.1    PR89.1    PRWC.1    UK102     UK110     TA170
UK120     AC550     AC57.1    PR30.1    PR37.1

UPDATED BY

BN09.2    PR20.3    HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PSR-COMPANY          Numeric 4                                   BN09.2  PR20.3
Company              Contains the company number.

PSR-PAY-CLASS        Alpha 3                                     BN09.2  PR20.3
Payment Class        Contains the pay class to which pay
                     summary groups are related.

PSR-PAY-SUM-GRP      Alpha 3                                     BN09.2  PR20.3
Payment Summary      Contains the pay summary group
Group                associated with the pay class.

PSR-HOURS-FLAG       Alpha 1                                     BN09.2  PR20.3
Hours Flag           Indicates if hours associated with a
                     specific pay summary group are
                     included, excluded, or subtracted for
                     calculation and reporting.
                     I = Include
                     E = Exclude
                     S = Subtract

PSR-WAGES-FLAG       Alpha 1                                     BN09.2  PR20.3
Wages Flag           Indicates if wages associated with a
                     specific pay summary group are included,
                     excluded, or subtracted for calculation
                     and reporting.
                     I = Include
                     E = Exclude
                     S = Subtract

                         PSGRELATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PSRSET1   COMPANY                                                AC541   AC542
          PAY-CLASS                                              BN09.2  BN100
          PAY-SUM-GRP                                            BN101   BN102
                                                                 BN103   BN105
                                                                 BN145   BN150
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN340   BN345
                                                                 BN45.1  BN500
                                                                 BN531   BN66.1
                                                                 BN71.1  BN72.1
                                                                 BS12.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HCOP.1
                                                                 ...

PSRSET2   COMPANY                                                AC550   AC57.1
          PAY-SUM-GRP                                            BN09.2  PR134
          PAY-CLASS                                              PR136   PR20.2
                                                                 PR220   PR30.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR37.1  PR530

                         PSGRELATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PSR-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Pay Class      PAYCLASS     Required

                            PSR-COMPANY        -> PCL-COMPANY
                            PSR-PAY-CLASS      -> PCL-PAY-CLASS

Pay Sum Group  PAYSUMGRP    Required

                            PSR-COMPANY        -> PSG-COMPANY
                            PSR-PAY-SUM-GRP    -> PSG-PAY-SUM-GRP

                         PSGRELATE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pay Codes      PRPAYCODE

                            PSR-COMPANY        -> PCD-COMPANY
                            PSR-PAY-SUM-GRP    -> PCD-PAY-SUM-GRP
                                                  PCD-PAY-CODE
                                                  PCD-PROCESS-LEVEL
                                                  PCD-JOB-CODE