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 BN729 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 HCDL.1 HR170 HR70.1 PR521 EXI2.1
EXI4.1 LP130 LP140 PA495 PA82.1 PR128
PR130 PR131 PR132 PR136 PR137 PR139
PR140 PR160 PR180 PR189 PR195 PR197
PR270 PR271 PR278 PR282 PR289 PR29.1
PR291 PR292 PR37.1 PR418 PR45.1 PR529
PR560 PR582 PR82.1 PR85.1 PR89.1 UK102
UK110 UK560 TA146 TA147 TA170 PR30.1


UPDATED BY
PR20.3 PR20.1 PR20.2 BN340 BN345 BN954
HR00.1 HR01.1 PA490 PA594 PR134 PR135
PR188 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 XR901

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSR-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
PR20.3
PSR-PAY-CLASS
Element: Pay Class		Alpha 3
Contains the pay class to which pay summary groups are related.
PR20.3 TA170
PSR-PAY-SUM-GRP
Element: Pay Sum Grp		Alpha 3
Contains the pay summary group associated with the pay class.
PR20.3 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 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 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 BN729
BN954 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
HCDL.1 HR00.1
PSRSET2 COMPANY
PAY-SUM-GRP
PAY-CLASS
...
BN150 PR521
EXI2.1 EXI4.1
LP130 LP140
PR128 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR20.2
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: Wed Jun 08 20:49:17 2016

Home
Contact Us



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