Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROGPAYENT


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

PET-TABLE              Alpha 10                                  UK10.2
Element: Table         User defined table definition.

PET-EFFECT-DATE        Numeric 8  (yyyymmdd)                     UK10.2
Element: Date          Contains 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