BNGRPCHG – Benefit Group Change

System
Benefits (BN)
Prefix
BNG
Primary key
COMPANY, EMPLOYEE, EFFECT-DATE, SEQ-NBR
Fields
14
Updated by
70 programs
Referenced by
0 programs

BNGRPCHG is the Benefit Group Change table in Lawson Benefits (prefix BNG). It is indexed by COMPANY, EMPLOYEE, EFFECT-DATE, SEQ-NBR (BNGSET1); alternate indexes: BNGSET2 and BNGSET4. It is related 1:1 to BNCOMPANY, EMPLOYEE, PERSACTHST and PRSYSTEM and 1:M to BENEFIT and EMPFLEXDOL. It is updated by BN100, BN305, BN35.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1 and 62 more. The table has 14 fields, 3 indexes and 6 documented relations.

About BNGRPCHG

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the BNG- 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
#BNG-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the date the personnel action that created this record took effect.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains an automatically assigned sequence number.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-ACT-OBJ-ID
ACT_OBJ_ID		Numeric 12Contains the Object Id of the personnel action.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)Contains the system date the change was created.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-HOLD-FLAG
HOLD_FLAG		Alpha 1Enables a change record to be put on hold. BN100 (Employee Change Benefit Update) will not process records that are on hold.
  • Y Yes
  • N No
BN305, BN35.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +52 more (list truncated in source)
#BNG-ADD-DELETE SET2 SET4
ADD_DELETE		Alpha 1Indicates if an employee was added to or deleted from an employee group.
  • D Delete
  • A Add
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-GROUP-NAME SET4
GROUP_NAME		Alpha 10Contains the employee group the employee was added to or removed from.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNG-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)

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
BNGSET1
  1. COMPANY
  2. EMPLOYEE
  3. EFFECT-DATE
  4. SEQ-NBR
PrimaryBN100, BN305, BN35.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1 +22 more (list truncated in source)
BNGSET2
  1. COMPANY
  2. EMPLOYEE
  3. EFFECT-DATE
  4. ADD-DELETE ↓
  5. SEQ-NBR
SubsetWhere HOLD-FLAG != "Y"BN100
BNGSET4
  1. COMPANY
  2. EMPLOYEE
  3. EFFECT-DATE
  4. ADD-DELETE
  5. GROUP-NAME
BN100, BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.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)
BNCOMPANYEMPLOYEEPERSACTHSTPRSYSTEMBENEFITEMPFLEXDOLBNGRPCHG

One to one (4) — lookups and parents

RelationTableRulesConditionField map
BncompanyBNCOMPANYRequired
BNG-COMPANY→BNC-COMPANY
EmployeeEMPLOYEERequired
BNG-COMPANY→EMP-COMPANY
BNG-EMPLOYEE→EMP-EMPLOYEE
PersacthstPERSACTHSTRequired
BNG-ACT-OBJ-ID→PAH-OBJ-ID
PrsystemPRSYSTEMRequired
BNG-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

One to many (2) — child tables

RelationTableRulesConditionField map
BenefitBENEFIT
BNG-COMPANY→BEN-COMPANY
BNG-EMPLOYEE→BEN-EMPLOYEE
—→BEN-PLAN-TYPE
—→BEN-PLAN-CODE
—→BEN-START-DATE
EmpflexdolEMPFLEXDOL
BNG-COMPANY→EFD-COMPANY
BNG-EMPLOYEE→EFD-EMPLOYEE
—→EFD-START-DATE

Programs

Updated by (70)