PROGPAY – This file contains the table name, effective dates, and rules for eligibility.

System: Payroll (PR)
Prefix: PGP
Primary key: COMPANY, REC-TYPE, TABLE, EFFECT-DATE
Fields: 19
Updated by: 2 programs
Referenced by: 5 programs

PROGPAY is the This file contains the table name, effective dates, and rules for eligibility. table in Lawson Payroll (prefix PGP). It is indexed by COMPANY, REC-TYPE, TABLE, EFFECT-DATE (PGPSET1); alternate indexes: PGPSET2. It is related 1:1 to PERSACTYPE, PRSYSTEM, PERSGROUP and PAYCLASS and 1:M to PROGPAYEND, PROGPAYENT and PROGRATE. It is updated by UK02.1 and UK10.1 and referenced by PA50.1, UK102, UK110, UK210 and UK52.1. The table has 19 fields, 2 indexes and 8 documented relations.

About PROGPAY

This file contains the table name, effective dates, and rules for eligibility.

Fields (19)

Column = COBOL field name without the PGP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PGP-COMPANY` PK COMPANY	Numeric 4	—	UK02.1, UK10.1
`PGP-REC-TYPE` PK REC_TYPE	Alpha 1	Defines whether this is a progressive pay rate record or a bonus accrual record. `B` Bonus Pay	UK02.1, UK10.1
`PGP-TABLE` PK TABLE	Alpha 10	User defined table definition.	UK02.1, UK10.1
`PGP-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contains a further description of the table.	UK02.1, UK10.1
`PGP-EFFECT-DATE` PK EFFECT_DATE	Numeric 8 (yyyymmdd)	Contains the date this table is effective.	UK02.1, UK10.1
`PGP-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	The end date for this effort period.	UK02.1, UK10.1
`PGP-ACTION-CODE` ACTION_CODE	Alpha 10	This field contains the personnel action code.	UK10.1
`PGP-GROUP-NAME` GROUP_NAME	Alpha 10	Defines which group of employees is eligible for this table.	UK02.1, UK10.1
`PGP-SALARY-CLASS` SALARY_CLASS	Alpha 1	Further defines which employees are eligible for this table. Also defines if the rates entered are hourly or salary amounts. `H` Hourly `S` Salaried	UK10.1
`PGP-ENT-FROM-DATE` ENT_FROM_DATE	Alpha 2	Defines the date or the starting point from which other eligibility criteria may be used to determine if the employee is eligible for this table. `HI` Hire Date `AJ` Adjusted Hire Date `AN` Anniversary Date `SN` Seniority Date `X` Custom Calculation	UK10.1
`PGP-ENT-UNITS` ENT_UNITS	Numeric 5	Contains the number of units.	UK10.1
`PGP-ENT-UNITS-TYPE` ENT_UNITS_TYPE	Alpha 1	Contains the type of units entered. `H` Hours `D` Days `M` Months	UK10.1
`PGP-ENT-PAY-CLASS` ENT_PAY_CLASS	Alpha 3	Contains the pay class entered to select specific types of hours to be used in determining eligibility.	UK10.1
`PGP-ENT-POINT-TYPE` ENT_POINT_TYPE	Numeric 1	Defines which entry point is used to determine eligibility. `0` None `1` Prior entry point `2` Next entry point `3` Prior pay period `4` Next pay period `5` Prior work period `6` Next work period	UK10.1
`PGP-END-FROM-DATE` END_FROM_DATE	Alpha 2	Defines the starting point from which other criteria may be used to determine when the eligibility for this table ends. `HI` Hire Date `AJ` Adjusted Hire Date `AN` Anniversary Date `SN` Seniority Date `X` Custom Calculation	UK10.1
`PGP-END-UNITS` END_UNITS	Numeric 5	Contains the number of units.	UK10.1
`PGP-END-UNITS-TYPE` END_UNITS_TYPE	Alpha 1	Defines the type of units entered. `H` Hours `D` Days `M` Months	UK10.1
`PGP-END-PAY-CLASS` END_PAY_CLASS	Alpha 3	Contains the pay class entered to select specific types of hours to be used in determining eligibility.	UK10.1
`PGP-END-POINT-TYPE` END_POINT_TYPE	Numeric 1	Defines which entry point is used to determines eligibility. `0` None `1` Prior entry point `2` Next entry point `3` Prior pay period `4` Next pay period `5` Prior work period `6` Next work period	UK10.1

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
`PGPSET1`	`COMPANY`, `REC-TYPE`, `TABLE`, `EFFECT-DATE`	Primary		PA50.1, UK02.1, UK10.1, UK10.4, UK102, UK110, UK210, UK52.1
`PGPSET2`	`COMPANY`, `GROUP-NAME`, `REC-TYPE`, `TABLE`, `EFFECT-DATE`, `END-DATE`	KeyChange		—

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Field map
Action	PERSACTYPE	Required	`PGP-COMPANY` → `PAT-COMPANY (PATSET1)`, `PGP-ACTION-CODE` → `PAT-ACTION-CODE`
Company	PRSYSTEM	Required	`PGP-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee Group	PERSGROUP	Required	`PGP-COMPANY` → `PRG-COMPANY`, `PGP-GROUP-NAME` → `PRG-GROUP-NAME`
End Pay Class	PAYCLASS	Required	`PGP-COMPANY` → `PCL-COMPANY`, `PGP-END-PAY-CLASS` → `PCL-PAY-CLASS`
Ent Pay Class	PAYCLASS	Required	`PGP-COMPANY` → `PCL-COMPANY`, `PGP-ENT-PAY-CLASS` → `PCL-PAY-CLASS`

One to many (3) — child tables

Relation	Table	Rules	Field map
Progpayend	PROGPAYEND	Delete Cascades	`PGP-COMPANY` → `PED-COMPANY`, `PGP-TABLE` → `PED-TABLE`, `PGP-EFFECT-DATE` → `PED-EFFECT-DATE`, → `PED-ENDING-DATE`
Progpayent	PROGPAYENT	Delete Cascades	`PGP-COMPANY` → `PET-COMPANY`, `PGP-TABLE` → `PET-TABLE`, `PGP-EFFECT-DATE` → `PET-EFFECT-DATE`, → `PET-ENTRY-DATE`
Prograte	PROGRATE		`PGP-COMPANY` → `PGA-COMPANY`, `PGP-REC-TYPE` → `PGA-REC-TYPE`, `PGP-TABLE` → `PGA-TABLE`, `PGP-EFFECT-DATE` → `PGA-EFFECT-DATE`, → `PGA-PAY-GROUP-NAME`, → `PGA-FROM-UNITS`

Programs

Updated by (2)

UK02.1 Bonus Pay Table
UK10.1 Pay Rate Table

Referenced by (5)

PA50.1 Action
UK102 Bonus Pay Update
UK110 Pay Rate Table Update
UK210 Pay Rate Table Listing
UK52.1 Bonus Pay Accrual History