Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNSIMDTL


                             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
Element: Company       Contains the company number.

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

BSD-PLAN-TYPE          Alpha 2                                   BN65.1
Element: 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
Element: Plan          Contains the user-defined code used to
                       represent a specific benefit plan.

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

BSD-COV-OPTION         Numeric 2                                 BN65.1
Element: Coverage OptioThis field contains the selected
                       coverage option of the benefit plan.

BSD-COVER-AMT          Signed 11.2                               BN65.1
Element: 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
Element: Option Cost   Contains the total cost of the
                       simulated benefit.

BSD-FLEX-FLAG          Alpha 1                                   BN65.1
Element: Flex DeductionThis 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