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
PR192 PR32.1 PR32.2 PREN.1


UPDATED BY
PR21.1 PR21.3 PR21.4 PR21.2 PR521 PR999
BN100 BN101 BN102 BN103 BN105 BN145
BN150 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN340 BN45.1 BN531 BN66.1 BN71.1
BN72.1 BN729 BS06.1 BS12.1 BS13.1 BS14.1
BS15.1 BS32.1 PR221 HS03.1 PR139 PR140
PR189 PR195 PR271 PR80.1 PR80.4 PR89.1
PR274 PR582 PR82.1 PR282

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
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN340
BN45.1 BN531
BN66.1 BN71.1
BN72.1 BN729
BS06.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
PR21.1 PR21.2
PR21.3 PR21.4
PRYSET2 COMPANY
PLAN-CODE
EFFECT-DATE*
PAY-START-DATE*
PR274 PR582
PR82.1
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: Wed Jun 08 20:51:11 2016

Home
Contact Us



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