BNSIMHDR – Benefit Simulation
- System
- Benefits (BN)
- Prefix
BSH- Primary key
COMPANY,EMPLOYEE- Fields
- 12
- Updated by
- 4 programs
- Referenced by
- 1 program
BNSIMHDR is the Benefit Simulation table in Lawson Benefits (prefix BSH). It is indexed by COMPANY, EMPLOYEE (BSHSET1). It is related 1:1 to BNCOMPANY, PRSYSTEM, CUCODES and EMPLOYEE and 1:M to BNSIMDTL. It is updated by BN00.1, BN65.1, HR11.1 and PA115 and referenced by BN66.1. The table has 12 fields, 1 index and 5 documented relations.
About BNSIMHDR
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.
Fields (12)
Column = COBOL field name without the BSH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#BSH-COMPANY PKCOMPANY | Numeric 4 | The company number represents an established company and is entered on all function codes. | BN65.1 |
#BSH-EMPLOYEE PKEMPLOYEE | Numeric 9 | Employee number is assigned to each person employed by the company. It is used to correlate all information related to the employee. | BN65.1 |
#BSH-DATEDATE | Numeric 8 (yyyymmdd) | This field contains the date that the benefit simulation was created. | BN65.1 |
#BSH-GROSS-PAYGROSS_PAY | Signed 13.2 | This field contains the simulation gross pay. | BN65.1 |
#BSH-COMP-FLX-AMTCOMP_FLX_AMT | Signed 11.2 | This field contains the company flex credits amount. | BN65.1 |
#BSH-EMP-FLEX-AMTEMP_FLEX_AMT | Signed 11.2 | This field contains the employee flex credit amount. | BN65.1 |
#BSH-VAC-CREDITVAC_CREDIT | Signed 11.2 | This field contains the vacation credit amount. | — |
#BSH-COMP-SPENTCOMP_SPENT | Signed 11.2 | This field contains the amount of company spent dollars. | BN65.1 |
#BSH-EMP-SPENTEMP_SPENT | Signed 11.2 | This field contains the employee flex dollars spent. | BN65.1 |
#BSH-ADD-TO-GRS-PCTADD_TO_GRS_PCT | Signed 5.2 | Contains the percent of unspent flex dollars that can be added to employee taxable wages. | BN65.1 |
#BSH-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | — |
#BSH-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
BSHSET1 |
| Primary | BN00.1, BN65.1, BN65.2, BN66.1, HR11.1, PA115 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | BNCOMPANY | Required |
| |||||||
| Company Name | PRSYSTEM | Required |
| |||||||
| Currency | CUCODES | Required |
| |||||||
| Employee | EMPLOYEE | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Simulation Dtl | BNSIMDTL | Delete Restricted |
|
Programs
Updated by (4)
Referenced by (1)
- BN66.1 Estimated Pay Calculation