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 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
PR137 PR139 PR140 PR150 PR160 PR180
PR195 PR199 PR220 PR270 PR278 PR290
PR291 PR292 PR297 PR298 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR37.1
PR45.1 PR530 PR560 PR80.1 PR80.2 PR82.1
PR85.1 PR89.1 PRWC.1 UK102 UK110 UK330
TA170 UK120 AC750 PR30.1
UPDATED BY
BN09.2 PR20.3 HR00.1 HR01.1 PBIP.1
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 BN09.2 BN100
PAY-CLASS BN101 BN102
PAY-SUM-GRP 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
HR00.1 HR01.1
...
PSRSET2 COMPANY AC750 BN09.2
PAY-SUM-GRP PR134 PR136
PAY-CLASS 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
|