Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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        ADOPTION = Adoption
                     BIRTH = Birth
                     DEATH = Death
                     DIVORCE = Divorce
                     LEGAL SEP = Legal Separation
                     LOA = Leave of Absence
                     MARRIAGE = Marriage
                     MOVE = Address Change
                     RETIREMENT = Retirement
                     SPS CHANGE = Spouse Coverage Change\
                     STUDENT = Student

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                                                BN15.1
          PLAN-TYPE
          PLAN-CODE
          PROCESS-LEVEL
          FAMILY-STATUS
          GROUP-NAME
          PLAN-GROUP

                         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