PROTPAYPRD

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
BN150 BN245 BN260 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN340 BN45.1 BN531 BN66.1
BN71.1 BN72.1 BS06.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 PR221 HS03.1 HS18.1
PR134 PR139 PR140 PR189 PR195 PR271
PR80.1 PR80.4 PR89.1 PRAT.1 PR274 PR582
PR82.1 ZP551 ZP580 PR282 PR32.1 PR32.2
PREN.1


UPDATED BY
PR21.1 PR21.3 PR21.4 PR521 PR999 PR192

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRY-COMPANY
Element: Company Hr		Numeric 4
PR21.1 PR21.4
PR521 PR999
PRY-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code that represents a pay plan.
PR21.1 PR21.4
PR521 PR999
PRY-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Contains the effective date of the pay plan.
PR21.1 PR21.4
PR521 PR999
PRY-PAY-START-DATE
Element: Pay Start Date		Numeric 8 (yyyymmdd)
Contains the pay period start date.
PR21.1 PR21.4
PR521 PR999
PRY-PAY-END-DATE
Element: Pay End Date		Numeric 8 (yyyymmdd)
Contains the pay period end date.
PR21.1 PR21.4
PR521 PR999
PRY-STD-COST-HRS
Element: Std Cost Hrs		Signed 7.2
PR21.3 PR21.4
PR521


PROTPAYPRD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRYSET1 COMPANY
PLAN-CODE
EFFECT-DATE
PAY-START-DATE
...
BN100 BN101
BN102 BN103
BN105 BN145
BN150 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN340 BN45.1
BN531 BN66.1
BN71.1 BN72.1
BS06.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
ZB10.1 ZB10.2
ZB31.1 ZB31.2
PRYSET2 COMPANY
PLAN-CODE
EFFECT-DATE*
PAY-START-DATE*
BN66.1 PR140
PR189 PR195
PR274 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 ZP551
ZP580
PRYSET3 COMPANY
PLAN-CODE
EFFECT-DATE
PAY-START-DATE*
KeyChange
PR21.2 PR21.4
PR521 PR271
PR282 PR32.1
PR32.2 PR999
PREN.1


PROTPAYPRD FILE RELATIONS


ONE TO ONE RELATIONS

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

File created: Thu Jun 09 02:30:37 2016

Home
Contact Us



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