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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`EMI-COMPANY` PK COMPANY	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` PK EMPLOYEE	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` PK PLAN_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` PK START_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` PK SEQ_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` PK DIST_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-DATE` STOP_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-PCT` DIST_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-DATE` SET3 CREATION_DATE	Numeric 8 (yyyymmdd)	This is the date that this line was added to the requisition.	BN36.1
#`EMI-UPD-DATE` SET3 UPD_DATE	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more
#`EMI-TIME-STAMP` TIME_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-ID` USER_ID	Alpha 10 (Lower Case)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	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

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

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

Referenced by (4)

BN245 Benefit Election Form
BN330 Defined Contribution Plan Contributions
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry

EMPINVEST – Emp Benefit Investment Dist

About EMPINVEST

Fields (12) Copy as SQL

Indexes (3)

Relations

One to one (7) — lookups and parents

Programs

Updated by (20)

Referenced by (4)

Fields (12)