BONDBENIF

Savings Bond Beneficiary

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.
UPDATED BY
BN140 BN430 BN48.1 BN48.2 BN60.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BON-COMPANY
Element: Company Hr		Numeric 4
Contains the company number. The number correlates all information about the company.
BN140
BON-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee's number. The number correlates all information about the employee.
BN140
BON-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the code that represents a benefit plan.
BN140
BON-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the benefit start date.
BN140
BON-BOND-NBR
Element: Bond Nbr		Numeric 4
Contains the bond number.
BN140
BON-OWNER
Element: Owner		Alpha 3
Contains the number which indicates the bond's owner.
BN140
BON-CO-OWNER
Element: Co Owner		Alpha 3
Contains the number which indicates the bond's co-owner.
BN140
BON-BNFC-NBR
Element: Bnfc Nbr		Alpha 3 Occurs 12 Times
Contains the number which indicates the bond's beneficiary.
BN140
BON-DATE-PURCH
Element: Date Purch		Numeric 8 (yyyymmdd)
Contains the date the bond was purchased.
BN140


BONDBENIF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BONSET1 COMPANY
EMPLOYEE
PLAN-CODE
START-DATE
BOND-NBR
BN430 BN48.1
BN48.2 BN60.1


BONDBENIF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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

File created: Wed Jun 08 20:48:07 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.