PERSGROUP – Employee Group Header

System: Human Resources (HR)
Prefix: PRG
Primary key: COMPANY, GROUP-NAME
Fields: 12
Updated by: 70 programs
Referenced by: 280 programs

PERSGROUP is the Employee Group Header table in Lawson Human Resources (prefix PRG). It is indexed by COMPANY, GROUP-NAME (PRGSET1); alternate indexes: PRGSET2 and PRGSET3. It is related 1:1 to PRSYSTEM and PADICT and 1:M to PGSELECT, PGEMPLOYEE, PROGPAY and STANDTIME. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR06.1 and 62 more and referenced by AC62.1, BN06.1, BN08.1, BN100, BN101, BN102, BN103, BN145 and 272 more. The table has 12 fields, 3 indexes and 9 documented relations.

About PERSGROUP

Contains the definition of a user-defined employee group.

Fields (12)

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

Field / column	Type	Description & values	Updated by
`PRG-COMPANY` PK COMPANY	Numeric 4	Contains the number that represents an established company and is entered on all functions.	HR55.1, HR55.2
`PRG-GROUP-NAME` PK GROUP_NAME	Alpha 10	Contains the employee group name.	HR55.1, HR55.2
`PRG-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contains the group description.	BN16.2, BN17.2, BN17.3, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5 +6 more
`PRG-FLD-NBR` FLD_NBR	Numeric 4 Occurs 9 Times ×9	Contains the HR data dictionary field number of the item selected as criteria for the employee group.	HR55.1
`PRG-LAST-ITEM-SEQ` LAST_ITEM_SEQ	Numeric 4	Contains the sequence number used to store the last employee group selection record.	HR55.2, HR55.3
`PRG-UPDATE-FLAG` UPDATE_FLAG	Alpha 1	Determines whether the employee group is current or needs to be updated.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR06.1 +52 more (list truncated in source)
`PRG-GRP-ORDER` GRP_ORDER	Numeric 1	Indicates whether the group is used as a criteria for another group. 0 1	HR55.3
`PRG-BENEFITS` BENEFITS	Alpha 1	Indicates whether the employee group can be used by benefits for plan definition. `Y` Yes `N` No	HR55.1, HR55.2, HR55.3
`PRG-ABSENCE-MGMT` ABSENCE_MGMT	Alpha 1	— `N` No `Y` Yes	HR55.1, HR55.2, HR55.3
`PRG-PEP-LEVEL-ONE` PEP_LEVEL_ONE	Alpha 1	This field was added in the 8.1.0 release, but is not currently being used for any processing `N` No `Y` Yes	—
`PRG-PEP-LEVEL-TWO` PEP_LEVEL_TWO	Alpha 1	This field was added in the 8.1.0 release, but is not currently being used in any processing. `N` No `Y` Yes	—
`PRG-ACTIVE-FLAG` ACTIVE_FLAG	Numeric 1	— `1` Active `2` Inactive	HR55.1

Indexes (3)

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
`PRGSET1`	`COMPANY`, `GROUP-NAME`	Primary		AC62.1, BN06.1, BN08.1, BN100, BN101, BN102, BN103, BN145 +22 more (list truncated in source)
`PRGSET2`	`COMPANY`, `GRP-ORDER`, `GROUP-NAME`	KeyChange, Subset	Where UPDATE-FLAG = "Y"	HR155
`PRGSET3`	`COMPANY`, `GRP-ORDER`, `GROUP-NAME`	KeyChange		HR155, HR156, ZH156

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`PRG-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Field Nbr	PADICT	Required	When PRG-FLD-NBR != Zeroes	`PRG-FLD-NBR` → `PAD-FLD-NBR`

One to many (7) — child tables

Relation	Table	Rules	Field map
Employee Nbr	PGSELECT		`PRG-COMPANY` → `PGS-COMPANY`, `PRG-GROUP-NAME` → `PGS-GROUP-NAME`, → `PGS-EMPLOYEE`, → `PGS-SEQ-NBR`
Employees	PGEMPLOYEE	Delete Cascades	`PRG-COMPANY` → `PGE-COMPANY`, `PRG-GROUP-NAME` → `PGE-GROUP-NAME`, → `PGE-EMPLOYEE`
Pgselect	PGSELECT	Delete Cascades	`PRG-COMPANY` → `PGS-COMPANY`, `PRG-GROUP-NAME` → `PGS-GROUP-NAME`, → `PGS-EMPLOYEE`, → `PGS-SEQ-NBR`
Progpay	PROGPAY		`PRG-COMPANY` → `PGP-COMPANY`, `PRG-GROUP-NAME` → `PGP-GROUP-NAME`, `Spaces` → `PGP-REC-TYPE`, → `PGP-TABLE`, → `PGP-EFFECT-DATE`, → `PGP-END-DATE`
Progpay Bonus	PROGPAY		`PRG-COMPANY` → `PGP-COMPANY`, `PRG-GROUP-NAME` → `PGP-GROUP-NAME`, `"B"` → `PGP-REC-TYPE`, → `PGP-TABLE`, → `PGP-EFFECT-DATE`, → `PGP-END-DATE`
Selection	PGSELECT	Delete Cascades	`PRG-COMPANY` → `PGS-COMPANY`, `PRG-GROUP-NAME` → `PGS-GROUP-NAME`, → `PGS-ITEM-GRP`, → `PGS-FLD-NBR`, → `PGS-SEQ-NBR`
Standtime	STANDTIME	Required	`PRG-COMPANY` → `STM-COMPANY`, `Zeroes` → `STM-EMPLOYEE`, `PRG-GROUP-NAME` → `STM-TIME-GROUP`, → `STM-PAY-CODE`, → `STM-SEQ-NBR`

Programs

Updated by (70)

BN305 Highly Compensated Employees
HAP3.1 Applicant Option 4 Selection Invoke
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR06.1 Job Code
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR15.1 User Fields
HR155 Employee Group Update
HR156 Employee Group Company Update
HR28.1 Employee Ethnicity
HR506 Job Code Conversion
HR511 Employee Conversion
HR515 User Field Conversion
HR54.1 Employee History Correction
HR55.1 Employee Group Definition
HR55.2 Employee Groups By Employees
HR55.3 Employee Groups By Criteria
HRS1.1 Select Control
HRSC.1 Select Control
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA16.1 Company Property
PA20.1 Education
PA21.1 Competencies
PA22.1 Certifications
PA24.1 Relocation
PA27.1 Contracts
PA34.1 Applicant Education
PA35.1 Applicant Competencies
PA36.1 Applicant Certification
PA38.1 Applicant Relocation
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA520 Employee and Applicant Code Conversion
PA54.1 Personnel Action History Correction
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.1 Standard Time Record
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
TR21.1 Employee Training History
TR22.1 Session Completion
TR26.1 Employee Training Competency Maintenance
TR500 Training Conversion
ZH156 Employee Group Company Update
ZH510 Update PCP from ZPENDPCP

Referenced by (280)

AC62.1 Pool Driver Values
BN06.1 Flex Plan
BN08.1 Flex Credits
BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN145 Flex Dollars Calculation
BN15.1 Benefit Plan
BN150 Life Insurance Reportable Income
BN16.1 Benefit Entry Rules
BN16.2 Add Rules
BN16.3 Change Rules
BN16.4 Termination Rules
BN17.2 Coverage Option Defaults
BN17.3 Coverage Amounts
BN18.1 Options Amount
BN18.2 Options Amount Range
BN18.3 Flat Contributions
BN18.4 Salary or Coverage Rate Table
BN18.5 Contribution Limits
BN18.6 Match Limit Schedule
BN18.7 Match Percent Schedule
BN19.1 Options Rates
BN19.2 Options Rate Tables
BN19.3 Match Limits
BN19.4 Match Percents
BN20.1 General Ledger Overrides
BN206 Flex Plan Listing
BN215 Plan Parameter Listing
BN216 Benefit Entry Rules Listing
BN23.1 Stock Option Grant
BN230 Plan Participant Report
BN231 Employee Benefit Report
BN232 Benefits Statement
BN234 Employee Stock Option Listing
BN238 Vacation Hours History
BN240 Savings Bond Balance Report
BN242 One Page Benefits Statement
BN245 Benefit Election Form
BN246 Flex Missing Benefits Report
BN247 Beneficiary Listing
BN260 Employee Benefit Extract
BN285 Standard Letter Print
BN320 Premium Report
BN321 Dependent Benefit Listing
BN331 HIPAA Certification Report
BS01.1 Benefits Enrollment Rules
BS03.1 Benefits Annual Enrollment Plan Rules
BS03.2 Benefits Life Event Plan Rules
BS03.3 Benefits New Hire Plan Rules
BS03.4 Current Benefits Display Rules
BS05.1 Benefits New Hire Rules
BS531 Web Pending Employee Benefit Extract
ES02.2 Absence Plan Balances Rule
ES02.3 Hours to Days Conversion Rule
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HC01.2 Employee Dimension Definition
HPRG.1 Employee Group Selection Invoke
HR04.4 Alphanumeric User Fields
HR04.5 Numeric User Fields
HR04.6 Date User Fields
HR105 Employee Audit Report
HR125 Employee Audit Purge
HR170 Human Resource Writer Report Request
HR211 Employee Listing
HR213 Dependent Listing
HR217 Work Eligibility Listing
HR220 Additional Contact Listing
HR228 Employee Ethnicity Listing
HR255 Employee Group Listing
HR50.1 Interface Rules
HR70.1 Human Resource Writer Inquiry
HR710 EEO-1 Job Category Update
HR93.8 Employee Leave Plan Audit Inquiry
HR951 Initial Interface Load
HS01.1 Time Entry Form
HS02.1 Time Entry Pay Codes
HS05.1 Time Record Exception Setup
HS16.1 EMSS Length of Service Rules
HS18.1 Payroll Lock Out Rules
HS20.1 Time Form Inquiry
HS208 Goal Management Report
HS21.1 Time Form Inquiry
HS535 Pending Time Record Extract
HS536 Pending Time Record Purge
HS703 LPMH Employee and Job Profile Extract
HS704 LPMH Licensure Extract
HS705 Emp Work Force Mgmt Extract
HS706 HRM Time Off Planner Interface
LP02.1 Plan Structure
LP10.1 Link Plan Table
LP102 Employee Master Update
LP103 Mass Absence Plan Termination
LP130 Absence Plan Payout
LP131 Zero Balance Update
LP138 Absence Plan Hours Update
LP140 Employee Absence Plan Calculation
LP145 Allotment Adjustment Calculation
LP15.1 Absence Plan Benefit Groups
LP151 FMLA Rolling 12 Month Update
LP180 Mass Absence Plan Transfer
LP188 Length of Service Hours Update
LP197 Absence Plan Close
LP199 Close Unprocessed Service Records
LP201 Absence Plan Listing
LP231 Employee Plan Master Listing
LP240 Employee Plan Transaction Report
LP251 Employee Leave of Absence Report
LP260 Employee Service and Event Report
LP262 Employee Event Audit Report
LP264 Employee Transaction History Report
LP270 Open Manual Transactions
LP31.1 Employee Absence Plan Master
LP32.1 Employee Absence Enrollment
LP32.2 Employee Absence Enrollment
LP32.3 Employee Absence Enrollment
LP331 Employee Absence Plan Purge
LP34.1 Absence Plan Hours Allocation
LP35.1 Employee Absence Group Audit
LP570 Manual Transaction Conversion
LP63.1 Absence Plan Hours Balances
LP63.2 Absence Plan Earnings Balances
LP64.1 Employee Transaction Detail Inquiry
LP64.2 Employee Transaction Summary Inquiry
LP64.3 Employee Transaction Detail Balance Inquiry
LP70.1 Manual Transactions by Employee
LP70.2 Manual Transactions by Plan Structure
LP80.1 Employee Absence Plan Transfer
LP88.1 Length of Service Hours
LT213 Interface Audit Export
PA103 Mass Position Changes
PA105 Employee Audit Report
PA113 Retroactive History Update
PA125 Employee History Purge
PA182 Salary Encumbrance Update
PA210 Length of Service Report
PA212 Emergency Contact Listing
PA213 Position and Job Listing
PA214 Military Service Listing
PA215 Medical Listing
PA216 Company Property Listing
PA217 Automobile Listing
PA218 Travel Listing
PA219 Prior Work History Listing
PA220 Education Listing
PA221 Employee Competency Listing
PA222 Certification Listing
PA223 Starters and Leavers Report
PA224 Relocation Listing
PA225 Employee Benefits Listing
PA227 Contract Listing
PA248 Test Listing
PA249 Employee and Applicant Test Listing
PA258 Report of Actions on Hold
PA290 Health and Safety Incident Listing
PA296 Canadian Language Bilingual Requirements Listing
PA310 Birthdate Listing
PA311 Employee Profile
PA313 Employee Position and Job History Purge
PA315 Telephone Listing
PA320 Interoffice Directory
PA325 Post Office Mailing Listing
PA330 Interoffice Labels
PA335 Employee Listing
PA340 Action History Listing
PA345 Review Schedule Report
PA350 Review History Report
PA355 Active Actions Report
PA360 Wage Analysis Report
PA370 Employee Review Document
PA48.1 Test Setup
PA495 IPEDS Report
PA496 Official Languages Report
PA534 e-Recruiting Employee Export
PA66.2 Action Inquiry
PR07.7 State Reporting Information
PR11.3 Employee HIRE Act Tax Reporting Info
PR127 Year-End Parameters Copy/Delete
PR128 Offset Time Record Creation
PR129 Roth Plan Start Dates
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR139 Arrears Automation
PR188 Payroll Hours Update
PR189 Gross Up Calculation
PR195 Accrual Program
PR212 Direct Deposit Account Listing
PR214 Employee Deduction Listing
PR226 United States Employee Garnishment Listing
PR227 Year-End Parameter Report
PR230 Standard Time Record Listing
PR240 T4-T4A Slips
PR241 T4-T4A XML
PR242 T4-T4A Reports
PR243 Releve Slips
PR244 Releve Magnetic Media
PR245 Releve Reports
PR247 Canada Employee Garnishment Listing
PR249 PIER Audit Report
PR250 1099-R Form Reporting
PR252 United States Territory W-2 Form Printing
PR253 1099-R Reporting
PR260 Payment Detail Listing
PR261 Payment Detail Listing By Report Entity
PR262 Taxable Wage CSV
PR27.1 Year-End Parameters
PR27.2 Tax Authority Year-End Parameters
PR270 Employee Wage Report
PR271 US Affordable Care Act
PR274 Statistics Canada
PR276 Employee Deduction Report
PR277 Garnishment History Report
PR279 Benefit Deduction Audit Report
PR28.1 Exception, Offset Time Record Rules
PR280 Deduction Audit Report
PR282 Canada Record of Employment
PR284 Seniority Audit Report
PR29.1 Pension Payment Maintenance
PR295 Distribution History Report
PR297 W-2 Forms
PR299 EFW2 File Creation
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR323 Distribution Purge
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR45.1 Error Processing
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.4 Manual Payment
PR82.1 Adjustment
SN80.2 Build Category List
SN80.3 Build Type List
SN85.1 Planned Headcount
SN85.2 Headcount Actuals
SNEM.1 Employees
SNHC.1 Retrieve Employees
TA147 Canada Vacation Audit
TA20.1 Plan
TA220 Plan Listing
TA40.1 Canada Vacation Plan Master
TM240 Employee Attendance Code Report
TM245 Employee Attendance Class Report
TM250 Attendance Code Distribution Report
TM255 Attendance Class Distribution Report
TM260 Absence Monitoring Report
TM265 Lost Time Report
TM470 Attendance History Audit Report
TR02.1 Course Prerequisite
TR113 Group Track
TR120 Group Session Registration
TR222 Employee Training Listing
UK02.1 Bonus Pay Table
UK10.1 Pay Rate Table
UK10.4 Pay Rate Table
UK102 Bonus Pay Update
UK210 Pay Rate Table Listing
ZS531 Web Pending Employee Benefit Extract