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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PRG-COMPANY PKCOMPANY | Numeric 4 | Contains the number that represents an established company and is entered on all functions. | HR55.1, HR55.2 |
#PRG-GROUP-NAME PKGROUP_NAME | Alpha 10 | Contains the employee group name. | HR55.1, HR55.2 |
#PRG-DESCRIPTIONDESCRIPTION | 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-NBRFLD_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-SEQLAST_ITEM_SEQ | Numeric 4 | Contains the sequence number used to store the last employee group selection record. | HR55.2, HR55.3 |
#PRG-UPDATE-FLAGUPDATE_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 SET2 SET3GRP_ORDER | Numeric 1 | Indicates whether the group is used as a criteria for another group. 0 1 | HR55.3 |
#PRG-BENEFITSBENEFITS | Alpha 1 | Indicates whether the employee group can be used by benefits for plan definition.
| HR55.1, HR55.2, HR55.3 |
#PRG-ABSENCE-MGMTABSENCE_MGMT | Alpha 1 | —
| HR55.1, HR55.2, HR55.3 |
#PRG-PEP-LEVEL-ONEPEP_LEVEL_ONE | Alpha 1 | This field was added in the 8.1.0 release, but is not currently being used for any processing
| — |
#PRG-PEP-LEVEL-TWOPEP_LEVEL_TWO | Alpha 1 | This field was added in the 8.1.0 release, but is not currently being used in any processing.
| — |
#PRG-ACTIVE-FLAGACTIVE_FLAG | Numeric 1 | —
| HR55.1 |
Indexes (3)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PRGSET1 |
| Primary | AC62.1, BN06.1, BN08.1, BN100, BN101, BN102, BN103, BN145 +22 more (list truncated in source) | |
PRGSET2 |
| KeyChange, Subset | Where UPDATE-FLAG = "Y" | HR155 |
PRGSET3 |
| KeyChange | HR155, HR156, ZH156 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
| |||||||
| Field Nbr | PADICT | Required | When PRG-FLD-NBR != Zeroes |
|
One to many (7) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Employee Nbr | PGSELECT |
| ||||||||||||||||||||
| Employees | PGEMPLOYEE | Delete Cascades |
| |||||||||||||||||||
| Pgselect | PGSELECT | Delete Cascades |
| |||||||||||||||||||
| Progpay | PROGPAY |
| ||||||||||||||||||||
| Progpay Bonus | PROGPAY |
| ||||||||||||||||||||
| Selection | PGSELECT | Delete Cascades |
| |||||||||||||||||||
| Standtime | STANDTIME | Required |
|
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