BNBEN – No description in the Lawson data dictionary

System: Benefits (BN)
Prefix: BNB
Primary key: COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, START-DATE
Fields: 45
Updated by: 6 programs
Referenced by: 28 programs

BNBEN is a Lawson Benefits table (prefix BNB); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, START-DATE (BNBSET1). It is related 1:1 to BNCOMPANY, CUCODES, EMPLOYEE, PLAN and PCODES and 1:M to DEPBEN. It is updated by BS31.1, BS531, HR11.1, PA115, ZB10.3 and ZS531 and referenced by BN305, HR28.1, HR511, LT101, LT111, PA02.1, PA100, PA102 and 20 more. The table has 45 fields, 1 index and 6 documented relations.

About BNBEN

No description in the Lawson data dictionary.

Fields (45)

Column = COBOL field name without the BNB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`BNB-COMPANY` PK COMPANY	Numeric 4	—	BS31.1, ZS531
`BNB-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.	BS31.1
`BNB-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	—	BS31.1
`BNB-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BS31.1
`BNB-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	—	BS31.1
`BNB-FC` FC	Alpha 1	—	BS31.1
`BNB-ENROLL-DATE` ENROLL_DATE	Numeric 8 (yyyymmdd)	—	—
`BNB-COVER-OPT` COVER_OPT	Numeric 2	—	BS31.1
`BNB-MULT-SALARY` MULT_SALARY	Signed 6.3	—	BS31.1
`BNB-COVER-AMT` COVER_AMT	Signed 13.4	—	BS31.1
`BNB-PAY-RATE` PAY_RATE	Signed 13.4	—	BS31.1
`BNB-PCT-AMT-FLAG` PCT_AMT_FLAG	Alpha 1	—	BS31.1
`BNB-PRE-AFT-FLAG` PRE_AFT_FLAG	Alpha 1	—	BS31.1
`BNB-SMOKER-FLAG` SMOKER_FLAG	Alpha 1	—	BS31.1
`BNB-EMP-PRE-CONT` EMP_PRE_CONT	Signed 13.4	—	BS31.1
`BNB-EMP-AFT-CONT` EMP_AFT_CONT	Signed 13.4	—	BS31.1
`BNB-STOP-DATE` STOP_DATE	Numeric 8 (yyyymmdd)	—	BS31.1
`BNB-PEND-EVIDENCE` PEND_EVIDENCE	Alpha 1	—	—
`BNB-YTD-CONT` YTD_CONT	Signed 13.4	—	—
`BNB-RCD-TYPE` RCD_TYPE	Numeric 2	—	BS31.1
`BNB-PLAN-GROUP` PLAN_GROUP	Alpha 20	—	BS31.1
`BNB-COP-COV-DESC` COP_COV_DESC	Alpha 30	—	BS31.1
`BNB-DEP-COVER-AMT` DEP_COVER_AMT	Signed 11.2	—	BS31.1
`BNB-COV-PCT` COV_PCT	Signed 5.2	—	BS31.1
`BNB-FLEX-COST` FLEX_COST	Signed 9.2	—	BS31.1
`BNB-EMP-COST` EMP_COST	Signed 9.2	—	BS31.1
`BNB-COMP-COST` COMP_COST	Signed 9.2	—	BS31.1
`BNB-UPDATE-DATE` UPDATE_DATE	Numeric 8 (yyyymmdd)	This field contains the date the record was updated.	BS31.1
`BNB-ALPHADATA1` ALPHADATA1	Alpha 1	—	—
`BNB-NUMERIC1` NUMERIC1	Signed 15.4	—	—
`BNB-DATE1` DATE1	Numeric 8 (yyyymmdd)	—	—
`BNB-PLAN-DESC` PLAN_DESC	Alpha 30	—	BS31.1
`BNB-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	BS31.1
`BNB-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	BS31.1
`BNB-CREATION-DATE` CREATION_DATE	Numeric 8 (yyyymmdd)	This is the date that this line was added to the requisition.	BS31.1
`BNB-UPD-DATE` UPD_DATE	Numeric 8 (yyyymmdd)	—	BS31.1
`BNB-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BS31.1
`BNB-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BS31.1
`BNB-CREATE-TRANS` CREATE_TRANS	Alpha 1	— `Y` Yes `N` No	BS31.1
`BNB-TRAN-REASON` TRAN_REASON	Alpha 10	—	BS31.1
`BNB-MEMBER-ID` MEMBER_ID	Numeric 1	—	BS31.1
`BNB-BN-TYPE` BN_TYPE	Alpha 1	Load pending employee actions by specific Benefit Types of 1) New Hire, 2) Open Enrollment, 3) Life Event. `1` Annual `2` Life Event `3` New Hire	BS31.1
`BNB-HOLD-FLAG` HOLD_FLAG	Alpha 1	— `N` No `Y` Yes	BS31.1
`BNB-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BS31.1
`BNB-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BS31.1

Indexes (1)

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
`BNBSET1`	`COMPANY`, `EMPLOYEE`, `PLAN-TYPE`, `PLAN-CODE`, `START-DATE`	Primary		BN305, BS31.1, BS531, ZB10.3, ZS531, HR11.1, HR11.2, HR11.4 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	BNCOMPANY	Required		`BNB-COMPANY` → `BNC-COMPANY`
Currency	CUCODES	Required		`BNB-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Employee	EMPLOYEE	Required		`BNB-COMPANY` → `EMP-COMPANY`, `BNB-EMPLOYEE` → `EMP-EMPLOYEE`
Plan	PLAN	Required		`BNB-COMPANY` → `PLN-COMPANY`, `BNB-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BNB-PLAN-CODE` → `PLN-PLAN-CODE`
Reason Code	PCODES	Required	When BNB-TRAN-REASON != Spaces	`"BT"` → `PCO-TYPE`, `BNB-TRAN-REASON` → `PCO-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Depben	DEPBEN	Delete Restricted		`BNB-COMPANY` → `DEP-COMPANY`, `BNB-EMPLOYEE` → `DEP-EMPLOYEE`, `BNB-PLAN-TYPE` → `DEP-PLAN-TYPE`, `BNB-PLAN-CODE` → `DEP-PLAN-CODE`, `BNB-START-DATE` → `DEP-EMP-START`, → `DEP-DEPENDENT`, → `DEP-START-DATE`

Programs

Updated by (6)

BS31.1 Web Pending Employee Benefits
BS531 Web Pending Employee Benefit Extract
HR11.1 Employee
PA115 Employee Purge
ZB10.3 Delete Web Pending Benefit Elections
ZS531 Web Pending Employee Benefit Extract

Referenced by (28)

BN305 Highly Compensated Employees
HR28.1 Employee Ethnicity
HR511 Employee Conversion
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
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
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
ZH510 Update PCP from ZPENDPCP