BNSIMDTL FILE
Benefit Simulation Detail
The Benefit Simulation Detail file contains information for simulating
employee benefit deductions and pay.
REFERENCED BY
BN66.1
UPDATED BY
BN00.1 BN65.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BSD-COMPANY Numeric 4 BN65.1
Company Contains the company number.
BSD-EMPLOYEE Numeric 9 BN65.1
Employee Contains the employee number.
BSD-PLAN-TYPE Alpha 2 BN65.1
Type Contains the plan type that identifies
the type of benefit.
HL = Health
DN = Dental
DI = Disability
EL = Life
DL = Dependent Life
DC = Defined Contribution
DB = Defined Benefit
VA = Vacation
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
BSD-PLAN-CODE Alpha 4 BN65.1
Plan Contains the user-defined code used to
represent a specific benefit plan.
BSD-DESC Alpha 30 (Lower Case) BN65.1
Description Contains the benefit plan description.
BSD-COV-OPTION Numeric 2 BN65.1
Coverage Option This field contains the selected
coverage option of the benefit plan.
BSD-COVER-AMT Signed 11.2 BN65.1
Flat Amount This field contains the benefit
coverage amount.
BSD-EMP-PRE-CONT Signed 7.2 BN65.1 BN65.2
Employee Pre Tax This field contains the employee
Contribution pre-tax contribution.
BSD-EMP-AFT-CONT Signed 7.2 BN65.1
Employee After Tax This field contains the employee
Contrib after-tax contribution.
BSD-OPTION-COST Signed 11.2 BN65.1
Option Cost Contains the total cost of the
simulated benefit.
BSD-FLEX-FLAG Alpha 1 BN65.1
Flex Deduction This field flags the benefit as a flex
plan or a non-flex plan.
Y = Yes
N = No
BNSIMDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSDSET1 COMPANY BN00.1 BN65.1
EMPLOYEE BN65.2 BN66.1
PLAN-TYPE
PLAN-CODE
BNSIMDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
BSD-COMPANY -> BNC-COMPANY
Company Name PRSYSTEM Required
BSD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
BSD-COMPANY -> EMP-COMPANY
BSD-EMPLOYEE -> EMP-EMPLOYEE
Plan PLAN Required
When BSD-PLAN-CODE != Spaces
BSD-COMPANY -> PLN-COMPANY
BSD-PLAN-TYPE -> PLN-PLAN-TYPE
BSD-PLAN-CODE -> PLN-PLAN-CODE
Sim Header BNSIMHDR Required
BSD-COMPANY -> BSH-COMPANY
BSD-EMPLOYEE -> BSH-EMPLOYEE
|
