The US Savings Bond table. It contains the information about the US Saving
Bonds that the employee has purchased or is in the process of purchasing
through payroll deductions. The data originates from the Employee Data
Base (EDB).
| Field Name |
Business Name |
Data Type |
Description |
| BOND_ADDCODE |
BOND ADD DATA CODE |
VARCHAR2(1) |
The code indicating that bond 1 is to be added to the
file (A=Add
information or BLANK) |
| BOND_BENEFCODE |
BOND BENEFICIARY CODE |
VARCHAR2(1) |
The code indicating the existence of a beneficiary or co-owner
of bond 1
(B=Beneficiary, C=Co-owner, or BLANK) |
| BOND_BENEFNAME1 |
BENEFICIARY NAME |
VARCHAR2(30) |
The first thirty characters of the name of the beneficiary or
co-owner of
bond 1 |
| BOND_BENEFNAME2 |
BENEFICIARY NAME (2) |
VARCHAR2(2) |
The last two characters of the name of the beneficiary or co-owner
of bond
1 |
| BOND_DELDENOM |
BOND DELETION-MATCH DENOMINATION CODE |
VARCHAR2(1) |
The code indicating the denomination amount that must match the
denomination amount on the bond if bond 1 is to be deleted (4=10000,
5=-200.00, 6=500.00, or 7=1,000.00) |
| BOND_DELETECODE |
BOND DELETE DATA CODE |
VARCHAR2(1) |
The code indicating that bond 1 is to be deleted
(D=Delete information or
BLANK) |
| BOND_DELOWNSSN |
BOND DELETION-MATCH SOCIAL SECURITY NUMBER |
VARCHAR2(9) |
The social security number that must match the social security
number on the
bond if bond 1 is to be deleted |
| BOND_DENOMCODE |
BOND DENOMONATION CODE |
VARCHAR2(1) |
The code indicating the denomination amount of bond 1 (4=10000,
5=-200.00, 6=500.00, or 7=1,000.00) |
| BOND_NUM |
BOND NUMBER |
VARCHAR2(1) |
The code indicating the sequential number of the bonds. |
| BOND_OWNERCITY |
BOND OWNER CITY |
VARCHAR2(19) |
The city in which the bond 1 owner address-street is located |
| BOND_OWNERNAME1 |
BOND OWNER NAME PATR 1 |
VARCHAR2(30) |
The first thirty characters of the name of the owner of bond 1 |
| BOND_OWNERNAME2 |
BOND OWNER NAME PART 2 |
VARCHAR2(2) |
The last two characters of the name of the owner of bond 1 |
| BOND_OWNERSSN |
BOND OWNER SOCIAL SECURITY NUMBER |
VARCHAR2(9) |
The social security number of the owner of bond 1 |
| BOND_OWNERSTATE |
BOND OWNER ADDRESS-STATE |
VARCHAR2(2) |
The standard US Postal Service abbreviation for the state in which Bond 1
Owner Address-Street is located. |
| BOND_OWNERSTRT1 |
BOND OWNER ADDRESS-STREET 1 |
VARCHAR2(30) |
The first thirty characters of the street address to which bond 1
is to be
sent |
| BOND_OWNERSTRT2 |
BOND OWNER ADDRESS-STREET 2 |
VARCHAR2(2) |
The last two characters of the street to which bond 1 is to be sent |
| BOND_OWNERZIP1 |
BOND OWNER ADDRESS-POSTAL CODE-ZIP |
VARCHAR2(5) |
The postal code assigned to the area in which the bond 1 owner address
is located.
|
| BOND_OWNERZIP2 |
BOND OWNER ADDRESS-POSTAL CODE-SUFFIX |
VARCHAR2(4) |
The suffix of the postal code assigned to the area in which the
bond 1 owner
address-street is located |
| EMPLOYEE_ID |
EMPLOYEE ID NUMBER |
VARCHAR2(9) |
The unique employee identification number |
