Lawson Insight Technical Documentation |
|
PROTWRKPRD
PROTWRKPRD FILE
Overtime Work Periods
This file contains the pay plans with the start and end dates of the work
periods within the plans.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN45.1 BN531 BN71.1 BN72.1 BS12.1 BS13.1
BS14.1 BS15.1 BS32.1 PR221 PR131 PR132
PR32.1 PR32.2 TP135 PREN.1
UPDATED BY
PR21.1 PR999
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRW-COMPANY Numeric 4 PR21.1 PR999
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PRW-PLAN-CODE Alpha 4 PR21.1 PR999
Element: Plan Contains the user-defined code that
represents a pay plan.
PRW-EFFECT-DATE Numeric 8 (yyyymmdd) PR21.1 PR999
Element: Effective DateContains the effective date of the pay
plan.
PRW-WRK-START-DATE Numeric 8 (yyyymmdd) PR21.1 PR999
Element: Wrk Start DateContains the work period start date.
PRW-WRK-END-DATE Numeric 8 (yyyymmdd) PR21.1 PR999
Element: Wrk End Date Contains the work period end date.
PROTWRKPRD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRWSET1 COMPANY BN100 BN101
PLAN-CODE BN102 BN103
EFFECT-DATE BN105 BN145
WRK-START-DATE BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN71.1 BN72.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 PR21.1
PR21.2 PR221
PR131
PRWSET2 COMPANY KeyChange PR131 PR132
PLAN-CODE PR32.1 PR32.2
WRK-END-DATE TP135
EFFECT-DATE*
PRWSET3 COMPANY KeyChange PR21.2 PR221
PLAN-CODE PR999 PREN.1
EFFECT-DATE
WRK-START-DATE*
PROTWRKPRD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PRW-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Overtime Plan PROVERTIME Required
PRW-COMPANY -> PRO-COMPANY
PRW-PLAN-CODE -> PRO-PLAN-CODE
PRW-EFFECT-DATE -> PRO-EFFECT-DATE
|