Lawson Insight Technical Documentation

                             BNNEWHIRE FILE

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN145
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.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BNN-COMPANY            Numeric 4                                 BS03.3
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

BNN-PROCESS-LEVEL      Alpha 5                                   BS03.3
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

BNN-GROUP-NAME         Alpha 10                                  BS03.3
Element: Group Name

BNN-PLAN-GROUP         Alpha 20                                  BS03.3
Element: Plan Group

BNN-PLAN-TYPE          Alpha 2                                   BS03.3
Element: Type          DB = Defined Benefit
                       DC = Defined Contribution
                       DI = Disability
                       DL = Dependent Life
                       DN = Dental
                       EL = Employee Life
                       HL = Health
                       RS = Spending Account
                       SB = Savings Bond
                       SP = Stock Purchase
                       VA = Vacation

BNN-PLAN-CODE          Alpha 4                                   BS03.3
Element: Plan          Contains the user-defined code that
                       represents a benefit plan.

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

BNN-EMPLOYEE-COST      Alpha 1                                   BS03.3
Element: Employee Cost E = Employee Only
                       F = Flex Only
                       B = Employee And Flex Both
                       T = Total of Employee And Flex

BNN-COMPANY-COST       Alpha 1                                   BS03.3
Element: Company Cost  Y = Yes
                       N = No

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

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

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

BNN-EOI-DAYS           Numeric 3                                 BS03.3
Element: Eoi Days

                         BNNEWHIRE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNNSET1   COMPANY                                                BN100   BN101
          PROCESS-LEVEL                                          BN102   BN103
          GROUP-NAME                                             BN105   BN145
          PLAN-GROUP                                             BN245   BN31.1
          PLAN-TYPE                                              BN31.2  BN32.1
          PLAN-CODE                                              BN32.2  BN32.3
                                                                 BN320   BN331
                                                                 BN340   BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS03.3  BS09.1
                                                                 BS10.1  BS11.1
                                                                 BS12.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1

BNNSET2   COMPANY                                                BS10.1  BS12.1
          PROCESS-LEVEL
          GROUP-NAME
          PROCESS-ORDER
          PLAN-TYPE
          PLAN-CODE

BNNSET3   COMPANY                                                BS03.3  BS13.1
          PROCESS-LEVEL                                          BS14.1  BS15.1
          GROUP-NAME
          PLAN-TYPE
          PLAN-CODE

BNNSET4   COMPANY                                                BS02.1
          PROCESS-LEVEL
          PLAN-GROUP
          GROUP-NAME
          PLAN-TYPE
          PLAN-CODE

BNNSET5   COMPANY                                                BN15.1
          PLAN-TYPE
          PLAN-CODE
          PROCESS-LEVEL
          GROUP-NAME
          PLAN-GROUP

                         BNNEWHIRE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bnplngroup     BNPLNGROUP   Required

                            BNN-COMPANY          -> BPG-COMPANY
                            BNN-PLAN-GROUP       -> BPG-PLAN-GROUP

Group Name     PERSGROUP    Required

                            BNN-COMPANY          -> PRG-COMPANY
                            BNN-GROUP-NAME       -> PRG-GROUP-NAME

Plan           PLAN         Required

                            BNN-COMPANY          -> PLN-COMPANY
                            BNN-PLAN-TYPE        -> PLN-PLAN-TYPE
                            BNN-PLAN-CODE        -> PLN-PLAN-CODE

Process Level  PRSYSTEM     Required

                            BNN-COMPANY          -> PRS-COMPANY
                            BNN-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Prsystem       PRSYSTEM     Required

                            BNN-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL