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

BN100     BN101     BN102     BN103     BN105     BN245
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN531
BN66.1    BN71.1    BN72.1    BS14.1    BS15.1    BS32.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 Hr    Contains the company number.

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

BSD-PLAN-TYPE          Alpha 2                                   BN65.1
Element: Plan 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 Code     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: Cov Option    This field contains the selected
                       coverage option of the benefit plan.

BSD-COVER-AMT          Signed 11.2                               BN65.1
Element: Cover Amt     This field contains the benefit
                       coverage amount.

BSD-EMP-PRE-CONT       Signed 11.2                               BN65.1  BN65.2
Element: Emp Pre Cont  This field contains the employee
                       pre-tax contribution.

BSD-EMP-AFT-CONT       Signed 11.2                               BN65.1
Element: Emp Aft Cont  This field contains the employee
                       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 Flag     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  BN100
          EMPLOYEE                                               BN101   BN102
          PLAN-TYPE                                              BN103   BN105
          PLAN-CODE                                              BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN531   BN65.1
                                                                 BN65.2  BN66.1
                                                                 BN71.1  BN72.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HR11.1
                                                                 PA115

                         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