PROTWRKPRD

Overtime Work Periods

This file contains the pay plans with the start and end dates of the work periods within the plans.

REFERENCED BY
PR221 PR132 PR32.1 PR32.2 PREN.1


UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN340 BN45.1 BN531 BN71.1 BN72.1 BS12.1
BS13.1 BS14.1 BS15.1 BS32.1 ZB10.1 ZB10.2
ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3 PR21.1
PR21.2 PR21.4 PR521 PR131 PR999

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRW-COMPANY
Element: Company Hr
Numeric 4
PR21.1 PR21.4
PR521 PR999
PRW-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the user-defined code that represents a pay plan.
PR21.1 PR21.4
PR521 PR999
PRW-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the effective date of the pay plan.
PR21.1 PR21.4
PR521 PR999
PRW-WRK-START-DATE
Element: Wrk Start Date
Numeric 8 (yyyymmdd)
Contains the work period start date.
PR21.1 PR21.4
PR521 PR999
PRW-WRK-END-DATE
Element: Wrk End Date
Numeric 8 (yyyymmdd)
Contains the work period end date.
PR21.1 PR21.4
PR521 PR999


PROTWRKPRD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRWSET1 COMPANY
PLAN-CODE
EFFECT-DATE
WRK-START-DATE
...
BN100 BN101
BN102 BN103
BN105 BN145
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN340 BN45.1
BN531 BN71.1
BN72.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
ZB10.1 ZB10.2
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 PR21.1
PRWSET2 COMPANY
PLAN-CODE
WRK-END-DATE
EFFECT-DATE*
KeyChange
PR131 PR132
PR32.1 PR32.2
PRWSET3 COMPANY
PLAN-CODE
EFFECT-DATE
WRK-START-DATE*
KeyChange
PR21.2 PR21.4
PR221 PR521
PR999 PREN.1


PROTWRKPRD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:27:16 2016

Home
Contact Us



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