Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNSIMHDR


                             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    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

BSH-EMPLOYEE           Numeric 9                                 BN65.1
Element: 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
Element: Date          This field contains the date that the
                       benefit simulation was created.

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

BSH-COMP-FLX-AMT       Signed 11.2                               BN65.1
Element: Comp Flx Amt  This field contains the company flex
                       credits amount.

BSH-EMP-FLEX-AMT       Signed 11.2                               BN65.1
Element: Emp Flex Amt  This field contains the employee flex
                       credit amount.

BSH-VAC-CREDIT         Signed 11.2
Element: Vac Credit    This field contains the vacation credit
                       amount.

BSH-COMP-SPENT         Signed 11.2                               BN65.1
Element: Comp Spent    This field contains the amount of
                       company spent dollars.

BSH-EMP-SPENT          Signed 11.2                               BN65.1
Element: Emp Spent     This field contains the employee flex
                       dollars spent.

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

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

BSH-CURR-ND            Numeric 1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


                         BNSIMHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

                         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