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
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 ET530 ETI2.1 HCDL.1 HR170
HR70.1 LP130 PA490 PA495 PA594 PA82.1
PR128 PR130 PR131 PR132 PR134 PR135
PR136 PR139 PR140 PR160 PR180 PR188
PR189 PR195 PR197 PR220 PR227 PR240
PR241 PR242 PR243 PR244 PR245 PR252
PR270 PR274 PR278 PR282 PR287 PR289
PR29.1 PR290 PR291 PR292 PR297 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
PR35.9 PR36.1 PR418 PR45.1 PR529 PR530
PR560 PR80.1 PR80.2 PR82.1 PR84.1 PR85.1
PR89.1 UK102 UK110 UK201 UK202 UK560
TA146 TA147 TA170 PR30.1 PR37.1
UPDATED BY
PR20.3 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSR-COMPANY Numeric 4 PR20.3
Element: Company Hr Contains the company number.
PSR-PAY-CLASS Alpha 3 PR20.3 TA170
Element: Pay Class Contains the pay class to which pay
summary groups are related.
PSR-PAY-SUM-GRP Alpha 3 PR20.3 TA170
Element: Pay Sum Grp Contains the pay summary group
associated with the pay class.
PSR-HOURS-FLAG Alpha 1 PR20.3 TA170
Element: 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 PR20.3 TA170
Element: 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 BN100 BN101
PAY-CLASS BN102 BN103
PAY-SUM-GRP 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
ET530 ETI2.1
HCDL.1 HR00.1
...
PSRSET2 COMPANY ET530 PR134
PAY-SUM-GRP PR136 PR20.2
PAY-CLASS 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
PR35.9 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
|