EMPINVEST – Emp Benefit Investment Dist
- System
- Benefits (BN)
- Prefix
EMI- Primary key
COMPANY,EMPLOYEE,PLAN-CODE,START-DATE,SEQ-NBR,DIST-ST-DATE- Fields
- 12
- Updated by
- 20 programs
- Referenced by
- 4 programs
EMPINVEST is the Emp Benefit Investment Dist table in Lawson Benefits (prefix EMI). It is indexed by COMPANY, EMPLOYEE, PLAN-CODE, START-DATE, SEQ-NBR, DIST-ST-DATE (EMISET1); alternate indexes: EMISET2 and EMISET3. It is related 1:1 to BENEFIT, BNCOMPANY, PRSYSTEM, EMPLOYEE, BNINVEST, PAEMPLOYEE and PLAN. It is updated by BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 and 12 more and referenced by BN245, BN330, HR170 and HR70.1. The table has 12 fields, 3 indexes and 7 documented relations.
About EMPINVEST
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).
Fields (12)
Column = COBOL field name without the EMI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
EMI-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. The number correlates all information about the company. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
EMI-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains the employee's number. The number correlates all information about the employee. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
EMI-PLAN-CODE PKPLAN_CODE | Alpha 4 | Contains the code that represents a defined contribution plan. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
EMI-START-DATE PKSTART_DATE | Numeric 8 (yyyymmdd) | Contains the start date of the benefit plan. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
EMI-SEQ-NBR PKSEQ_NBR | Numeric 4 | Contains the automatically assigned sequence number. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
EMI-DIST-ST-DATE PKDIST_ST_DATE | Numeric 8 (yyyymmdd) | Contains the start date of the investment distribution. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
EMI-STOP-DATESTOP_DATE | Numeric 8 (yyyymmdd) | Contains the stop date of the investment distribution. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
EMI-DIST-PCTDIST_PCT | Signed 5.2 | Contains the percent of the employee's total contribution amount that is distributed to the investment. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
EMI-CREATION-DATECREATION_DATE | Numeric 8 (yyyymmdd) | This is the date that this line was added to the requisition. | BN36.1 |
EMI-UPD-DATEUPD_DATE | Numeric 8 (yyyymmdd) | — | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
EMI-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
EMI-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
EMISET1 | COMPANY, EMPLOYEE, PLAN-CODE, START-DATE, SEQ-NBR, DIST-ST-DATE | Primary | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +15 more | |
EMISET2 | COMPANY, EMPLOYEE, PLAN-CODE, START-DATE*, SEQ-NBR, DIST-ST-DATE | BN245, BN36.1 | ||
EMISET3 | COMPANY, CREATION-DATE*, UPD-DATE*, EMPLOYEE, PLAN-CODE, START-DATE, SEQ-NBR | KeyChange | — |
Relations
One to one (7) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Benefit | BENEFIT | Required | EMI-COMPANY → BEN-COMPANY (BENSET1), "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 |
Programs
Updated by (20)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN105 Plan Update
- BN31.1 Speed Benefit Entry
- BN31.2 Employee Benefit Entry
- BN32.1 Employee Benefit Changes
- BN32.2 Employee Benefit Detail Changes
- BN32.3 Benefit Add
- BN36.1 Investment
- BN430 Benefit Purge
- BN531 Batch Benefit Enrollment
- BS32.1 Web Enrollment Stop Benefits Update
- ZB10.1 Coverage Options Calculator
- ZB31.1 Speed Benefit Entry
- ZB31.2 Employee Benefit Entry
- ZB32.1 Employee Benefit Changes
- ZB32.2 Employee Benefit Detail Changes
- ZB32.3 Benefit Add