PRGRPPAY – The Group Pay file contains the valid pay codes to be used for Web Time Record Entry.

System
Payroll (PR)
Prefix
PPY
Primary key
COMPANY, GROUP-NAME, PAY-CODE
Fields
4
Updated by
1 program
Referenced by
4 programs

PRGRPPAY is the The Group Pay file contains the valid pay codes to be used for Web Time Record Entry. table in Lawson Payroll (prefix PPY). It is indexed by COMPANY, GROUP-NAME, PAY-CODE (PPYSET1); alternate indexes: PPYSET2. It is related 1:1 to PERSGROUP and PRSYSTEM. It is updated by HS02.1 and referenced by HS34.1, HS35.1, HS36.1 and PR20.4. The table has 4 fields, 2 indexes and 2 documented relations.

About PRGRPPAY

The Group Pay file contains the valid pay codes to be used for Web Time Record Entry.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
PPY-COMPANY PK
COMPANY		Numeric 4—HS02.1
PPY-GROUP-NAME PK
GROUP_NAME		Alpha 10Contains the employee group.HS02.1, HS36.1
PPY-PAY-CODE PK
PAY_CODE		Alpha 4Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.HS02.1
PPY-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.HS02.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PPYSET1COMPANY, GROUP-NAME, PAY-CODEPrimaryHS02.1, HS34.1, HS35.1, HS36.1
PPYSET2COMPANY, PAY-CODE, GROUP-NAMEPR20.4

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Employee GroupPERSGROUPRequiredPPY-COMPANY → PRG-COMPANY, PPY-GROUP-NAME → PRG-GROUP-NAME
PrsystemPRSYSTEMRequiredPPY-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (4)