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 |
BN71.1 | BN72.1 | BN729 | BN991 | BS14.1 | BS15.1 |
BS32.1 |
BN00.1 | BN65.1 | BN65.2 | BN66.1 | HR11.1 | PA115 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
BSD-COMPANY Element: Company Hr | Numeric 4 Contains the company number. |
|
||
BSD-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. |
|
||
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 |
|
||
BSD-PLAN-CODE Element: Plan Code | Alpha 4 Contains the user-defined code used to represent a specific benefit plan. |
|
||
BSD-DESC Element: Description | Alpha 30 (Lower Case) Contains the benefit plan description. |
|
||
BSD-COV-OPTION Element: Cov Option | Numeric 2 This field contains the selected coverage option of the benefit plan. |
|
||
BSD-COVER-AMT Element: Cover Amt | Signed 11.2 This field contains the benefit coverage amount. |
|
||
BSD-EMP-PRE-CONT Element: Emp Pre Cont | Signed 11.2 This field contains the employee pre-tax contribution. |
|
||
BSD-EMP-AFT-CONT Element: Emp Aft Cont | Signed 11.2 This field contains the employee after-tax contribution. |
|
||
BSD-OPTION-COST Element: Option Cost | Signed 11.2 Contains the total cost of the simulated benefit. |
|
||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BSDSET1 |
COMPANY EMPLOYEE PLAN-TYPE PLAN-CODE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | BNCOMPANY |
Required
| |||||||||||||||
Company Name | PRSYSTEM |
Required
| |||||||||||||||
Employee | EMPLOYEE |
Required
| |||||||||||||||
Plan | PLAN |
Required
| |||||||||||||||
Sim Header | BNSIMHDR |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.