PGEMPLOYEE – Employee Group Employees

System: Human Resources (HR)
Prefix: PGE
Primary key: COMPANY, GROUP-NAME, EMPLOYEE
Fields: 7
Updated by: 67 programs
Referenced by: 232 programs

PGEMPLOYEE is the Employee Group Employees table in Lawson Human Resources (prefix PGE). It is indexed by COMPANY, GROUP-NAME, EMPLOYEE (PGESET1); alternate indexes: PGESET2 and PGESET3. It is related 1:1 to PRSYSTEM, EMPLOYEE, PAEMPLOYEE and PERSGROUP and 1:M to PAEMPPOS. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 59 more and referenced by AC190, AC197, BN100, BN101, BN102, BN103, BN105, BN106 and 224 more. The table has 7 fields, 3 indexes and 5 documented relations.

About PGEMPLOYEE

Contains the user-defined employee group name and the employee's who meet the selection criteria defined for the group.

Fields (7)

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

Field / column	Type	Description & values	Updated by
`PGE-COMPANY` PK COMPANY	Numeric 4	Contains the company number for which the employee group is defined.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`PGE-GROUP-NAME` PK GROUP_NAME	Alpha 10	Contains the name of the employee group.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`PGE-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number of employees who meet the selection criteria for the group.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`PGE-LAST-NAME` LAST_NAME	Alpha 30 (Lower Case)	Contains the employee's last name.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`PGE-FIRST-NAME` FIRST_NAME	Alpha 15 (Lower Case)	Contains the employee's first name.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`PGE-MIDDLE-INIT` MIDDLE_INIT	Alpha 1	Contains the employee's middle initial.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`PGE-FULL-NAME` FULL_NAME	Derived	—	—

Indexes (3)

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

Index	Keys	Flags	Used in
`PGESET1`	`COMPANY`, `GROUP-NAME`, `EMPLOYEE`	Primary	AC190, AC197, BN100, BN101, BN102, BN103, BN105, BN106 +22 more (list truncated in source)
`PGESET2`	`COMPANY`, `EMPLOYEE`, `GROUP-NAME`		BN100, BN101, BN102, BN103, BN105, BN305, BN31.1, BN31.2 +22 more (list truncated in source)
`PGESET3`	`COMPANY`, `GROUP-NAME`, `LAST-NAME`, `FIRST-NAME`, `MIDDLE-INIT`, `EMPLOYEE`	KeyChange	HR255, PR33.3

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Company	PRSYSTEM	Required	`PGE-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	`PGE-COMPANY` → `EMP-COMPANY`, `PGE-EMPLOYEE` → `EMP-EMPLOYEE`
Pa Employee	PAEMPLOYEE	Required	`PGE-COMPANY` → `PEM-COMPANY`, `PGE-EMPLOYEE` → `PEM-EMPLOYEE`
Pers Group	PERSGROUP	Required	`PGE-COMPANY` → `PRG-COMPANY`, `PGE-GROUP-NAME` → `PRG-GROUP-NAME`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Active Pep	PAEMPPOS			`PGE-COMPANY` → `PEP-COMPANY`, `PGE-EMPLOYEE` → `PEP-EMPLOYEE`, → `PEP-POS-LEVEL`, → `PEP-EFFECT-DATE`

Programs

Updated by (67)

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
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
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.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 (232)

AC190 Activity Posting
AC197 Burden Recalculation Based on Total Cost
BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN106 Benefit Transaction Export
BN145 Flex Dollars Calculation
BN150 Life Insurance Reportable Income
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
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN320 Premium Report
BN321 Dependent Benefit Listing
BN325 Benefit Exception Report
BN33.1 Employee Stock Option Grant Mass Entry
BN33.2 Employee Stock Option Grant
BN33.3 Employee Stock Option Vesting Detail
BN331 HIPAA Certification Report
BN340 ADP and ACP Tests
BN345 Percentage Test
BN350 Coverage Test - Classification
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN533 Employee Stock Option Grant Conversion
BN65.1 Election Simulation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS09.1 Employee Annual Enrollment Rules
BS10.1 Web Enrollment Current Benefit Inquiry
BS11.1 Web Enrollment Employee Flex Dollar Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
BS531 Web Pending Employee Benefit Extract
HC01.2 Employee Dimension Definition
HCDL.1 Olap Data Load
HCEM.1 Olap Dimension Retrieval Format
HLTM.1 Lawson Talent Management Feed
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
HR70.1 Human Resource Writer Inquiry
HS10.1 Direct Report Inquiry
HS10.2 Direct Report Inquiry
HS18.2 Payroll Lock Out Look Up
HS20.1 Time Form Inquiry
HS208 Goal Management Report
HS21.1 Time Form Inquiry
HS22.1 Pending Time Summary
HS34.1 Prpendtime Edit Program
HS35.1 Pending Time Records
HS36.1 Pending Time Records
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
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
LP151 FMLA Rolling 12 Month Update
LP180 Mass Absence Plan Transfer
LP188 Length of Service Hours Update
LP199 Close Unprocessed Service Records
LP231 Employee Plan Master Listing
LP251 Employee Leave of Absence Report
LP260 Employee Service and Event Report
LP262 Employee Event Audit Report
LP264 Employee Transaction History Report
LP331 Employee Absence Plan Purge
LP353 Employee Service History Purge
LP80.1 Employee Absence Plan Transfer
LT213 Interface Audit Export
PA103 Mass Position Changes
PA105 Employee Audit Report
PA113 Retroactive History Update
PA125 Employee History Purge
PA130 Employee Comments Purge
PA149 Update Scheduled Tests
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
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
PA49.1 Employee Tests
PA49.3 Applicant Tests
PA495 IPEDS Report
PA496 Official Languages Report
PA534 e-Recruiting Employee Export
PA549 Employee and Applicant Test Conversion
PA66.2 Action Inquiry
PR11.3 Employee HIRE Act Tax Reporting Info
PR128 Offset Time Record Creation
PR129 Roth Plan Start Dates
PR131 Retroactive Pay Calculation
PR134 Automatic Time Records
PR136 Missing Time Records
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
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
PR248 Canada Annual Reports
PR249 PIER Audit Report
PR250 1099-R Form Reporting
PR251 1099-R File Creation
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
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
PR280 Deduction Audit Report
PR282 Canada Record of Employment
PR284 Seniority Audit Report
PR292 Quarterly Unemployment Ins
PR293 Enumeration Verification
PR295 Distribution History Report
PR297 W-2 Forms
PR299 EFW2 File Creation
PR300 History Purge
PR323 Distribution Purge
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR582 Mass Adjustment Load
SN80.2 Build Category List
SN80.3 Build Type List
SNEM.1 Employees
SNHC.1 Retrieve Employees
TA147 Canada Vacation Audit
TA148 Canada Vacation Rollover
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
TR113 Group Track
TR120 Group Session Registration
TR121 Job Code Session Registration
TR20.1 Session Registration
TR20.2 Mass Registration
TR20.3 Session Registration Override
TR20.4 Employee Session Registration
TR222 Employee Training Listing
UK102 Bonus Pay Update
UK110 Pay Rate Table Update
UK210 Pay Rate Table Listing
ZB01.1 Years Of Service Calculation
ZB10.1 Coverage Options Calculator
ZB10.2 Get Benefit Eligibility Dates
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add
ZH230 PPH Big Bad Edit
ZH500 Employee Data Extract
ZS531 Web Pending Employee Benefit Extract