Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PSGRELATE


                             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

BN100     BN101     BN102     BN103     BN105     BN145
BN150     BN245     BN31.1    BN31.2    BN32.1    BN32.2
BN32.3    BN340     BN345     BN45.1    BN531     BN71.1
BN72.1    BS12.1    BS13.1    BS14.1    BS15.1    BS32.1
HCDL.1    HR170     HR70.1    PA490     PA495     PA594
PA82.1    PBWC.1    PR128     PR130     PR131     PR132
PR134     PR135     PR136     PR160     PR180     PR188
PR220     PR227     PR240     PR241     PR242     PR243
PR244     PR245     PR252     PR270     PR278     PR282
PR289     PR29.1    PR290     PR291     PR292     PR297
PR298     PR299     PR32.2    PR32.1    PR33.2    PR33.3
PR33.1    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR35.9    PR36.1    PR418     PR45.1
PR529     PR530     PR560     PR82.1    PR84.1    PR85.1
PRWC.1    UK102     UK110     UK201     UK202     TA146
TA147     TA170     TP135     PR30.1    PR37.1    TP140

UPDATED BY

PR20.3    HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PSR-COMPANY            Numeric 4                                 PR20.3
Element: Company Hr    Contains the company number.

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

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

PSR-HOURS-FLAG         Alpha 1                                   PR20.3  TA170
Element: 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                                   PR20.3  TA170
Element: 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                                                BN100   BN101
          PAY-CLASS                                              BN102   BN103
          PAY-SUM-GRP                                            BN105   BN145
                                                                 BN150   BN245
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN340
                                                                 BN345   BN45.1
                                                                 BN531   BN71.1
                                                                 BN72.1  BS12.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 HCDL.1  HR00.1
                                                                 HR01.1  HR170
                                                                 HR70.1  PA490
                                                                 ...

PSRSET2   COMPANY                                                PR134   PR136
          PAY-SUM-GRP                                            PR20.2  PR220
          PAY-CLASS                                              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  PR35.9
                                                                 PR37.1  PR530
                                                                 TP135   TP140

                         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