PGSELECT – Emp Group Selection Criteria

System: Human Resources (HR)
Prefix: PGS
Primary key: COMPANY, GROUP-NAME, EMPLOYEE, SEQ-NBR
Fields: 18
Updated by: 68 programs
Referenced by: 7 programs

PGSELECT is the Emp Group Selection Criteria table in Lawson Human Resources (prefix PGS). It is indexed by COMPANY, GROUP-NAME, EMPLOYEE, SEQ-NBR (PGSSET1); alternate indexes: PGSSET4, PGSSET5, PGSSET6 and PGSSET7. It is related 1:1 to PRSYSTEM, PERSGROUP, EMPLOYEE and PADICT. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 60 more and referenced by BN100, HR06.1, HR506, HR710, PA149, TM250 and TM255. The table has 18 fields, 5 indexes and 5 documented relations.

About PGSELECT

Contains the selection criteria for defining an employee group. Each selection criteria has its own record in this file.

Fields (18)

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

Field / column	Type	Description & values	Updated by
`PGS-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	HR156, HR55.2, HR55.3, ZH156
`PGS-GROUP-NAME` PK GROUP_NAME	Alpha 10	Contains the user-defined employee group name.	HR156, HR55.1, HR55.2, HR55.3, ZH156
`PGS-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains employees to be included in the group regardless of criteria.	HR156, HR55.2, ZH156
`PGS-SEQ-NBR` PK SEQ_NBR	Numeric 4	Contains the sequence number that keeps each record unique.	HR156, HR55.2, HR55.3, ZH156
`PGS-FLD-NBR` FLD_NBR	Numeric 4	Contains the HR data dictionary field number.	HR156, HR55.3, ZH156
`PGS-INC-EXC-FLAG` INC_EXC_FLAG	Alpha 1	Indicates whether to include or exclude the range of values contained in this record. `E` Exclude `I` Include	HR156, HR55.2, HR55.3, ZH156
`PGS-BEGIN-VALUE` BEGIN_VALUE	Alpha 30	Contains the value (or beginning value if a range is used) for the data item in this record.	HR156, HR55.3, ZH156
`PGS-ENDING-VALUE` ENDING_VALUE	Alpha 30	Contains the ending value if a range of values is defined. If a range is not defined, this field is blank.	HR156, HR55.3, ZH156
`PGS-ITEM-GRP` ITEM_GRP	Alpha 2	Contains an item group identifier.	HR156, HR55.3, ZH156
`PGS-INC-EXC-VAL` INC_EXC_VAL	Derived	—	—
`PGS-SHORT-BEG-VAL` SHORT_BEG_VAL	Derived	—	—
`PGS-SHORT-END-VAL` SHORT_END_VAL	Derived	—	—
`PGS-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	HR55.1, HR55.2, HR55.3
`PGS-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	HR55.1, HR55.2, HR55.3
`PGS-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	HR55.1, HR55.2, HR55.3
`PGS-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	HR55.1, HR55.2, HR55.3
`PGS-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	HR55.1, HR55.2, HR55.3
`PGS-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	HR55.1, HR55.2, HR55.3

Indexes (5)

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

Index	Keys	Flags	Used in
`PGSSET1`	`COMPANY`, `GROUP-NAME`, `EMPLOYEE`, `SEQ-NBR`	Primary	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
`PGSSET4`	`COMPANY`, `FLD-NBR`, `GROUP-NAME`, `SEQ-NBR`	KeyChange	BN100, BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
`PGSSET5`	`COMPANY`, `FLD-NBR`, `BEGIN-VALUE`, `GROUP-NAME`, `SEQ-NBR`	KeyChange	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
`PGSSET6`	`COMPANY`, `GROUP-NAME`, `FLD-NBR`, `SEQ-NBR`	KeyChange	HR55.1, HR55.2, HR55.3
`PGSSET7`	`COMPANY`, `GROUP-NAME`, `ITEM-GRP`, `FLD-NBR`, `SEQ-NBR`	KeyChange	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`PGS-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Emp Group	PERSGROUP	Required		`PGS-COMPANY` → `PRG-COMPANY`, `PGS-GROUP-NAME` → `PRG-GROUP-NAME`
Employee	EMPLOYEE	Required	When PGS-EMPLOYEE != Zeroes	`PGS-COMPANY` → `EMP-COMPANY`, `PGS-EMPLOYEE` → `EMP-EMPLOYEE`
Field Nbr	PADICT	Required	When PGS-FLD-NBR != Zeroes	`PGS-FLD-NBR` → `PAD-FLD-NBR`
Fld Nbr	PADICT	Required	When PGS-FLD-NBR != Zeroes	`PGS-FLD-NBR` → `PAD-FLD-NBR`

Programs

Updated by (68)

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
HR255 Employee Group Listing
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 (7)

BN100 Employee Change Benefit Update
HR06.1 Job Code
HR506 Job Code Conversion
HR710 EEO-1 Job Category Update
PA149 Update Scheduled Tests
TM250 Attendance Code Distribution Report
TM255 Attendance Class Distribution Report