PSGRELATE

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
BN245 BN260 BN305 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN340 BN345 BN45.1 BN531
BN66.1 BN71.1 BN72.1 BS12.1 BS13.1 BS14.1
BS15.1 BS32.1 ZB10.1 ZB10.2 ZB31.1 ZB31.2
ZB32.1 ZB32.2 ZB32.3 HCDL.1 HR170 HR70.1
PA490 PA495 PA594 PA82.1 PR138 PR139
PR140 PR160 PR180 PR188 PR195 PR197
PR220 PR227 PR240 PR241 PR242 PR243
PR244 PR245 PR252 PR270 PR271 PR274
PR278 PR282 PR287 PR289 PR290 PR291
PR292 PR297 PR299 PR418 PR84.1 PR85.1
PR89.1 PRAT.1 UK110 ZP554 ZH568 PR30.1
ZP139


UPDATED BY
PR20.3 PR20.8 BN150 HR00.1 HR01.1 PR521
EXI2.1 EXI4.1 LP130 PR128 PR131 PR132
PR134 PR135 PR136 PR137 PR189 PR29.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 PR36.1 PR36.4 PR37.1 PR45.1 PR529
PR530 PR560 PR582 PR80.1 PR80.4 PR82.1
UK102 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSR-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
PR20.3 PR20.8
PSR-PAY-CLASS
Element: Pay Class
Alpha 3
Contains the pay class to which pay summary groups are related.
PR20.3 PR20.8
PSR-PAY-SUM-GRP
Element: Pay Sum Grp
Alpha 3
Contains the pay summary group associated with the pay class.
PR20.3 PR20.8
PSR-HOURS-FLAG
Element: Hours Flag
Alpha 1
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
PR20.3 PR20.8
PSR-WAGES-FLAG
Element: Wages Flag
Alpha 1
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
PR20.3 PR20.8


PSGRELATE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSRSET1 COMPANY
PAY-CLASS
PAY-SUM-GRP
...
BN100 BN101
BN102 BN103
BN105 BN145
BN150 BN245
BN260 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN340
BN345 BN45.1
BN531 BN66.1
BN71.1 BN72.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB10.2 ZB31.1
PSRSET2 COMPANY
PAY-SUM-GRP
PAY-CLASS
...
BN150 PR521
ZH568 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.2 PR20.8
PR220 PR29.1
PR30.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6


PSGRELATE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:17:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.