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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#BON-COMPANY PK
COMPANY		Numeric 4Contains the company number. The number correlates all information about the company.BN140
#BON-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee's number. The number correlates all information about the employee.BN140
#BON-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains the code that represents a benefit plan.BN140
#BON-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the benefit start date.BN140
#BON-BOND-NBR PK
BOND_NBR		Numeric 4Contains the bond number.BN140
#BON-OWNER
OWNER		Alpha 3Contains the number which indicates the bond's owner.BN140
#BON-CO-OWNER
CO_OWNER		Alpha 3Contains the number which indicates the bond's co-owner.BN140
#BON-BNFC-NBR
BNFC_NBR		Alpha 3 Occurs 12 Times ×12Contains the number which indicates the bond's beneficiary.BN140
#BON-DATE-PURCH
DATE_PURCH		Numeric 8 (yyyymmdd)Contains the date the bond was purchased.BN140

Indexes (1)

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.

IndexKeysFlagsConditionUsed in
BONSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-CODE
  4. START-DATE
  5. BOND-NBR
PrimaryBN430, BN48.1, BN48.2, BN60.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
SBBENBENEFITBNCOMPANYPRSYSTEMEMPLOYEEPAEMPLOYEEPLANBONDBENIF

One to one (9) — lookups and parents

RelationTableRulesConditionField map
BeneficiarySBBENRequiredWhen BON-BNFC-NBR != Spaces
BON-COMPANY→SBB-COMPANY
BON-EMPLOYEE→SBB-EMPLOYEE
BON-BNFC-NBR→SBB-BNFC-NBR
BenefitBENEFITRequired
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 OwnerSBBENRequiredWhen BON-CO-OWNER != Spaces
BON-COMPANY→SBB-COMPANY
BON-EMPLOYEE→SBB-EMPLOYEE
BON-CO-OWNER→SBB-BNFC-NBR
CompanyBNCOMPANYRequired
BON-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
BON-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
BON-COMPANY→EMP-COMPANY
BON-EMPLOYEE→EMP-EMPLOYEE
OwnerSBBENRequiredWhen BON-OWNER != Spaces
BON-COMPANY→SBB-COMPANY
BON-EMPLOYEE→SBB-EMPLOYEE
BON-OWNER→SBB-BNFC-NBR
Pa EmployeePAEMPLOYEERequired
BON-COMPANY→PEM-COMPANY
BON-EMPLOYEE→PEM-EMPLOYEE
PlanPLANRequired
BON-COMPANY→PLN-COMPANY
"SB"→PLN-PLAN-TYPE
BON-PLAN-CODE→PLN-PLAN-CODE

Programs

Updated by (2)

Referenced by (3)