PRPROCGRP – Payroll Process Group

System
Human Resources (HR)
Prefix
PRP
Primary key
COMPANY, PROC-GROUP, PROCESS-LEVEL
Fields
3
Updated by
3 programs
Referenced by
79 programs

PRPROCGRP is the Payroll Process Group table in Lawson Human Resources (prefix PRP). It is indexed by COMPANY, PROC-GROUP, PROCESS-LEVEL (PRPSET1); alternate indexes: PRPSET2. It is related 1:1 to PRSYSTEM and 1:M to PRPROCGRP. It is updated by HR00.1, HR01.1 and HR08.1 and referenced by BN100, BN101, BN102, BN103, BN134, BN150, BN245, BN260 and 71 more. The table has 3 fields, 2 indexes and 3 documented relations.

About PRPROCGRP

The Payroll Process Group file identifies processing groups. You can use processing groups within the Lawson Payroll system to process a payroll cycle for a group of process levels without processing the entire company.

Fields (3)

Column = COBOL field name without the PRP- 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
#PRP-COMPANY PK
COMPANY		Numeric 4—HR08.1, PR00.1
#PRP-PROC-GROUP PK
PROC_GROUP		Alpha 10Contains the processing group (head process level). The processing group identifies a group of process levels.HR08.1, PR00.1
#PRP-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5Contains the process levels included in the head process level.HR08.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
PRPSET1
  1. COMPANY
  2. PROC-GROUP
  3. PROCESS-LEVEL
PrimaryBN100, BN101, BN102, BN103, BN134, BN150, BN245, BN260 +22 more (list truncated in source)
PRPSET2
  1. COMPANY
  2. PROCESS-LEVEL
  3. PROC-GROUP
BN66.1, HR00.1, HR01.1, HR08.1, PR140, PR189, PR195, PR277 +4 more

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PRP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Process LevelPRSYSTEMRequiredWhen PRP-PROCESS-LEVEL != Spaces
PRP-COMPANY→PRS-COMPANY
PRP-PROCESS-LEVEL→PRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
Process LevelsPRPROCGRPDelete CascadesValid When PRP-PROCESS-LEVEL = Spaces
PRP-COMPANY→PRP-COMPANY
PRP-PROC-GROUP→PRP-PROC-GROUP
—→PRP-PROCESS-LEVEL

Programs

Updated by (3)

Referenced by (79)