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 |