SBBEN

Savings Bond Beneficiary

The Savings Bond Beneficiary file contains the name, address and Social Security number for owners, co-owners and beneficiaries for savings bonds.

REFERENCED BY
BN140 BN248 BN60.1


UPDATED BY
BN00.1 BN48.1 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SBB-COMPANY
Element: Company Hr
Numeric 4
The company number represents an established company and is entered on all function codes.
BN48.1
SBB-EMPLOYEE
Element: Employee
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
Element: Bnfc 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-NBR
Element: Dep 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-NAME
Element: Last Name
Alpha 30 (Lower Case)
This is the owner or beneficiary's last name.
BN48.1
SBB-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
This is the owner or beneficiary's first name.
BN48.1
SBB-MIDDLE-INIT
Element: Middle Init
Alpha 1
This is the owner or beneficiary's middle initial.
BN48.1
SBB-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This is the first line of address information.
BN48.1
SBB-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This is the second line of address information.
BN48.1
SBB-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
Contains the third line of address information.
BN48.1
SBB-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
Contains the fourth line of address information.
BN48.1
SBB-CITY
Element: City
Alpha 18 (Lower Case)
This is the city name of the address.
BN48.1
SBB-STATE
Element: State
Alpha 2
This is the state of the address.
BN48.1
SBB-ZIP
Element: Zip
Alpha 10
This is the postal code of the address.
BN48.1
SBB-FICA-NBR
Element: Social Number
Alpha 20
This is the Social Security number.
BN48.1
SBB-FULL-NAME
Element: Full Name
Derived
SBB-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
BN48.1


SBBEN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SBBSET1 COMPANY
EMPLOYEE
BNFC-NBR
BN00.1 BN140
BN248 BN48.1
BN48.2 BN60.1
HR11.1 PA115


SBBEN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
SBB-COMPANY->BNC-COMPANY
Company Name PRSYSTEM Required
SBB-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When (SBB-COUNTRY-CODE !=Spaces )
SBB-COUNTRY-CODE->INT-COUNTRY-CODE
Dependent EMDEPEND Required
When SBB-DEP-NBR !=Zeroes
SBB-COMPANY->EMD-COMPANY
SBB-EMPLOYEE->EMD-EMPLOYEE
SBB-DEP-NBR->EMD-SEQ-NBR
Employee EMPLOYEE Required
SBB-COMPANY->EMP-COMPANY
SBB-EMPLOYEE->EMP-EMPLOYEE


File created: Thu Jun 09 11:10:11 2016

Home
Contact Us



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