BNSIMDTL FILE
Benefit Simulation Detail
The Benefit Simulation Detail file contains information for simulating
employee benefit deductions and pay.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN245
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN531
BN66.1 BN71.1 BN72.1 BS14.1 BS15.1 BS32.1
UPDATED BY
BN00.1 BN65.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BSD-COMPANY Numeric 4 BN65.1
Element: Company Hr Contains the company number.
BSD-EMPLOYEE Numeric 9 BN65.1
Element: Employee Contains the employee number.
BSD-PLAN-TYPE Alpha 2 BN65.1
Element: Plan 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
Element: Plan Code Contains the user-defined code used to
represent a specific benefit plan.
BSD-DESC Alpha 30 (Lower Case) BN65.1
Element: Description Contains the benefit plan description.
BSD-COV-OPTION Numeric 2 BN65.1
Element: Cov Option This field contains the selected
coverage option of the benefit plan.
BSD-COVER-AMT Signed 11.2 BN65.1
Element: Cover Amt This field contains the benefit
coverage amount.
BSD-EMP-PRE-CONT Signed 11.2 BN65.1 BN65.2
Element: Emp Pre Cont This field contains the employee
pre-tax contribution.
BSD-EMP-AFT-CONT Signed 11.2 BN65.1
Element: Emp Aft Cont This field contains the employee
after-tax contribution.
BSD-OPTION-COST Signed 11.2 BN65.1
Element: Option Cost Contains the total cost of the
simulated benefit.
BSD-FLEX-FLAG Alpha 1 BN65.1
Element: Flex Flag 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 BN100
EMPLOYEE BN101 BN102
PLAN-TYPE BN103 BN105
PLAN-CODE BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN65.1
BN65.2 BN66.1
BN71.1 BN72.1
BS14.1 BS15.1
BS32.1 HR11.1
PA115
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
|
