BNINVEST

Investment Distribution

The Investment Distribution file contains the investment choices for defined contribution plans. Each record represents one investment choice.

REFERENCED BY
HR170 HR70.1


UPDATED BY
BN00.1 BN15.1 BN215 BN245 BN330 BN36.1
BN100 BN101 BN102 BN103 BN105 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN531 BS32.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BIV-COMPANY
Element: Company Hr		Numeric 4
The company number represents an established company and is entered on all function codes.
BN15.1
BIV-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code used to represent a specific benefit plan.
BN15.1
BIV-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
BN15.1
BIV-DESC
Element: Description		Alpha 30 (Lower Case)
This field contains the description of the of the investment account.
BN15.1
BIV-ACTIVE-FLAG
Element: Active Flag		Alpha 1
The active flag identifies the status of the account.
A = Active
I = Inactive
BN15.1
BIV-DEFAULT
Element: Default		Alpha 1

Y = Yes
N = No
BN15.1


BNINVEST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BIVSET1 COMPANY
PLAN-CODE
SEQ-NBR
BN00.1 BN15.1
BN215 BN245
BN330 BN36.1
HR170 HR70.1
BIVSET2 COMPANY
PLAN-CODE
SEQ-NBR
KeyChange, Subset
Where(DEFAULT ="Y")
BN100 BN101
BN102 BN103
BN105 BN15.1
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1


BNINVEST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
BIV-COMPANY->BNC-COMPANY
Company Name PRSYSTEM Required
BIV-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Plan PLAN Required
BIV-COMPANY->PLN-COMPANY
"DC"->PLN-PLAN-TYPE
BIV-PLAN-CODE->PLN-PLAN-CODE

File created: Wed Jun 08 20:48:06 2016

Home
Contact Us



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