|
|
SBBEN FILE
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 Numeric 4 BN48.1
Element: Company Hr The company number represents an
established company and is entered on
all function codes.
SBB-EMPLOYEE Numeric 9 BN48.1
Element: Employee Employee number is assigned to each
person employed by the company. It is
used to correlate all information
related to the employee.
SBB-BNFC-NBR Alpha 3 BN48.1
Element: Bnfc Nbr 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.
SBB-DEP-NBR Numeric 4 BN48.1
Element: Dep Nbr 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.
SBB-LAST-NAME Alpha 30 (Lower Case) BN48.1
Element: Last Name This is the owner or beneficiary's last
name.
SBB-FIRST-NAME Alpha 15 (Lower Case) BN48.1
Element: First Name This is the owner or beneficiary's
first name.
SBB-MIDDLE-INIT Alpha 1 BN48.1
Element: Middle Init This is the owner or beneficiary's
middle initial.
SBB-ADDR1 Alpha 30 (Lower Case) BN48.1
Element: Addr1 This is the first line of address
information.
SBB-ADDR2 Alpha 30 (Lower Case) BN48.1
Element: Addr1 This is the second line of address
information.
SBB-ADDR3 Alpha 30 (Lower Case) BN48.1
Element: Addr1 Contains the third line of address
information.
SBB-ADDR4 Alpha 30 (Lower Case) BN48.1
Element: Addr1 Contains the fourth line of address
information.
SBB-CITY Alpha 18 (Lower Case) BN48.1
Element: City This is the city name of the address.
SBB-STATE Alpha 2 BN48.1
Element: State This is the state of the address.
SBB-ZIP Alpha 10 BN48.1
Element: Zip This is the postal code of the address.
SBB-FICA-NBR Alpha 20 BN48.1
Element: Social Number This is the Social Security number.
SBB-FULL-NAME Derived
Element: Full Name
SBB-COUNTRY-CODE Alpha 2 BN48.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
SBBEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SBBSET1 COMPANY BN00.1 BN140
EMPLOYEE BN248 BN48.1
BNFC-NBR BN48.2 BN60.1
HR11.1 PA115
SBBEN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
