Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROGPAYEND


                            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