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 BN100 BN101 BN102 BN103 BN105
BN15.1 BN215 BN245 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN330 BN36.1 BN531 BS32.1
ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3

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 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3


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: Thu Jun 09 11:09:59 2016

Home
Contact Us



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