BNINVEST FILE
Investment Distribution
The Investment Distribution file contains the investment choices for defined
contribution plans. Each record represents one investment choice.
REFERENCED BY
BN215 BN245 BN330 BN36.1 HR170 HR70.1
BN100 BN101
UPDATED BY
BN00.1 BN15.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BIV-COMPANY Numeric 4 BN15.1
Company The company number represents an
established company and is entered on
all function codes.
BIV-PLAN-CODE Alpha 4 BN15.1
Plan Contains the user-defined code used to
represent a specific benefit plan.
BIV-SEQ-NBR Numeric 4 BN15.1
Sequence Number An automatically assigned sequence
number.
BIV-DESC Alpha 30 (Lower Case) BN15.1
Description This field contains the description of
the of the investment account.
BIV-ACTIVE-FLAG Alpha 1 BN15.1
Status The active flag identifies the status
of the account.
A = Active
I = Inactive
BIV-DEFAULT Alpha 1 BN15.1
Default Y = Yes
N = No
BNINVEST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BIVSET1 COMPANY BN00.1 BN15.1
PLAN-CODE BN215 BN245
SEQ-NBR BN330 BN36.1
HR170 HR70.1
BIVSET2 COMPANY KeyChange, Subset BN100 BN101
PLAN-CODE Where (DEFAULT = "Y" ) BN15.1
SEQ-NBR
BNINVEST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
