Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BNSIMHDR FILE

                           Benefit Simulation

The Benefit Simulation Header file contains information for simulating
employee benefit deductions and pay. This file stores employee taxable pay,
employee contribution amounts, and company contribution amounts.

BN66.1 (Estimated Pay Calculation) is the primary program that updates this
file.

REFERENCED BY

BN66.1

UPDATED BY

BN00.1    BN65.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BSH-COMPANY          Numeric 4                                   BN65.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

BSH-EMPLOYEE         Numeric 9                                   BN65.1
Employee             Employee number is assigned to each
                     person employed by the company.  It is
                     used to correlate all information
                     related to the employee.

BSH-DATE             Numeric 8  (yyyymmdd)                       BN65.1
Date                 This field contains the date that the
                     benefit simulation was created.

BSH-GROSS-PAY        Signed 13.2                                 BN65.1
Gross Pay            This field contains the simulation
                     gross pay.

BSH-COMP-FLX-AMT     Signed 11.2                                 BN65.1
Company Paid Flex    This field contains the company flex
Dollar Amt           credits amount.

BSH-EMP-FLEX-AMT     Signed 11.2                                 BN65.1
Employee Flex        This field contains the employee flex
Dollar Amount        credit amount.

BSH-VAC-CREDIT       Signed 11.2
Vacation Credit      This field contains the vacation credit
                     amount.

BSH-COMP-SPENT       Signed 11.2                                 BN65.1
Flex Dollars Spent   This field contains the amount of
                     company spent dollars.

BSH-EMP-SPENT        Signed 11.2                                 BN65.1
Employee Pre-tax     This field contains the employee flex
Dollars Spent        dollars spent.

BSH-ADD-TO-GRS-PCT   Signed 5.2                                  BN65.1
Add To Grs Pct       Contains the percent of unspent flex
                     dollars that can be added to employee
                     taxable wages.

BSH-CURRENCY-CODE    Alpha 5
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).

BSH-CURR-ND          Numeric 1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

                         BNSIMHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BSHSET1   COMPANY                                                BN00.1  BN65.1
          EMPLOYEE                                               BN65.2  BN66.1

                         BNSIMHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            BSH-COMPANY          -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            BSH-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required

                            BSH-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required

                            BSH-COMPANY          -> EMP-COMPANY
                            BSH-EMPLOYEE         -> EMP-EMPLOYEE

                         BNSIMHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Simulation Dtl BNSIMDTL     Delete Restricted

                            BSH-COMPANY          -> BSD-COMPANY
                            BSH-EMPLOYEE         -> BSD-EMPLOYEE
                                                    BSD-PLAN-TYPE
                                                    BSD-PLAN-CODE