BONDBENIF – Savings Bond Beneficiary
- System
- Benefits (BN)
- Prefix
BON- Primary key
COMPANY,EMPLOYEE,PLAN-CODE,START-DATE,BOND-NBR- Fields
- 9
- Updated by
- 2 programs
- Referenced by
- 3 programs
BONDBENIF is the Savings Bond Beneficiary table in Lawson Benefits (prefix BON). It is indexed by COMPANY, EMPLOYEE, PLAN-CODE, START-DATE, BOND-NBR (BONSET1). It is related 1:1 to SBBEN, BENEFIT, BNCOMPANY, PRSYSTEM, EMPLOYEE, PAEMPLOYEE and PLAN. It is updated by BN140 and BN430 and referenced by BN48.1, BN48.2 and BN60.1. The table has 9 fields, 1 index and 9 documented relations.
About BONDBENIF
The Savings Bond Beneficiary file contains information about bonds assigned to owners, co-owners and beneficiaries. BN140 (Savings Bond Update) is the primary program that updates this file.
Fields (9)
Column = COBOL field name without the BON- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
BON-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. The number correlates all information about the company. | BN140 |
BON-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains the employee's number. The number correlates all information about the employee. | BN140 |
BON-PLAN-CODE PKPLAN_CODE | Alpha 4 | Contains the code that represents a benefit plan. | BN140 |
BON-START-DATE PKSTART_DATE | Numeric 8 (yyyymmdd) | Contains the benefit start date. | BN140 |
BON-BOND-NBR PKBOND_NBR | Numeric 4 | Contains the bond number. | BN140 |
BON-OWNEROWNER | Alpha 3 | Contains the number which indicates the bond's owner. | BN140 |
BON-CO-OWNERCO_OWNER | Alpha 3 | Contains the number which indicates the bond's co-owner. | BN140 |
BON-BNFC-NBRBNFC_NBR | Alpha 3 Occurs 12 Times ×12 | Contains the number which indicates the bond's beneficiary. | BN140 |
BON-DATE-PURCHDATE_PURCH | Numeric 8 (yyyymmdd) | Contains the date the bond was purchased. | BN140 |
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 |
|---|---|---|---|---|
BONSET1 | COMPANY, EMPLOYEE, PLAN-CODE, START-DATE, BOND-NBR | Primary | BN430, BN48.1, BN48.2, BN60.1 |
Relations
One to one (9) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Beneficiary | SBBEN | Required | When BON-BNFC-NBR != Spaces | BON-COMPANY → SBB-COMPANY, BON-EMPLOYEE → SBB-EMPLOYEE, BON-BNFC-NBR → SBB-BNFC-NBR |
| Benefit | BENEFIT | Required | BON-COMPANY → BEN-COMPANY, "SB" → BEN-PLAN-TYPE, BON-EMPLOYEE → BEN-EMPLOYEE, BON-START-DATE → BEN-START-DATE, BON-PLAN-CODE → BEN-PLAN-CODE | |
| Co Owner | SBBEN | Required | When BON-CO-OWNER != Spaces | BON-COMPANY → SBB-COMPANY, BON-EMPLOYEE → SBB-EMPLOYEE, BON-CO-OWNER → SBB-BNFC-NBR |
| Company | BNCOMPANY | Required | BON-COMPANY → BNC-COMPANY | |
| Company Name | PRSYSTEM | Required | BON-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Employee | EMPLOYEE | Required | BON-COMPANY → EMP-COMPANY, BON-EMPLOYEE → EMP-EMPLOYEE | |
| Owner | SBBEN | Required | When BON-OWNER != Spaces | BON-COMPANY → SBB-COMPANY, BON-EMPLOYEE → SBB-EMPLOYEE, BON-OWNER → SBB-BNFC-NBR |
| Pa Employee | PAEMPLOYEE | Required | BON-COMPANY → PEM-COMPANY, BON-EMPLOYEE → PEM-EMPLOYEE | |
| Plan | PLAN | Required | BON-COMPANY → PLN-COMPANY, "SB" → PLN-PLAN-TYPE, BON-PLAN-CODE → PLN-PLAN-CODE |