Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROGRATE


                             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
Element: Company Hr

PGA-REC-TYPE           Alpha 1                                   UK02.1  UK10.4
Element: Rec 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
Element: Table         Contains the user defined table
                       definition.

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

PGA-PAY-GROUP-NAME     Alpha 10                                  UK02.1  UK10.4
Element: Pay Group NameDefines 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
Element: 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
Element: 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
Element: From Units DspContains the number of units.

PGA-FROM-UNITS         Numeric 8                                 UK02.1  UK10.4
Element: 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
Element: From Unit TypeContains the type of units.
                       H = Hours
                       D = Days
                       M = Months

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

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

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

PGA-PAY-CLASS          Alpha 3                                   UK10.4
Element: Pay 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
Element: Rate          Contains the percentage rate.

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

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

PGA-CURR-ND            Numeric 1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


                         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                                                UK10.4  UK102
          REC-TYPE                                               UK110
          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