|
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
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PET-TABLE Alpha 10 UK10.2
Element: Table User defined table definition.
PET-EFFECT-DATE Numeric 8 (yyyymmdd) UK10.2
Element: Effective DateContains the date this table is
effective.
PET-ENTRY-DATE Numeric 4 (mmdd) UK10.2
Element: 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
|