Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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