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