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