PROGRATE – This file contains the progressive pay rates based on rules.
- System
- Payroll (PR)
- Prefix
PGA- Primary key
COMPANY,REC-TYPE,TABLE,EFFECT-DATE,PAY-GROUP-NAME,FROM-UNITS- Fields
- 18
- Updated by
- 3 programs
- Referenced by
- 3 programs
PROGRATE is the This file contains the progressive pay rates based on rules. table in Lawson Payroll (prefix PGA). It is indexed by COMPANY, REC-TYPE, TABLE, EFFECT-DATE, PAY-GROUP-NAME, FROM-UNITS (PGASET1); alternate indexes: PGASET2. It is related 1:1 to PRSYSTEM, PAYCLASS, PERSGROUP and PROGPAY. It is updated by UK02.1, UK10.1 and UK10.4 and referenced by UK102, UK110 and UK210. The table has 18 fields, 2 indexes and 4 documented relations.
About PROGRATE
This file contains the progressive pay rates based on rules.
Fields (18)
Column = COBOL field name without the PGA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PGA-COMPANY PKCOMPANY | Numeric 4 | — | UK02.1, UK10.4 |
PGA-REC-TYPE PKREC_TYPE | Alpha 1 | Defines whether this is a progressive pay rate record or a bonus accrual record.
| UK02.1, UK10.4 |
PGA-TABLE PKTABLE | Alpha 10 | Contains the user defined table definition. | UK02.1, UK10.4 |
PGA-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | Contains the date this table is effective. | UK02.1, UK10.4 |
PGA-PAY-GROUP-NAME PKPAY_GROUP_NAME | Alpha 10 | Defines which employees are eligible for the pay rate table. Can be different than the employee group defined for eligibility. | UK02.1, UK10.4 |
PGA-AMT-PCTAMT_PCT | Alpha 1 | 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.
| UK10.4 |
PGA-FROM-DATEFROM_DATE | Alpha 2 | Contains the point at which the system starts determining which pay level the employee is at.
| UK02.1, UK10.4 |
PGA-FROM-UNITS-DSPFROM_UNITS_DSP | Numeric 5 | Contains the number of units. | UK02.1, UK10.4 |
PGA-FROM-UNITS PKFROM_UNITS | Numeric 8 | 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. | UK02.1, UK10.4 |
PGA-FROM-UNIT-TYPEFROM_UNIT_TYPE | Alpha 1 | Contains the type of units.
| UK02.1, UK10.4 |
PGA-TO-UNITS-DSPTO_UNITS_DSP | Numeric 5 | Not used at this time. | — |
PGA-TO-UNITSTO_UNITS | Numeric 8 | Not used at this time. | — |
PGA-TO-UNIT-TYPETO_UNIT_TYPE | Alpha 1 | Not used at this time.
| — |
PGA-PAY-CLASSPAY_CLASS | Alpha 3 | Contains the pay class entered to select specific types of hours to be used in determining eligibility. | UK10.4 |
PGA-RATERATE | Signed 13.4 | Contains the percentage rate. | UK10.4 |
PGA-BONUS-RATEBONUS_RATE | Signed 13.4 | Contains the rate to be used to calculate the bonus accrual amount. | UK02.1 |
PGA-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | — |
PGA-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | — |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PGASET1 | COMPANY, REC-TYPE, TABLE, EFFECT-DATE, PAY-GROUP-NAME, FROM-UNITS | Primary | UK02.1, UK10.1, UK10.4, UK110, UK210 | |
PGASET2 | COMPANY, REC-TYPE, TABLE, EFFECT-DATE, PAY-GROUP-NAME, FROM-UNITS* | UK10.4, UK102, UK110 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |