Lawson Insight Technical Documentation |
|
PSGRELATE
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 PA490 PA594 PBWC.1 PR128 PR130
PR131 PR132 PR134 PR135 PR136 PR139
PR140 PR160 PR180 PR188 PR189 PR195
PR220 PR227 PR240 PR241 PR242 PR243
PR244 PR245 PR252 PR270 PR278 PR282
PR289 PR29.1 PR290 PR291 PR292 PR297
PR298 PR299 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 PR45.1 PR529
PR530 PR560 PR80.1 PR80.2 PR82.1 PR84.1
PR85.1 PR89.1 PRWC.1 UK102 UK110 UK201
UK202 UK560 TA146 TA147 TA170 UK120
AC550 AC57.1 PR30.1 PR37.1
UPDATED BY
BN09.2 PR20.3 HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSR-COMPANY Numeric 4 BN09.2 PR20.3
Element: Company Contains the company number.
PSR-PAY-CLASS Alpha 3 BN09.2 PR20.3
Element: Payment Class Contains the pay class to which pay TA170
summary groups are related.
PSR-PAY-SUM-GRP Alpha 3 BN09.2 PR20.3
Payment Summary Contains the pay summary group TA170
Group associated with the pay class.
PSR-HOURS-FLAG Alpha 1 BN09.2 PR20.3
Element: Hours Flag Indicates if hours associated with a TA170
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
Element: Wages Flag Indicates if wages associated with a TA170
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
|