Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNINVEST


                             BNINVEST FILE

                        Investment Distribution

The Investment Distribution file contains the investment choices for defined
contribution plans. Each record represents one investment choice.

REFERENCED BY

BN215     BN245     BN330     BN36.1    HR170     HR70.1
BN100     BN101     BN102     BN103     BN105     BN31.1
BN31.2    BN32.1    BN32.2    BN32.3    BN531     BS32.1

UPDATED BY

BN00.1    BN15.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

BIV-PLAN-CODE          Alpha 4                                   BN15.1
Element: Plan          Contains the user-defined code used to
                       represent a specific benefit plan.

BIV-SEQ-NBR            Numeric 4                                 BN15.1
Element: Sequence NumbeAn automatically assigned sequence
                       number.

BIV-DESC               Alpha 30  (Lower Case)                    BN15.1
Element: Description   This field contains the description of
                       the of the investment account.

BIV-ACTIVE-FLAG        Alpha 1                                   BN15.1
Element: Status        The active flag identifies the status
                       of the account.
                       A = Active
                       I = Inactive

BIV-DEFAULT            Alpha 1                                   BN15.1
Element: Default       Y = Yes
                       N = No

                         BNINVEST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BIVSET1   COMPANY                                                BN00.1  BN15.1
          PLAN-CODE                                              BN215   BN245
          SEQ-NBR                                                BN330   BN36.1
                                                                 HR170   HR70.1

BIVSET2   COMPANY       KeyChange, Subset                        BN100   BN101
          PLAN-CODE     Where (DEFAULT = "Y" )                   BN102   BN103
          SEQ-NBR                                                BN105   BN15.1
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN531
                                                                 BS32.1

                         BNINVEST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            BIV-COMPANY      -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            BIV-COMPANY      -> PRS-COMPANY
                            Spaces           -> PRS-PROCESS-LEVEL

Plan           PLAN         Required

                            BIV-COMPANY      -> PLN-COMPANY
                            "DC"             -> PLN-PLAN-TYPE
                            BIV-PLAN-CODE    -> PLN-PLAN-CODE