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