PROGPAYEND FILE

                     UK Progressive Pay End Points

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
Company              The company number represents an
                     established company and is entered on
                     all function codes.

PED-TABLE            Alpha 10                                    UK10.3
Table                User defined table definition.

PED-EFFECT-DATE      Numeric 8  (yyyymmdd)                       UK10.3
Effective Date       Contains the date this table is
                     effective.

PED-ENDING-DATE      Numeric 4  (mmdd)                           UK10.3
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