Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PROGRATE FILE

This file contains the progressive pay rates based on rules.

REFERENCED BY

UK110     UK210     UK102

UPDATED BY

UK02.1    UK10.1    UK10.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PGA-COMPANY          Numeric 4                                   UK02.1  UK10.4
Company              The company number represents an
                     established company and is entered on
                     all function codes.


PGA-REC-TYPE         Alpha 1                                     UK02.1  UK10.4
Record Type          Defines whether this is a progressive
                     pay rate record or a bonus accrual
                     record.
                     B = Bonus Pay

PGA-TABLE            Alpha 10                                    UK02.1  UK10.4
Table                Contains the user defined table
                     definition.

PGA-EFFECT-DATE      Numeric 8  (yyyymmdd)                       UK02.1  UK10.4
Effective Date       Contains the date this table is
                     effective.

PGA-PAY-GROUP-NAME   Alpha 10                                    UK02.1  UK10.4
Pay Group Name       Defines which employees are eligible
                     for the pay rate table. Can be different
                     than the employee group defined for
                     eligibility.

PGA-AMT-PCT          Alpha 1                                     UK10.4
Amt Pct              Defines if the rates being entered are
                     amounts of percents. An amount is an
                     actual rate of pay. If a percent is
                     entered, the system performs a
                     calculation to determine the current
                     rate of pay.
                     A = Amount
                     P = Percent

PGA-FROM-DATE        Alpha 2                                     UK02.1  UK10.4
From Date            Contains the point at which the system
                     starts determining which pay level the
                     employee is at.

                     HI = Hire Date
                     AJ = Adjusted Hire Date
                     AN = Anniversary Date
                     SN = Seniority Date
                     X = Custom Calculation

PGA-FROM-UNITS-DSP   Numeric 5                                   UK02.1  UK10.4
From Units Dsp       Contains the number of units.

PGA-FROM-UNITS       Numeric 8                                   UK02.1  UK10.4
From Units           If different unit types are defined,
                     the units are converted to the lowest
                     common denominator and stored here. This
                     is used to display units in their proper
                     order.

PGA-FROM-UNIT-TYPE   Alpha 1                                     UK02.1  UK10.4
From Unit Type       Contains the type of units.
                     H = Hours
                     D = Days
                     M = Months

PGA-TO-UNITS-DSP     Numeric 5
To Units Dsp         Not used at this time.

PGA-TO-UNITS         Numeric 8
To Units             Not used at this time.

PGA-TO-UNIT-TYPE     Alpha 1
To Unit Type         Not used at this time.
                     H = Hours
                     D = Days
                     M = Months

PGA-PAY-CLASS        Alpha 3                                     UK10.4
Payment Class        Contains the pay class entered to
                     select specific types of hours to be
                     used in determining eligibility.

PGA-RATE             Signed 13.4                                 UK10.4
Rate                 Contains the percentage rate.

PGA-BONUS-RATE       Signed 13.4                                 UK02.1
Bonus Rate           Contains the rate to be used to
                     calculate the bonus accrual amount.


PGA-CURRENCY-CODE    Alpha 5
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).


PGA-CURR-ND          Numeric 1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

                         PROGRATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PGASET1   COMPANY                                                UK02.1  UK10.1
          REC-TYPE                                               UK10.4  UK110
          TABLE                                                  UK210
          EFFECT-DATE
          PAY-GROUP-NAME
          FROM-UNITS

PGASET2   COMPANY                                                UK102   UK110
          REC-TYPE
          TABLE
          EFFECT-DATE
          PAY-GROUP-NAME
          FROM-UNITS*

                         PROGRATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PGA-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Pay Class      PAYCLASS     Required

                            PGA-COMPANY           -> PCL-COMPANY
                            PGA-PAY-CLASS         -> PCL-PAY-CLASS

Pay Emp Group  PERSGROUP    Required

                            PGA-COMPANY           -> PRG-COMPANY
                            PGA-PAY-GROUP-NAME    -> PRG-GROUP-NAME

Progpay        PROGPAY      Required

                            PGA-COMPANY           -> PGP-COMPANY
                            PGA-REC-TYPE          -> PGP-REC-TYPE
                            PGA-TABLE             -> PGP-TABLE
                            PGA-EFFECT-DATE       -> PGP-EFFECT-DATE