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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PGS-COMPANY PK
COMPANY		Numeric 4Contains the company number.HR156, HR55.2, HR55.3, ZH156
#PGS-GROUP-NAME PK
GROUP_NAME		Alpha 10Contains the user-defined employee group name.HR156, HR55.1, HR55.2, HR55.3, ZH156
#PGS-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains employees to be included in the group regardless of criteria.HR156, HR55.2, ZH156
#PGS-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the sequence number that keeps each record unique.HR156, HR55.2, HR55.3, ZH156
#PGS-FLD-NBR SET4 SET5 SET6 SET7
FLD_NBR		Numeric 4Contains the HR data dictionary field number.HR156, HR55.3, ZH156
#PGS-INC-EXC-FLAG
INC_EXC_FLAG		Alpha 1Indicates 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 SET5
BEGIN_VALUE		Alpha 30Contains 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 30Contains 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 SET7
ITEM_GRP		Alpha 2Contains 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 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
PGSSET1
  1. COMPANY
  2. GROUP-NAME
  3. EMPLOYEE
  4. SEQ-NBR
PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
PGSSET4
  1. COMPANY
  2. FLD-NBR
  3. GROUP-NAME
  4. SEQ-NBR
KeyChangeBN100, BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
PGSSET5
  1. COMPANY
  2. FLD-NBR
  3. BEGIN-VALUE
  4. GROUP-NAME
  5. SEQ-NBR
KeyChangeBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
PGSSET6
  1. COMPANY
  2. GROUP-NAME
  3. FLD-NBR
  4. SEQ-NBR
KeyChangeHR55.1, HR55.2, HR55.3
PGSSET7
  1. COMPANY
  2. GROUP-NAME
  3. ITEM-GRP
  4. FLD-NBR
  5. SEQ-NBR
KeyChangeBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PGS-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Emp GroupPERSGROUPRequired
PGS-COMPANY→PRG-COMPANY
PGS-GROUP-NAME→PRG-GROUP-NAME
EmployeeEMPLOYEERequiredWhen PGS-EMPLOYEE != Zeroes
PGS-COMPANY→EMP-COMPANY
PGS-EMPLOYEE→EMP-EMPLOYEE
Field NbrPADICTRequiredWhen PGS-FLD-NBR != Zeroes
PGS-FLD-NBR→PAD-FLD-NBR
Fld NbrPADICTRequiredWhen PGS-FLD-NBR != Zeroes
PGS-FLD-NBR→PAD-FLD-NBR

Programs

Updated by (68)

Referenced by (7)