Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BONDBENIF


                             BONDBENIF FILE

                        Savings Bond Beneficiary

The Savings Bond Beneficiary file contains information about bonds assigned
to owners, co-owners and beneficiaries.

BN140 (Savings Bond Update) is the primary program that updates this file.

REFERENCED BY

BN48.1    BN48.2    BN60.1

UPDATED BY

BN140     BN430

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BON-COMPANY            Numeric 4                                 BN140
Element: Company       Contains the company number. The number
                       correlates all information about the
                       company.

BON-EMPLOYEE           Numeric 9                                 BN140
Element: Employee      Contains the employee's number. The
                       number correlates all information about
                       the employee.

BON-PLAN-CODE          Alpha 4                                   BN140
Element: Plan          Contains the code that represents a
                       benefit plan.

BON-START-DATE         Numeric 8  (yyyymmdd)                     BN140
Element: Date          Contains the benefit start date.

BON-BOND-NBR           Numeric 4                                 BN140
Element: Savings Bond NContains the bond number.

BON-OWNER              Alpha 3                                   BN140
Element: Owner         Contains the number which indicates the
                       bond's owner.

BON-CO-OWNER           Alpha 3                                   BN140
Element: Co-Owner      Contains the number which indicates the
                       bond's co-owner.

BON-BNFC-NBR           Alpha 3 Occurs 12 Times                   BN140
Element: Beneficiary NuContains the number which indicates the
                       bond's beneficiary.

BON-DATE-PURCH         Numeric 8  (yyyymmdd)                     BN140
Element: Date PurchasedContains the date the bond was
                       purchased.

                         BONDBENIF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BONSET1   COMPANY                                                BN430   BN48.1
          EMPLOYEE                                               BN48.2  BN60.1
          PLAN-CODE
          START-DATE
          BOND-NBR

BONSET2   COMPANY
          EMPLOYEE
          PLAN-CODE
          START-DATE
          BOND-NBR*

                         BONDBENIF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Beneficiary    SBBEN        Required
                            When BON-BNFC-NBR != Spaces

                            BON-COMPANY       -> SBB-COMPANY
                            BON-EMPLOYEE      -> SBB-EMPLOYEE
                            BON-BNFC-NBR      -> SBB-BNFC-NBR

Benefit        BENEFIT      Required

                            BON-COMPANY       -> BEN-COMPANY
                            "SB"              -> BEN-PLAN-TYPE
                            BON-EMPLOYEE      -> BEN-EMPLOYEE
                            BON-START-DATE    -> BEN-START-DATE
                            BON-PLAN-CODE     -> BEN-PLAN-CODE

Co Owner       SBBEN        Required
                            When BON-CO-OWNER != Spaces

                            BON-COMPANY       -> SBB-COMPANY
                            BON-EMPLOYEE      -> SBB-EMPLOYEE
                            BON-CO-OWNER      -> SBB-BNFC-NBR

Company        BNCOMPANY    Required

                            BON-COMPANY       -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            BON-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            BON-COMPANY       -> EMP-COMPANY
                            BON-EMPLOYEE      -> EMP-EMPLOYEE

Owner          SBBEN        Required
                            When BON-OWNER != Spaces

                            BON-COMPANY       -> SBB-COMPANY
                            BON-EMPLOYEE      -> SBB-EMPLOYEE
                            BON-OWNER         -> SBB-BNFC-NBR

Pa Employee    PAEMPLOYEE   Required

                            BON-COMPANY       -> PEM-COMPANY
                            BON-EMPLOYEE      -> PEM-EMPLOYEE

Plan           PLAN         Required

                            BON-COMPANY       -> PLN-COMPANY
                            "SB"              -> PLN-PLAN-TYPE
                            BON-PLAN-CODE     -> PLN-PLAN-CODE