PROGPAYENT FILE
This file contains the eligibility entry points for a progressive pay rate
table and is linked to the PROGPAY file.
REFERENCED BY
UK110 UK210
UPDATED BY
UK10.1 UK10.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PET-COMPANY Numeric 4 UK10.2
Company The company number represents an
established company and is entered on
all function codes.
PET-TABLE Alpha 10 UK10.2
Table User defined table definition.
PET-EFFECT-DATE Numeric 8 (yyyymmdd) UK10.2
Effective Date Contains the date this table is
effective.
PET-ENTRY-DATE Numeric 4 (mmdd) UK10.2
Entry Date Defines a date on which employees are
eligible for the progressive pay rate
table.
PROGPAYENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PETSET1 COMPANY UK10.1 UK10.2
TABLE UK110 UK210
EFFECT-DATE
ENTRY-DATE
PETSET2 COMPANY UK110
TABLE
EFFECT-DATE
ENTRY-DATE*
PROGPAYENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PET-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
|
