BNSIMDTL

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
ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3


UPDATED BY
BN00.1 BN65.1 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BSD-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
BN65.1
BSD-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number.
BN65.1
BSD-PLAN-TYPE
Element: Plan Type
Alpha 2
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
BN65.1
BSD-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the user-defined code used to represent a specific benefit plan.
BN65.1
BSD-DESC
Element: Description
Alpha 30 (Lower Case)
Contains the benefit plan description.
BN65.1
BSD-COV-OPTION
Element: Cov Option
Numeric 2
This field contains the selected coverage option of the benefit plan.
BN65.1
BSD-COVER-AMT
Element: Cover Amt
Signed 11.2
This field contains the benefit coverage amount.
BN65.1
BSD-EMP-PRE-CONT
Element: Emp Pre Cont
Signed 11.2
This field contains the employee pre-tax contribution.
BN65.1 BN65.2
BSD-EMP-AFT-CONT
Element: Emp Aft Cont
Signed 11.2
This field contains the employee after-tax contribution.
BN65.1
BSD-OPTION-COST
Element: Option Cost
Signed 11.2
Contains the total cost of the simulated benefit.
BN65.1
BSD-FLEX-FLAG
Element: Flex Flag
Alpha 1
This field flags the benefit as a flex plan or a non-flex plan.
Y = Yes
N = No
BN65.1


BNSIMDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSDSET1 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
BN00.1 BN100
BN101 BN102
BN103 BN105
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 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 HR11.1
PA115


BNSIMDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:10:03 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.