PROGPAYENT – This file contains the eligibility entry points for a progressive pay rate table and is linked to the PROGPAY file.
- System
- Payroll (PR)
- Prefix
PET- Primary key
COMPANY,TABLE,EFFECT-DATE,ENTRY-DATE- Fields
- 4
- Updated by
- 2 programs
- Referenced by
- 2 programs
PROGPAYENT is the This file contains the eligibility entry points for a progressive pay rate table and is linked to the PROGPAY file. table in Lawson Payroll (prefix PET). It is indexed by COMPANY, TABLE, EFFECT-DATE, ENTRY-DATE (PETSET1); alternate indexes: PETSET2. It is related 1:1 to PRSYSTEM. It is updated by UK10.1 and UK10.2 and referenced by UK110 and UK210. The table has 4 fields, 2 indexes and 1 documented relation.
About PROGPAYENT
This file contains the eligibility entry points for a progressive pay rate table and is linked to the PROGPAY file.
Fields (4)
Column = COBOL field name without the PET- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PET-COMPANY PKCOMPANY | Numeric 4 | — | UK10.2 |
PET-TABLE PKTABLE | Alpha 10 | User defined table definition. | UK10.2 |
PET-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | Contains the date this table is effective. | UK10.2 |
PET-ENTRY-DATE PKENTRY_DATE | Numeric 4 (mmdd) | Defines a date on which employees are eligible for the progressive pay rate table. | UK10.2 |
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 |
|---|---|---|---|---|
PETSET1 | COMPANY, TABLE, EFFECT-DATE, ENTRY-DATE | Primary | UK10.1, UK10.2, UK110, UK210 | |
PETSET2 | COMPANY, TABLE, EFFECT-DATE, ENTRY-DATE* | UK110 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | PET-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL |