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