BNCHANGE – Benefit Changes

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

BNCHANGE is the Benefit Changes table in Lawson Benefits (prefix BNH). It is indexed by COMPANY, EMPLOYEE, EFFECT-DATE, SEQ-NBR (BNHSET1); alternate indexes: BNHSET2 and BNHSET3. 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 15 fields, 3 indexes and 6 documented relations.

About BNCHANGE

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the BNH- 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
#BNH-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)
#BNH-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)
#BNH-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the personnel action effective date.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNH-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)
#BNH-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)
#BNH-DATE-STAMP SET3
DATE_STAMP		Numeric 8 (yyyymmdd)Contains the system date the change is entered.BN305, BN35.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +52 more (list truncated in source)
#BNH-HOLD-FLAG
HOLD_FLAG		Alpha 1Enables a benefit change record to be put on hold so BN100 (Employee Change Benefit Update) will not process the change.
  • 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)
#BNH-CHANGE-TYPE SET2
CHANGE_TYPE		Alpha 1Contains the type of change.
  • 1 Postal Code
  • 2 Salary
  • 3 Pay Frequency
  • 4 Birthdate
  • 5 Service Date
  • 6 Smoker Flag Change
  • 7 New Hire
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNH-OLD-VALUE
OLD_VALUE		Alpha 20Contains the old value.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNH-NEW-VALUE
NEW_VALUE		Alpha 30Contains the new value.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#BNH-CREATE-DATE SET3
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)
#BNH-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)
#BNH-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)
#BNH-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BN305, BN35.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +52 more (list truncated in source)
#BNH-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN305, BN35.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.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
BNHSET1
  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)
BNHSET2
  1. COMPANY
  2. EMPLOYEE
  3. EFFECT-DATE
  4. CHANGE-TYPE
  5. SEQ-NBR
SubsetWhere HOLD-FLAG != "Y"BN100
BNHSET3
  1. COMPANY
  2. CREATE-DATE ↓
  3. DATE-STAMP ↓
  4. EMPLOYEE
  5. EFFECT-DATE
  6. SEQ-NBR
KeyChange—

Relations

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

One to one (4) — lookups and parents

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

One to many (2) — child tables

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

Programs

Updated by (70)