EMPINVEST

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).
UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN245
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN330
BN36.1 BN430 BN531 BS32.1 ZB10.1 ZB31.1
ZB31.2 ZB32.1 ZB32.2 ZB32.3 HR170 HR70.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMI-COMPANY
Element: Company Hr		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
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EMI-EMPLOYEE
Element: 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
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EMI-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the code that represents a defined contribution plan.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EMI-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the start date of the benefit plan.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EMI-SEQ-NBR
Element: Seq Nbr		Numeric 4
Contains the automatically assigned sequence number.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EMI-DIST-ST-DATE
Element: 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
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EMI-STOP-DATE
Element: Stop Date		Numeric 8 (yyyymmdd)
Contains the stop date of the investment distribution.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EMI-DIST-PCT
Element: 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
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EMI-CREATION-DATE
Element: Creation Date		Numeric 8 (yyyymmdd)
This is the date that this line was added to the requisition.
BN36.1
EMI-UPD-DATE
Element: Upd Date		Numeric 8 (yyyymmdd)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EMI-TIME-STAMP
Element: 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
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
EMI-USER-ID
Element: User		Alpha 10 (Lower Case)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN36.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3


EMPINVEST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMISET1 COMPANY
EMPLOYEE
PLAN-CODE
START-DATE
SEQ-NBR
DIST-ST-DATE
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN330 BN36.1
BN430 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 HR170
HR70.1
EMISET2 COMPANY
EMPLOYEE
PLAN-CODE
START-DATE*
SEQ-NBR
DIST-ST-DATE
BN245 BN36.1


EMPINVEST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:10:04 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.