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

Field / columnTypeDescription & valuesUpdated by
#PGE-COMPANY PK
COMPANY		Numeric 4Contains 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 10Contains 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 9Contains 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 SET3
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 SET3
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 SET3
MIDDLE_INIT		Alpha 1Contains 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 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
PGESET1
  1. COMPANY
  2. GROUP-NAME
  3. EMPLOYEE
PrimaryAC190, AC197, BN100, BN101, BN102, BN103, BN105, BN106 +22 more (list truncated in source)
PGESET2
  1. COMPANY
  2. EMPLOYEE
  3. GROUP-NAME
BN100, BN101, BN102, BN103, BN105, BN305, BN31.1, BN31.2 +22 more (list truncated in source)
PGESET3
  1. COMPANY
  2. GROUP-NAME
  3. LAST-NAME
  4. FIRST-NAME
  5. MIDDLE-INIT
  6. EMPLOYEE
KeyChangeHR255, PR33.3

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PGE-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PGE-COMPANY→EMP-COMPANY
PGE-EMPLOYEE→EMP-EMPLOYEE
Pa EmployeePAEMPLOYEERequired
PGE-COMPANY→PEM-COMPANY
PGE-EMPLOYEE→PEM-EMPLOYEE
Pers GroupPERSGROUPRequired
PGE-COMPANY→PRG-COMPANY
PGE-GROUP-NAME→PRG-GROUP-NAME

One to many (1) — child tables

RelationTableRulesConditionField map
Active PepPAEMPPOS
PGE-COMPANY→PEP-COMPANY
PGE-EMPLOYEE→PEP-EMPLOYEE
—→PEP-POS-LEVEL
—→PEP-EFFECT-DATE

Programs

Updated by (67)

Referenced by (232)