Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNFAMSTS

                             BNFAMSTS FILE

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN145
BN232     BN245     BN31.1    BN31.2    BN32.1    BN32.2
BN32.3    BN320     BN331     BN340     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
Element: Company Hr

BFS-PROCESS-LEVEL      Alpha 5                                   BS03.2
Element: Process Lev Hr

BFS-FAMILY-STATUS      Alpha 10                                  BS03.2
Element: 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
Element: Group Name

BFS-PLAN-GROUP         Alpha 20                                  BS03.2
Element: Plan Group

BFS-PLAN-TYPE          Alpha 2                                   BS03.2
Element: Plan 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
Element: Plan Code     Contains the user-defined code that
                       represents a benefit plan.

BFS-PROCESS-ORDER      Numeric 2                                 BS02.1  BS03.2
Element: Process Order

BFS-INQUIRE-ONLY       Alpha 1
Element: Inquire Only  Y = Yes
                       N = No

BFS-ADD-ALLOWED        Alpha 1                                   BS03.2
Element: Add Allowed   Y = Yes
                       N = No

BFS-ADD-DATE           Alpha 2                                   BS03.2
Element: 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
Element: Change AllowedY = Yes
                       N = No

BFS-CHANGE-DATE        Alpha 2                                   BS03.2
Element: 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
Element: Stop Allowed  Y = Yes
                       N = No

BFS-STOPPED-DATE       Alpha 2                                   BS03.2
Element: 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
Element: Eoi Days

BFS-EMPLOYEE-COST      Alpha 1                                   BS03.2
Element: 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
Element: Company Cost  Y = Yes
                       N = No

BFS-DEP-BENEFITS       Alpha 1                                   BS03.2
Element: Dep Benefits  Y = Yes
                       N = No

BFS-BENEFICIARY        Alpha 1
Element: Beneficiary   Y = Yes
                       N = No

BFS-CO-PROVIDED        Alpha 1
Element: Co Provided   Y = Yes
                       N = No

BFS-CREATE-TRANS       Alpha 1                                   BS03.2
Element: Create Trans  Y = Yes
                       N = No

BFS-DEFAULT-REASON     Alpha 10 Occurs 3 Times                   BS03.2
Element: Reason

BFS-REASON-1           Derived
Element: Reason 1

                         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                                             BN232   BN245
          PLAN-GROUP                                             BN31.1  BN31.2
          PLAN-TYPE                                              BN32.1  BN32.2
          PLAN-CODE                                              BN32.3  BN320
                                                                 BN331   BN340
                                                                 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

Reason Code    PCODES       Required
                            When BFS-REASON-1 != Zeroes

                            "BT"                  -> PCO-TYPE
                            BFS-DEFAULT-REASON    -> PCO-CODE