Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BNSIMDTL FILE

                       Benefit Simulation Detail

The Benefit Simulation Detail file contains information for simulating
employee benefit deductions and pay.

REFERENCED BY

BN66.1

UPDATED BY

BN00.1    BN65.1    HR11.1    PA115

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BSD-COMPANY          Numeric 4                                   BN65.1
Company              Contains the company number.

BSD-EMPLOYEE         Numeric 9                                   BN65.1
Employee             Contains the employee number.

BSD-PLAN-TYPE        Alpha 2                                     BN65.1
Type                 Contains the plan type that identifies
                     the type of benefit.
                     HL = Health
                     DN = Dental
                     DI = Disability
                     EL = Life
                     DL = Dependent Life
                     DC = Defined Contribution
                     DB = Defined Benefit
                     VA = Vacation
                     RS = Spending Account
                     SB = Savings Bond
                     SP = Stock Purchase

BSD-PLAN-CODE        Alpha 4                                     BN65.1
Plan                 Contains the user-defined code used to
                     represent a specific benefit plan.

BSD-DESC             Alpha 30  (Lower Case)                      BN65.1
Description          Contains the benefit plan description.

BSD-COV-OPTION       Numeric 2                                   BN65.1
Coverage Option      This field contains the selected
                     coverage option of the benefit plan.

BSD-COVER-AMT        Signed 11.2                                 BN65.1
Flat Amount          This field contains the benefit
                     coverage amount.

BSD-EMP-PRE-CONT     Signed 7.2                                  BN65.1  BN65.2
Employee Pre Tax     This field contains the employee
Contribution         pre-tax contribution.

BSD-EMP-AFT-CONT     Signed 7.2                                  BN65.1
Employee After Tax   This field contains the employee
Contrib              after-tax contribution.

BSD-OPTION-COST      Signed 11.2                                 BN65.1
Option Cost          Contains the total cost of the
                     simulated benefit.

BSD-FLEX-FLAG        Alpha 1                                     BN65.1
Flex Deduction       This field flags the benefit as a flex
                     plan or a non-flex plan.
                     Y = Yes
                     N = No

                         BNSIMDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BSDSET1   COMPANY                                                BN00.1  BN65.1
          EMPLOYEE                                               BN65.2  BN66.1
          PLAN-TYPE                                              HR11.1  PA115
          PLAN-CODE

                         BNSIMDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            BSD-COMPANY      -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            BSD-COMPANY      -> PRS-COMPANY
                            Spaces           -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            BSD-COMPANY      -> EMP-COMPANY
                            BSD-EMPLOYEE     -> EMP-EMPLOYEE

Plan           PLAN         Required
                            When BSD-PLAN-CODE != Spaces

                            BSD-COMPANY      -> PLN-COMPANY
                            BSD-PLAN-TYPE    -> PLN-PLAN-TYPE
                            BSD-PLAN-CODE    -> PLN-PLAN-CODE

Sim Header     BNSIMHDR     Required

                            BSD-COMPANY      -> BSH-COMPANY
                            BSD-EMPLOYEE     -> BSH-EMPLOYEE