Lawson Insight Technical Documentation |
|
PROTPAYPRD
PROTPAYPRD FILE
Overtime Pay Periods
This file contains the pay plans with the start and end dates of the pay
periods within the plans.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN340 BN45.1 BN531 BN66.1 BN71.1 BN72.1
BS12.1 BS13.1 BS14.1 BS15.1 BS32.1 HS03.1
PR139 PR140 PR189 PR195 PR221 PR80.1
PR89.1 HR650 PR82.1 PR282 PR32.1 PR32.2
PREN.1
UPDATED BY
PR21.1 PR21.3 PR999
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRY-COMPANY Numeric 4 PR21.1 PR999
Element: Company The company number represents an
established company and is entered on
all function codes.
PRY-PLAN-CODE Alpha 4 PR21.1 PR999
Element: Plan Contains the user-defined code that
represents a pay plan.
PRY-EFFECT-DATE Numeric 8 (yyyymmdd) PR21.1 PR999
Element: Date Contains the effective date of the pay
plan.
PRY-PAY-START-DATE Numeric 8 (yyyymmdd) PR21.1 PR999
Element: Pay Start DateContains the pay period start date.
PRY-PAY-END-DATE Numeric 8 (yyyymmdd) PR21.1 PR999
Element: Pay End Date Contains the pay period end date.
PRY-STD-COST-HRS Signed 7.2 PR21.3
Element: Std Cost Hrs
PROTPAYPRD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRYSET1 COMPANY BN100 BN101
PLAN-CODE BN102 BN103
EFFECT-DATE BN105 BN145
PAY-START-DATE BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN340 BN45.1
BN531 BN66.1
BN71.1 BN72.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 HS03.1
PR139 PR140
PR189 PR195
PR21.1 PR21.2
...
PRYSET2 COMPANY HR650 PR82.1
PLAN-CODE
EFFECT-DATE*
PAY-START-DATE*
PRYSET3 COMPANY KeyChange PR21.2 PR282
PLAN-CODE PR32.1 PR32.2
EFFECT-DATE PR999 PREN.1
PAY-START-DATE*
PROTPAYPRD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PRY-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Overtime Plan PROVERTIME Required
PRY-COMPANY -> PRO-COMPANY
PRY-PLAN-CODE -> PRO-PLAN-CODE
PRY-EFFECT-DATE -> PRO-EFFECT-DATE
|