Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
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
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
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
Start 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
Sequence Number      Contains 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
Stop 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
Distribution Percent Contains 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
Creation Date        This is the date that this line was
                     added to the requisition.

EMI-UPD-DATE         Numeric 8  (yyyymmdd)                       BN100   BN101
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
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
User ID Name         Contains the user ID of the person who      BN102   BN103
                     last changed this record.                   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