BNINVEST – Investment Distribution

System: Benefits (BN)
Prefix: BIV
Primary key: COMPANY, PLAN-CODE, SEQ-NBR
Fields: 6
Updated by: 2 programs
Referenced by: 24 programs

BNINVEST is the Investment Distribution table in Lawson Benefits (prefix BIV). It is indexed by COMPANY, PLAN-CODE, SEQ-NBR (BIVSET1); alternate indexes: BIVSET2. It is related 1:1 to BNCOMPANY, PRSYSTEM and PLAN. It is updated by BN00.1 and BN15.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN215, BN245, BN31.1 and 16 more. The table has 6 fields, 2 indexes and 3 documented relations.

About BNINVEST

The Investment Distribution file contains the investment choices for defined contribution plans. Each record represents one investment choice.

Fields (6)

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

Field / column	Type	Description & values	Updated by
`BIV-COMPANY` PK COMPANY	Numeric 4	The company number represents an established company and is entered on all function codes.	BN15.1
`BIV-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code used to represent a specific benefit plan.	BN15.1
`BIV-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	BN15.1
`BIV-DESC` DESC	Alpha 30 (Lower Case)	This field contains the description of the of the investment account.	BN15.1
`BIV-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	The active flag identifies the status of the account. `A` Active `I` Inactive	BN15.1
`BIV-DEFAULT` DEFAULT	Alpha 1	— `Y` Yes `N` No	BN15.1

Indexes (2)

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
`BIVSET1`	`COMPANY`, `PLAN-CODE`, `SEQ-NBR`	Primary		BN00.1, BN15.1, BN215, BN245, BN330, BN36.1, HR170, HR70.1
`BIVSET2`	`COMPANY`, `PLAN-CODE`, `SEQ-NBR`	KeyChange, Subset	Where (DEFAULT = "Y")	BN100, BN101, BN102, BN103, BN105, BN15.1, BN31.1, BN31.2 +11 more

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Company	BNCOMPANY	Required	`BIV-COMPANY` → `BNC-COMPANY`
Company Name	PRSYSTEM	Required	`BIV-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Plan	PLAN	Required	`BIV-COMPANY` → `PLN-COMPANY`, `"DC"` → `PLN-PLAN-TYPE`, `BIV-PLAN-CODE` → `PLN-PLAN-CODE`

Programs

Updated by (2)

BN00.1 Benefits Company
BN15.1 Benefit Plan

Referenced by (24)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN215 Plan Parameter Listing
BN245 Benefit Election Form
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN330 Defined Contribution Plan Contributions
BN36.1 Investment
BN531 Batch Benefit Enrollment
BS32.1 Web Enrollment Stop Benefits Update
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
ZB10.1 Coverage Options Calculator
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add