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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PGP-COMPANY PK
COMPANY		Numeric 4—UK02.1, UK10.1
#PGP-REC-TYPE PK
REC_TYPE		Alpha 1Defines 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 10User 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 SET2
END_DATE		Numeric 8 (yyyymmdd)The end date for this effort period.UK02.1, UK10.1
#PGP-ACTION-CODE
ACTION_CODE		Alpha 10This field contains the personnel action code.UK10.1
#PGP-GROUP-NAME SET2
GROUP_NAME		Alpha 10Defines which group of employees is eligible for this table.UK02.1, UK10.1
#PGP-SALARY-CLASS
SALARY_CLASS		Alpha 1Further 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 2Defines 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 5Contains the number of units.UK10.1
#PGP-ENT-UNITS-TYPE
ENT_UNITS_TYPE		Alpha 1Contains the type of units entered.
  • H Hours
  • D Days
  • M Months
UK10.1
#PGP-ENT-PAY-CLASS
ENT_PAY_CLASS		Alpha 3Contains 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 1Defines 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 2Defines 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 5Contains the number of units.UK10.1
#PGP-END-UNITS-TYPE
END_UNITS_TYPE		Alpha 1Defines the type of units entered.
  • H Hours
  • D Days
  • M Months
UK10.1
#PGP-END-PAY-CLASS
END_PAY_CLASS		Alpha 3Contains 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 1Defines 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PGPSET1
  1. COMPANY
  2. REC-TYPE
  3. TABLE
  4. EFFECT-DATE
PrimaryPA50.1, UK02.1, UK10.1, UK10.4, UK102, UK110, UK210, UK52.1
PGPSET2
  1. COMPANY
  2. GROUP-NAME
  3. REC-TYPE
  4. TABLE
  5. EFFECT-DATE
  6. END-DATE
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PERSACTYPEPRSYSTEMPERSGROUPPAYCLASSPROGPAYENDPROGPAYENTPROGRATEPROGPAY

One to one (5) — lookups and parents

RelationTableRulesConditionField map
ActionPERSACTYPERequired
PGP-COMPANY→PAT-COMPANY (PATSET1)
PGP-ACTION-CODE→PAT-ACTION-CODE
CompanyPRSYSTEMRequired
PGP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Employee GroupPERSGROUPRequired
PGP-COMPANY→PRG-COMPANY
PGP-GROUP-NAME→PRG-GROUP-NAME
End Pay ClassPAYCLASSRequired
PGP-COMPANY→PCL-COMPANY
PGP-END-PAY-CLASS→PCL-PAY-CLASS
Ent Pay ClassPAYCLASSRequired
PGP-COMPANY→PCL-COMPANY
PGP-ENT-PAY-CLASS→PCL-PAY-CLASS

One to many (3) — child tables

RelationTableRulesConditionField map
ProgpayendPROGPAYENDDelete Cascades
PGP-COMPANY→PED-COMPANY
PGP-TABLE→PED-TABLE
PGP-EFFECT-DATE→PED-EFFECT-DATE
—→PED-ENDING-DATE
ProgpayentPROGPAYENTDelete Cascades
PGP-COMPANY→PET-COMPANY
PGP-TABLE→PET-TABLE
PGP-EFFECT-DATE→PET-EFFECT-DATE
—→PET-ENTRY-DATE
ProgratePROGRATE
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)

Referenced by (5)