Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BONDBENSEQ


                            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    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BBS-COMPANY            Numeric 4                                 BN48.2
Element: Company       Contains the company number.

BBS-EMPLOYEE           Numeric 9                                 BN48.2
Element: Employee      Contains the employee number.

BBS-PLAN-CODE          Alpha 4                                   BN48.2
Element: Plan          Contains the user-defined code that
                       represents a savings bond plan.

BBS-START-DATE         Numeric 8  (yyyymmdd)                     BN48.2
Element: 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
Element: Bond Seq Nbr  Contains the sequence in which the
                       employee wants to purchase bonds.

BBS-OWNER              Alpha 3                                   BN48.2
Element: Owner         Contains the owner name to be used on
                       the bond.

BBS-CO-OWNER           Alpha 3                                   BN48.2
Element: Co-Owner      Contains the co-owner name to be used
                       on the bond.

BBS-BNFC-NBR           Alpha 3 Occurs 12 Times                   BN48.2
Element: Beneficiary NuContains 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  HR11.1
          PLAN-CODE                                              PA115
          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