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

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 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
PPYSET1
  1. COMPANY
  2. GROUP-NAME
  3. PAY-CODE
PrimaryHS02.1, HS34.1, HS35.1, HS36.1
PPYSET2
  1. COMPANY
  2. PAY-CODE
  3. GROUP-NAME
PR20.4

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Employee GroupPERSGROUPRequired
PPY-COMPANY→PRG-COMPANY
PPY-GROUP-NAME→PRG-GROUP-NAME
PrsystemPRSYSTEMRequired
PPY-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (4)