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
BN150 BN245 BN305 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 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 PR521 ZH568
EXI2.1 EXI4.1 LP130 PA495 PR128 PR130
PR131 PR132 PR136 PR137 PR139 PR140
PR160 PR180 PR189 PR195 PR197 PR270
PR271 PR278 PR282 PR289 PR29.1 PR291
PR292 PR30.1 PR37.1 PR418 PR45.1 PR529
PR560 PR582 PR82.1 PR85.1 PR89.1 UK102
UK110 UK560 ZP139 TA146 TA147 TA170
PA82.1


UPDATED BY
BN340 BN345 HR00.1 HR01.1 PA490 PA594
PR134 PR135 PR188 PR20.1 PR20.2 PR20.3
PR20.8 PR220 PR227 PR240 PR241 PR242
PR243 PR244 PR245 PR252 PR274 PR287
PR290 PR297 PR299 PR32.2 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR530 PR80.1 PR80.4
PR84.1 UK201 UK202 ZP530 ZP554 ZP574

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
TA170
PSR-PAY-SUM-GRP
Element: Pay Sum Grp		Alpha 3
Contains the pay summary group associated with the pay class.
PR20.3 PR20.8
TA170
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
TA170
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
TA170


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
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
PSRSET2 COMPANY
PAY-SUM-GRP
PAY-CLASS
...
BN150 PR521
ZH568 EXI2.1
EXI4.1 LP130
PR128 PR130
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


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 11:15:35 2016

Home
Contact Us



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