 |
Lawson Insight Technical Documentation |
|
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
|