BNFAMSTS FILE REFERENCED BY BN100 BN101 BN102 BN103 BN105 BN145 BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320 BN331 BN45.1 BN531 BN65.1 BN71.1 BN72.1 BS09.1 BS10.1 BS11.1 BS12.1 BS13.1 BS14.1 BS15.1 BS32.1 BN15.1 UPDATED BY BS02.1 BS03.2 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY BFS-COMPANY Numeric 4 BS03.2 Company The company number represents an established company and is entered on all function codes. BFS-PROCESS-LEVEL Alpha 5 BS03.2 Process Level This field contains the process level, which is the reporting hierarchy below company. BFS-FAMILY-STATUS Alpha 10 BS03.2 Family Status BFS-GROUP-NAME Alpha 10 BS03.2 Group Name BFS-PLAN-GROUP Alpha 20 BS03.2 Plan Group BFS-PLAN-TYPE Alpha 2 BS03.2 Type HL = Health DN = Dental DI = Disability EL = Employee Life DL = Dependent Life DC = Defined Contribution DB = Defined Benefit VA = Vacation RS = Spending Account SB = Savings Bond SP = Stock Purchase BFS-PLAN-CODE Alpha 4 BS03.2 Plan Contains the user-defined code that represents a benefit plan. BFS-PROCESS-ORDER Numeric 2 BS02.1 BS03.2 Process Order BFS-INQUIRE-ONLY Alpha 1 Inquire Only Y = Yes N = No BFS-ADD-ALLOWED Alpha 1 BS03.2 Add Allowed Y = Yes N = No BFS-ADD-DATE Alpha 2 BS03.2 Add Date FS = Family Status Change Date CM = First of Current Month NM = First of Next Month CP = First of Current Pay Period NP = First of Next Pay Period CW = First of Current Work Period NW = First of Next Work Period BFS-CHANGE-ALLOWED Alpha 1 BS03.2 Change Allowed Y = Yes N = No BFS-CHANGE-DATE Alpha 2 BS03.2 Change Date FS = Family Status Change Date CM = First of Current Month NM = First of Next Month CP = First of Current Work Period NP = First of Next Pay Period CW = First of Current Work Period NW = First of Next Work Period BFS-STOP-ALLOWED Alpha 1 BS03.2 Stop Allowed Y = Yes N = No BFS-STOPPED-DATE Alpha 2 BS03.2 Stopped Date FS = Family Status Change Date CM = First of Current Month NM = First of Next Month CP = First of Current Pay Period NP = First of Next Pay Period CW = First of Current Work Period NW = First of Next Work Period BFS-EOI-DAYS Numeric 3 BS03.2 Eoi Days BFS-EMPLOYEE-COST Alpha 1 BS03.2 Employee Cost E = Employee Only F = Flex Only B = Employee And Flex Both T = Total of Employee And Flex BFS-COMPANY-COST Alpha 1 BS03.2 Company Cost Y = Yes N = No BFS-DEP-BENEFITS Alpha 1 BS03.2 Dep Benefits Y = Yes N = No BFS-BENEFICIARY Alpha 1 Beneficiary Y = Yes N = No BFS-CO-PROVIDED Alpha 1 Co Provided Y = Yes N = No BNFAMSTS FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN BFSSET1 COMPANY BN100 BN101 PROCESS-LEVEL BN102 BN103 FAMILY-STATUS BN105 BN145 GROUP-NAME BN245 BN31.1 PLAN-GROUP BN31.2 BN32.1 PLAN-TYPE BN32.2 BN32.3 PLAN-CODE BN320 BN331 BN45.1 BN531 BN65.1 BN71.1 BN72.1 BS03.2 BS09.1 BS10.1 BS11.1 BS12.1 BS13.1 BS14.1 BS15.1 BS32.1 BFSSET2 COMPANY BS10.1 BS12.1 PROCESS-LEVEL FAMILY-STATUS GROUP-NAME PROCESS-ORDER PLAN-TYPE PLAN-CODE BFSSET3 COMPANY BS03.2 BS13.1 PROCESS-LEVEL BS14.1 BS15.1 FAMILY-STATUS GROUP-NAME PLAN-TYPE PLAN-CODE BFSSET4 COMPANY BS02.1 PROCESS-LEVEL PLAN-GROUP FAMILY-STATUS GROUP-NAME PLAN-TYPE PLAN-CODE BFSSET5 COMPANY Duplicates BN15.1 PLAN-TYPE PLAN-CODE BNFAMSTS FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Bnplngroup BNPLNGROUP Required BFS-COMPANY -> BPG-COMPANY BFS-PLAN-GROUP -> BPG-PLAN-GROUP Employee Group PERSGROUP Required BFS-COMPANY -> PRG-COMPANY BFS-GROUP-NAME -> PRG-GROUP-NAME Plan PLAN Required BFS-COMPANY -> PLN-COMPANY BFS-PLAN-TYPE -> PLN-PLAN-TYPE BFS-PLAN-CODE -> PLN-PLAN-CODE Process Level PRSYSTEM Required BFS-COMPANY -> PRS-COMPANY BFS-PROCESS-LEVEL -> PRS-PROCESS-LEVEL Prsystem PRSYSTEM Required BFS-COMPANY -> PRS-COMPANY Spaces -> PRS-PROCESS-LEVEL |