BONDBENSEQ

Savings Bond Sequence

The Savings Bond Sequence file contains the sequence used to purchase bonds for each employee and savings bond plan. The sequence record defines the owner, co-owner, and beneficiaries used to purchase a savings bond.
UPDATED BY
BN140 BN248 BN48.2 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BBS-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
BN48.2
BBS-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number.
BN48.2
BBS-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code that represents a savings bond plan.
BN48.2
BBS-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the date the sequence is in effect. When BN140 (Savings Bond Update) is run, it uses the sequence in effect to determine the order for the bonds.
BN48.2
BBS-BOND-SEQ-NBR
Element: Bond Seq Nbr		Numeric 2
Contains the sequence in which the employee wants to purchase bonds.
BN48.2
BBS-OWNER
Element: Owner		Alpha 3
Contains the owner name to be used on the bond.
BN48.2
BBS-CO-OWNER
Element: Co Owner		Alpha 3
Contains the co-owner name to be used on the bond.
BN48.2
BBS-BNFC-NBR
Element: Bnfc Nbr		Alpha 3 Occurs 12 Times
Contains the beneficiary to be used on the bond. Up to 12 beneficiaries can be used.
BN48.2


BONDBENSEQ FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BBSSET1 COMPANY
EMPLOYEE
PLAN-CODE
START-DATE
BOND-SEQ-NBR
BN140 BN248
BN48.2 HR11.1
PA115
BBSSET2 COMPANY
EMPLOYEE
PLAN-CODE
START-DATE
BOND-SEQ-NBR*
BN140 BN248
BN48.2


BONDBENSEQ FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Beneficiaries SBBEN Not Required
BBS-COMPANY->SBB-COMPANY
BBS-EMPLOYEE->SBB-EMPLOYEE
BBS-BNFC-NBR->SBB-BNFC-NBR
Benefit BENEFIT Not Required
BBS-COMPANY->BEN-COMPANY
BBS-EMPLOYEE->BEN-EMPLOYEE
"SB"->BEN-PLAN-TYPE
BBS-PLAN-CODE->BEN-PLAN-CODE
BBS-START-DATE->BEN-START-DATE
Bncompany BNCOMPANY Required
BBS-COMPANY->BNC-COMPANY
Co Owner SBBEN Not Required
BBS-COMPANY->SBB-COMPANY
BBS-EMPLOYEE->SBB-EMPLOYEE
BBS-CO-OWNER->SBB-BNFC-NBR
Employee EMPLOYEE Required
BBS-COMPANY->EMP-COMPANY
BBS-EMPLOYEE->EMP-EMPLOYEE
Hrcompany PRSYSTEM Required
BBS-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Owner SBBEN Not Required
BBS-COMPANY->SBB-COMPANY
BBS-EMPLOYEE->SBB-EMPLOYEE
BBS-OWNER->SBB-BNFC-NBR


BONDBENSEQ FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Bond BONDBENIF
BBS-COMPANY->BON-COMPANY
BBS-EMPLOYEE->BON-EMPLOYEE
BBS-PLAN-CODE->BON-PLAN-CODE
BBS-START-DATE->BON-START-DATE
  BON-BOND-NBR
Plan PLAN Required
BBS-COMPANY->PLN-COMPANY
  PLN-PLAN-TYPE
  PLN-PLAN-CODE

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

Home
Contact Us



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