|
|
BONDBENIF FILE
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.
REFERENCED BY
BN48.1 BN48.2 BN60.1
UPDATED BY
BN140 BN430
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BON-COMPANY Numeric 4 BN140
Company Contains the company number. The number
correlates all information about the
company.
BON-EMPLOYEE Numeric 9 BN140
Employee Contains the employee's number. The
number correlates all information about
the employee.
BON-PLAN-CODE Alpha 4 BN140
Plan Contains the code that represents a
benefit plan.
BON-START-DATE Numeric 8 (yyyymmdd) BN140
Start Date Contains the benefit start date.
BON-BOND-NBR Numeric 4 BN140
Savings Bond Number Contains the bond number.
BON-OWNER Alpha 3 BN140
Owner Contains the number which indicates the
bond's owner.
BON-CO-OWNER Alpha 3 BN140
Co-Owner Contains the number which indicates the
bond's co-owner.
BON-BNFC-NBR Alpha 3 Occurs 12 Times BN140
Beneficiary Number Contains the number which indicates the
bond's beneficiary.
BON-DATE-PURCH Numeric 8 (yyyymmdd) BN140
Date Purchased Contains the date the bond was
purchased.
BONDBENIF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BONSET1 COMPANY BN430 BN48.1
EMPLOYEE BN48.2 BN60.1
PLAN-CODE
START-DATE
BOND-NBR
BONSET2 COMPANY
EMPLOYEE
PLAN-CODE
START-DATE
BOND-NBR*
BONDBENIF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|