 |
Lawson Insight Technical Documentation |
|
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
|