SBBEN – Savings Bond Beneficiary
- System
- Benefits (BN)
- Prefix
SBB- Primary key
COMPANY,EMPLOYEE,BNFC-NBR- Fields
- 17
- Updated by
- 4 programs
- Referenced by
- 3 programs
SBBEN is the Savings Bond Beneficiary table in Lawson Benefits (prefix SBB). It is indexed by COMPANY, EMPLOYEE, BNFC-NBR (SBBSET1). It is related 1:1 to BNCOMPANY, PRSYSTEM, INSTCTRYCD, EMDEPEND and EMPLOYEE. It is updated by BN00.1, BN48.1, HR11.1 and PA115 and referenced by BN140, BN248 and BN60.1. The table has 17 fields, 1 index and 5 documented relations.
About SBBEN
The Savings Bond Beneficiary file contains the name, address and Social Security number for owners, co-owners and beneficiaries for savings bonds.
Fields (17)
Column = COBOL field name without the SBB- 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 |
|---|---|---|---|
#SBB-COMPANY PKCOMPANY | Numeric 4 | The company number represents an established company and is entered on all function codes. | BN48.1 |
#SBB-EMPLOYEE PKEMPLOYEE | Numeric 9 | Employee number is assigned to each person employed by the company. It is used to correlate all information related to the employee. | BN48.1 |
#SBB-BNFC-NBR PKBNFC_NBR | Alpha 3 | This field contains a user-defined code which indicates the person who is assigned as the owner, co-owner or beneficiary to a savings bond. | BN48.1 |
#SBB-DEP-NBRDEP_NBR | Numeric 4 | This field contains the dependent number. If the owner or beneficiary is the employee's dependent, this is the dependent number which is the EMD-SEQ-NBR in the EMDEPEND file. The dependent number has been established on HR13.1 (Dependent). This value must be valid in the EMDEPEND file. If there is a value in this field, there must also be a valid employee in SBB-EMPLOYEE. | BN48.1 |
#SBB-LAST-NAMELAST_NAME | Alpha 30 (Lower Case) | This is the owner or beneficiary's last name. | BN48.1 |
#SBB-FIRST-NAMEFIRST_NAME | Alpha 15 (Lower Case) | This is the owner or beneficiary's first name. | BN48.1 |
#SBB-MIDDLE-INITMIDDLE_INIT | Alpha 1 | This is the owner or beneficiary's middle initial. | BN48.1 |
#SBB-ADDR1ADDR1 | Alpha 30 (Lower Case) | This is the first line of address information. | BN48.1 |
#SBB-ADDR2ADDR2 | Alpha 30 (Lower Case) | This is the second line of address information. | BN48.1 |
#SBB-ADDR3ADDR3 | Alpha 30 (Lower Case) | Contains the third line of address information. | BN48.1 |
#SBB-ADDR4ADDR4 | Alpha 30 (Lower Case) | Contains the fourth line of address information. | BN48.1 |
#SBB-CITYCITY | Alpha 58 (Lower Case) | This is the city name of the address. | BN48.1 |
#SBB-STATESTATE | Alpha 2 | This is the state of the address. | BN48.1 |
#SBB-ZIPZIP | Alpha 10 | This is the postal code of the address. | BN48.1 |
#SBB-FICA-NBRFICA_NBR | Alpha 20 | This is the Social Security number. | BN48.1 |
#SBB-FULL-NAMEFULL_NAME | Derived | — | — |
#SBB-COUNTRY-CODECOUNTRY_CODE | Alpha 2 | The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). | BN48.1 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
SBBSET1 |
| Primary | BN00.1, BN140, BN248, BN48.1, BN48.2, BN60.1, HR11.1, PA115 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | BNCOMPANY | Required |
| ||||||||||
| Company Name | PRSYSTEM | Required |
| ||||||||||
| Country | INSTCTRYCD | Required | When (SBB-COUNTRY-CODE != Spaces) |
| |||||||||
| Dependent | EMDEPEND | Required | When SBB-DEP-NBR != Zeroes |
| |||||||||
| Employee | EMPLOYEE | Required |
|