Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SBBEN


                               SBBEN FILE

                        Savings Bond Beneficiary

The Savings Bond Beneficiary file contains the name, address and Social
Security number for owners, co-owners and beneficiaries for savings bonds.

REFERENCED BY

BN140     BN248     BN60.1

UPDATED BY

BN00.1    BN48.1    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SBB-COMPANY            Numeric 4                                 BN48.1
Element: Company Hr    The company number represents an
                       established company and is entered on
                       all function codes.

SBB-EMPLOYEE           Numeric 9                                 BN48.1
Element: Employee      Employee number is assigned to each
                       person employed by the company.  It is
                       used to correlate all information
                       related to the employee.

SBB-BNFC-NBR           Alpha 3                                   BN48.1
Element: Bnfc Nbr      This field contains a user-defined code
                       which indicates the person who is
                       assigned as the owner, co-owner or
                       beneficiary to a savings bond.

SBB-DEP-NBR            Numeric 4                                 BN48.1
Element: Dep Nbr       This field contains the dependent
                       number.  If the owner or beneficiary is
                       the employee's dependent, this is the
                       dependent number which is the
                       EMD-SEQ-NBR in the EMDEPEND file.  The
                       dependent number has been established on
                       HR13.1 (Dependent).  This value must be
                       valid in the EMDEPEND file.  If there is
                       a value in this field, there must also
                       be a valid employee in SBB-EMPLOYEE.

SBB-LAST-NAME          Alpha 30  (Lower Case)                    BN48.1
Element: Last Name     This is the owner or beneficiary's last
                       name.

SBB-FIRST-NAME         Alpha 15  (Lower Case)                    BN48.1
Element: First Name    This is the owner or beneficiary's
                       first name.

SBB-MIDDLE-INIT        Alpha 1                                   BN48.1
Element: Middle Init   This is the owner or beneficiary's
                       middle initial.

SBB-ADDR1              Alpha 30  (Lower Case)                    BN48.1
Element: Addr1         This is the first line of address
                       information.

SBB-ADDR2              Alpha 30  (Lower Case)                    BN48.1
Element: Addr1         This is the second line of address
                       information.

SBB-ADDR3              Alpha 30  (Lower Case)                    BN48.1
Element: Addr1         Contains the third line of address
                       information.

SBB-ADDR4              Alpha 30  (Lower Case)                    BN48.1
Element: Addr1         Contains the fourth line of address
                       information.

SBB-CITY               Alpha 18  (Lower Case)                    BN48.1
Element: City          This is the city name of the address.

SBB-STATE              Alpha 2                                   BN48.1
Element: State         This is the state of the address.

SBB-ZIP                Alpha 10                                  BN48.1
Element: Zip           This is the postal code of the address.

SBB-FICA-NBR           Alpha 20                                  BN48.1
Element: Social Number This is the Social Security number.

SBB-FULL-NAME          Derived
Element: Full Name

SBB-COUNTRY-CODE       Alpha 2                                   BN48.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

                         SBBEN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SBBSET1   COMPANY                                                BN00.1  BN140
          EMPLOYEE                                               BN248   BN48.1
          BNFC-NBR                                               BN48.2  BN60.1
                                                                 HR11.1  PA115

                         SBBEN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            SBB-COMPANY         -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            SBB-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Country        INSTCTRYCD   Required
                            When (SBB-COUNTRY-CODE != Spaces )

                            SBB-COUNTRY-CODE    -> INT-COUNTRY-CODE

Dependent      EMDEPEND     Required
                            When SBB-DEP-NBR != Zeroes

                            SBB-COMPANY         -> EMD-COMPANY
                            SBB-EMPLOYEE        -> EMD-EMPLOYEE
                            SBB-DEP-NBR         -> EMD-SEQ-NBR

Employee       EMPLOYEE     Required

                            SBB-COMPANY         -> EMP-COMPANY
                            SBB-EMPLOYEE        -> EMP-EMPLOYEE