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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#BIV-COMPANY PKCOMPANY | Numeric 4 | The company number represents an established company and is entered on all function codes. | BN15.1 |
#BIV-PLAN-CODE PKPLAN_CODE | Alpha 4 | Contains the user-defined code used to represent a specific benefit plan. | BN15.1 |
#BIV-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | BN15.1 |
#BIV-DESCDESC | Alpha 30 (Lower Case) | This field contains the description of the of the investment account. | BN15.1 |
#BIV-ACTIVE-FLAGACTIVE_FLAG | Alpha 1 | The active flag identifies the status of the account.
| BN15.1 |
#BIV-DEFAULTDEFAULT | Alpha 1 | —
| BN15.1 |
Indexes (2)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
BIVSET1 |
| Primary | BN00.1, BN15.1, BN215, BN245, BN330, BN36.1, HR170, HR70.1 | |
BIVSET2 |
| 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
Programs
Updated by (2)
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