|
|
BONDBENSEQ FILE
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.
REFERENCED BY
BN140 BN248
UPDATED BY
BN48.2 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BBS-COMPANY Numeric 4 BN48.2
Company Contains the company number.
BBS-EMPLOYEE Numeric 9 BN48.2
Employee Contains the employee number.
BBS-PLAN-CODE Alpha 4 BN48.2
Plan Contains the user-defined code that
represents a savings bond plan.
BBS-START-DATE Numeric 8 (yyyymmdd) BN48.2
Start Date 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.
BBS-BOND-SEQ-NBR Numeric 2 BN48.2
Bond Seq Nbr Contains the sequence in which the
employee wants to purchase bonds.
BBS-OWNER Alpha 3 BN48.2
Owner Contains the owner name to be used on
the bond.
BBS-CO-OWNER Alpha 3 BN48.2
Co-Owner Contains the co-owner name to be used
on the bond.
BBS-BNFC-NBR Alpha 3 Occurs 12 Times BN48.2
Beneficiary Number Contains the beneficiary to be used on
the bond. Up to 12 beneficiaries can be
used.
BONDBENSEQ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BBSSET1 COMPANY BN140 BN248
EMPLOYEE BN48.2 PA115
PLAN-CODE
START-DATE
BOND-SEQ-NBR
BBSSET2 COMPANY BN140 BN248
EMPLOYEE BN48.2
PLAN-CODE
START-DATE
BOND-SEQ-NBR*
BONDBENSEQ FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|