Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPINVEST


                             EMPINVEST FILE

                      Emp Benefit Investment Dist

The Emp Benefit Investment Dist file contains the investment distribution of
the employee's defined contribution and defined benefit plans. The
distribution amounts are from BN36.1 (Defined Contribution Entry).

REFERENCED BY

BN330     HR170     HR70.1    BN245

UPDATED BY

BN100     BN101     BN102     BN103     BN105     BN31.1
BN31.2    BN32.1    BN32.2    BN32.3    BN36.1    BN430
BN531     BS32.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EMI-COMPANY            Numeric 4                                 BN100   BN101
Element: Company       Contains the company number. The number   BN102   BN103
                       correlates all information about the      BN105   BN31.1
                       company.                                  BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

EMI-EMPLOYEE           Numeric 9                                 BN100   BN101
Element: Employee      Contains the employee's number. The       BN102   BN103
                       number correlates all information about   BN105   BN31.1
                       the employee.                             BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

EMI-PLAN-CODE          Alpha 4                                   BN100   BN101
Element: Plan          Contains the code that represents a       BN102   BN103
                       defined contribution plan.                BN105   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

EMI-START-DATE         Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Date          Contains the start date of the benefit    BN102   BN103
                       plan.                                     BN105   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

EMI-SEQ-NBR            Numeric 4                                 BN100   BN101
Element: Sequence NumbeContains the automatically assigned       BN102   BN103
                       sequence number.                          BN105   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

EMI-DIST-ST-DATE       Numeric 8  (yyyymmdd)                     BN100   BN101
Invest Distribution    Contains the start date of the            BN102   BN103
Start Date             investment distribution.                  BN105   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

EMI-STOP-DATE          Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Date          Contains the stop date of the             BN102   BN103
                       investment distribution.                  BN105   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

EMI-DIST-PCT           Signed 5.2                                BN100   BN101
Element: Distribution PContains the percent of the employee's    BN102   BN103
                       total contribution amount that is         BN105   BN31.1
                       distributed to the investment.            BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

EMI-CREATION-DATE      Numeric 8  (yyyymmdd)                     BN36.1
Element: Date

EMI-UPD-DATE           Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Upd Date                                                BN102   BN103
                                                                 BN105   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

EMI-TIME-STAMP         Numeric 6  (hhmmss)                       BN100   BN101
Element: Time Stamp    Contains the server time (hour, minute,   BN102   BN103
                       and second) when the record was last      BN105   BN31.1
                       changed.                                  BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

EMI-USER-ID            Alpha 10  (Lower Case)                    BN100   BN101
Element: User                                                    BN102   BN103
                                                                 BN105   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN36.1  BN531
                                                                 BS32.1

                         EMPINVEST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EMISET1   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PLAN-CODE                                              BN105   BN31.1
          START-DATE                                             BN31.2  BN32.1
          SEQ-NBR                                                BN32.2  BN32.3
          DIST-ST-DATE                                           BN330   BN36.1
                                                                 BN430   BN531
                                                                 BS32.1  HR170
                                                                 HR70.1

EMISET2   COMPANY                                                BN245   BN36.1
          EMPLOYEE
          PLAN-CODE
          START-DATE*
          SEQ-NBR
          DIST-ST-DATE

                         EMPINVEST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Benefit        BENEFIT      Required

                            EMI-COMPANY       -> BEN-COMPANY
                            "DC"              -> BEN-PLAN-TYPE
                            EMI-EMPLOYEE      -> BEN-EMPLOYEE
                            EMI-START-DATE    -> BEN-START-DATE
                            EMI-PLAN-CODE     -> BEN-PLAN-CODE

Company        BNCOMPANY    Required

                            EMI-COMPANY       -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            EMI-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            EMI-COMPANY       -> EMP-COMPANY
                            EMI-EMPLOYEE      -> EMP-EMPLOYEE

Investment     BNINVEST     Required

                            EMI-COMPANY       -> BIV-COMPANY
                            EMI-PLAN-CODE     -> BIV-PLAN-CODE
                            EMI-SEQ-NBR       -> BIV-SEQ-NBR

Paemployee     PAEMPLOYEE   Required

                            EMI-COMPANY       -> PEM-COMPANY
                            EMI-EMPLOYEE      -> PEM-EMPLOYEE

Plan           PLAN         Required

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