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.

Field / column	Type	Description & values	Updated by
`BNH-COMPANY` PK COMPANY	Numeric 4	Contains 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 9	Contains 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 4	Contains 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 12	Contains 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` 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 1	Enables 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` CHANGE_TYPE	Alpha 1	Contains 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 20	Contains 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 30	Contains 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` 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`BNHSET1`	`COMPANY`, `EMPLOYEE`, `EFFECT-DATE`, `SEQ-NBR`	Primary		BN100, BN305, BN35.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1 +22 more (list truncated in source)
`BNHSET2`	`COMPANY`, `EMPLOYEE`, `EFFECT-DATE`, `CHANGE-TYPE`, `SEQ-NBR`	Subset	Where HOLD-FLAG != "Y"	BN100
`BNHSET3`	`COMPANY`, `CREATE-DATE`, `DATE-STAMP`, `EMPLOYEE`, `EFFECT-DATE`, `SEQ-NBR`	KeyChange		—

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Bncompany	BNCOMPANY	Required	`BNH-COMPANY` → `BNC-COMPANY (BNCSET1)`
Employee	EMPLOYEE	Required	`BNH-COMPANY` → `EMP-COMPANY`, `BNH-EMPLOYEE` → `EMP-EMPLOYEE`
Persacthst	PERSACTHST	Required	`BNH-ACT-OBJ-ID` → `PAH-OBJ-ID`
Prsystem	PRSYSTEM	Required	`BNH-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Benefit	BENEFIT			`BNH-COMPANY` → `BEN-COMPANY`, `BNH-EMPLOYEE` → `BEN-EMPLOYEE`, → `BEN-PLAN-TYPE`, → `BEN-PLAN-CODE`, → `BEN-START-DATE`
Empflexdol	EMPFLEXDOL			`BNH-COMPANY` → `EFD-COMPANY`, `BNH-EMPLOYEE` → `EFD-EMPLOYEE`, → `EFD-START-DATE`

Programs

Updated by (70)

BN100 Employee Change Benefit Update
BN305 Highly Compensated Employees
BN35.1 Benefit Change Audit
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
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR515 User Field Conversion
HR54.1 Employee History Correction
HR55.2 Employee Groups By Employees
HRS1.1 Select Control
HRSC.1 Select Control
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LT101 HRM Receiver Update
LT11.5 HRM User Field Interface
LT111 HRM Receiver Update
LT13.5 HRM User Field Interface History
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA113 Retroactive History 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