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.

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
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
Element: Vacation CrediThis field contains the vacation credit
                       amount.

BSH-COMP-SPENT         Signed 11.2                               BN65.1
Element: Flex Dollars SThis 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
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
Account Currency       Represents the number of decimals
Code                   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  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