BNSIMDTL – Benefit Simulation Detail
- System
- Benefits (BN)
- Prefix
BSD- Primary key
COMPANY,EMPLOYEE,PLAN-TYPE,PLAN-CODE- Fields
- 11
- Updated by
- 4 programs
- Referenced by
- 24 programs
BNSIMDTL is the Benefit Simulation Detail table in Lawson Benefits (prefix BSD). It is indexed by COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE (BSDSET1). It is related 1:1 to BNCOMPANY, PRSYSTEM, EMPLOYEE, PLAN and BNSIMHDR. It is updated by BN00.1, BN65.1, HR11.1 and PA115 and referenced by BN100, BN101, BN102, BN103, BN105, BN245, BN31.1, BN31.2 and 16 more. The table has 11 fields, 1 index and 5 documented relations.
About BNSIMDTL
The Benefit Simulation Detail file contains information for simulating employee benefit deductions and pay.
Fields (11)
Column = COBOL field name without the BSD- 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 |
|---|---|---|---|
#BSD-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. | BN65.1 |
#BSD-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains the employee number. | BN65.1 |
#BSD-PLAN-TYPE PKPLAN_TYPE | Alpha 2 | Contains the plan type that identifies the type of benefit.
| BN65.1 |
#BSD-PLAN-CODE PKPLAN_CODE | Alpha 4 | Contains the user-defined code used to represent a specific benefit plan. | BN65.1 |
#BSD-DESCDESC | Alpha 30 (Lower Case) | Contains the benefit plan description. | BN65.1 |
#BSD-COV-OPTIONCOV_OPTION | Numeric 2 | This field contains the selected coverage option of the benefit plan. | BN65.1 |
#BSD-COVER-AMTCOVER_AMT | Signed 11.2 | This field contains the benefit coverage amount. | BN65.1 |
#BSD-EMP-PRE-CONTEMP_PRE_CONT | Signed 11.2 | This field contains the employee pre-tax contribution. | BN65.1, BN65.2 |
#BSD-EMP-AFT-CONTEMP_AFT_CONT | Signed 11.2 | This field contains the employee after-tax contribution. | BN65.1 |
#BSD-OPTION-COSTOPTION_COST | Signed 11.2 | Contains the total cost of the simulated benefit. | BN65.1 |
#BSD-FLEX-FLAGFLEX_FLAG | Alpha 1 | This field flags the benefit as a flex plan or a non-flex plan.
| BN65.1 |
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 |
|---|---|---|---|---|
BSDSET1 |
| Primary | BN00.1, BN100, BN101, BN102, BN103, BN105, BN245, BN31.1 +21 more |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | BNCOMPANY | Required |
| ||||||||||
| Company Name | PRSYSTEM | Required |
| ||||||||||
| Employee | EMPLOYEE | Required |
| ||||||||||
| Plan | PLAN | Required | When BSD-PLAN-CODE != Spaces |
| |||||||||
| Sim Header | BNSIMHDR | Required |
|
Programs
Updated by (4)
Referenced by (24)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN105 Plan Update
- BN245 Benefit Election Form
- BN31.1 Speed Benefit Entry
- BN31.2 Employee Benefit Entry
- BN32.1 Employee Benefit Changes
- BN32.2 Employee Benefit Detail Changes
- BN32.3 Benefit Add
- BN531 Batch Benefit Enrollment
- BN66.1 Estimated Pay Calculation
- BN71.1 COBRA Benefit Entry
- BN72.1 Retiree Benefit Entry
- BS14.1 Web Enrollment Coverage Amounts
- BS15.1 Web Enrollment Contribution Limits
- BS32.1 Web Enrollment Stop Benefits Update
- ZB10.1 Coverage Options Calculator
- ZB31.1 Speed Benefit Entry
- ZB31.2 Employee Benefit Entry
- ZB32.1 Employee Benefit Changes
- ZB32.2 Employee Benefit Detail Changes
- ZB32.3 Benefit Add