BENEFIT

Employee Benefit

The Employee Benefit file contains information about the employee's benefits, including employee and company contribution amounts for the benefit.

REFERENCED BY
BN00.1 BN106 BN238 BN258 BN321 BN335
BN36.1 BN53.1 BN532 HR13.1 HR13.2 HR13.3
HR13.4 HR513 LP34.1 PA218 ZP567 BN02.1
BN02.2 BN02.3 BN02.4 BN02.5 BN04.1 BN141
BN15.1 BN150 BN16.1 BN16.2 BN16.3 BN16.4
BN17.1 BN17.2 BN17.3 BN18.1 BN18.2 BN18.3
BN18.4 BN18.5 BN18.6 BN18.7 BN19.1 BN19.2
BN19.3 BN19.4 BN20.1 BN230 BN236 BN237
BN240 BN330 BN345 BN350 BN50.1 BN55.2
BN55.1 BN555 BN556 BN56.1 ZH230 PR39.1
PR39.5 PR539 PR80.3 BN231 BN242 BN246
BN305 HR11.1 HR11.2 HR11.4 HR170 HR28.1
HR511 HR70.1 LT101 LT111 ZH500 ZH510
ZH568 PA02.1 PA100 PA102 PA115 PA13.1
PA13.2 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PR110 PR113 PR12.6 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR30.2 PR512
ZP551 ZP552 ZP555 ZP560 ZP562 ZP565
BN325 BN46.2 BN47.1 BN51.1 BN51.2 BN547
BN59.1 BN59.2 BN59.3 BN60.1 BN60.2 BN61.1
BN61.2 BN90.1


UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN140 BN145 BN232 BN245 BN260 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN320 BN331
BN340 BN430 BN45.1 BN531 BN65.1 BN71.1
BN72.1 BS10.1 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 ZB01.1 ZB10.1 ZB10.2 ZB31.1 ZB31.2
ZB32.1 ZB32.2 ZB32.3 LP138 PR197 PR797

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BEN-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN430
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB01.1
ZB10.1 ZB10.2
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-PLAN-TYPE
Element: Plan Type
Alpha 2
Contains the benefit type.
HL = Health
DN = Dental
DI = Disability
EL = Employee Life
DL = Dependent Life
DC = Defined Contribution
DB = Defined Benefit
VA = Vacation
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN430
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB01.1
ZB10.1 ZB10.2
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number.
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN430
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB01.1
ZB10.1 ZB10.2
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 ZP567
BEN-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Contains the effective date of the benefit.
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN430
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB01.1
ZB10.1 ZB10.2
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 ZP567
BEN-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the user-defined code representing a specific plan.
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN430
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB01.1
ZB10.1 ZB10.2
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 ZP567
BEN-FLEX-PLAN
Element: Flex Plan
Alpha 4
Identifies the flex plan associated with this benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-STOP-DATE
Element: Stop Date
Numeric 8 (yyyymmdd)
Identifies the ending effective date for the benefit.
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS10.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
ZB01.1 ZB10.1
ZB10.2 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
ZP551 ZP567
BEN-PLAN-OPTION
Element: Plan Option
Numeric 2
Contains the plan category.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-COV-OPTION
Element: Cov Option
Numeric 2
Contains the selected coverage option for this benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
ZP567
BEN-CMP-FLX-CONT
Element: Cmp Flx Cont4
Signed 13.4
Contains the company's annual flex contribution to the benefit.
BN100 BN101
BN102 BN103
BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-EMP-PRE-CONT
Element: Emp Pre Cont4
Signed 13.4
Contains the employee's annual pre-tax contribution for the benefit.
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS10.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
ZB01.1 ZB10.1
ZB10.2 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-EMP-AFT-CONT
Element: Emp Aft Cont4
Signed 13.4
Contains the employee's annual after-tax contribution for the benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-COMP-CONT
Element: Comp Cont4
Signed 13.4
Contains the company's annual dollar contribution for the benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-PREM-UPD-DT
Element: Prem Upd Dt
Numeric 8 (yyyymmdd)
Contains the start date of the contribution record used for this benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-ELIG-UPD-DT
Element: Elig Upd Dt
Numeric 8 (yyyymmdd)
Contains the start date of the eligibility record used for this benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-COV-UPD-DT
Element: Cov Upd Dt
Numeric 8 (yyyymmdd)
Contains the start date of the coverage record used for this benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-GL-UPD-DT
Element: Gl Upd Dt
Numeric 8 (yyyymmdd)
Contains the start date of the general ledger override record used for this benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-PAY-RATE
Element: Pay Rate
Signed 13.4
Contains the employee's salary used to calculate coverage for the benefit.
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS10.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
ZB01.1 ZB10.1
ZB10.2 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-COVER-AMT
Element: Cover Amt
Signed 11.2
Contains the coverage amount associated with the benefit.
BN100 BN101
BN102 BN103
BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-DEP-COVER-AMT
Element: Dep Cover Amt
Signed 11.2
Contains the dependent's coverage amount associated with the benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-PCT-AMT-FLAG
Element: Pct Amt Flag
Alpha 1
Identifies if the contribution amount is a percent or flat amount.
A = Amount
P = Percent
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS10.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-NBR-HOURS
Element: Nbr Hours
Signed 6.3
Contains the number of hours of vacation the employee has purchased or sold under a flex plan for the current year.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-BOND-DED-AMT
Element: Bond Ded Amt
Signed 11.2
Identifies the pay period contribution amount.
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-NBR-PURCH
Element: Nbr Purch
Numeric 3
Contains the number of bonds purchased by the employee.
BEN-YTD-CONT
Element: Ytd Cont
Signed 13.2
Contains the year-to-date contribution amount.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
PR197 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-CMP-SEQ-NBR
Element: Cmp Seq Nbr
Numeric 4
Contains the sequence number that allows the tie to the employee deduction master file for the company deduction.
BN100 BN101
BN102 BN103
BN105 BN145
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB01.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-CMP-AFT-SEQ
Element: Cmp Aft Seq
Numeric 4
Contains the sequence number that ties the benefit deduction to the employee deduction master containing the company matched after tax deduction.
BN100 BN101
BN102 BN103
BN105 BN145
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-PRE-SEQ-NBR
Element: Pre Seq Nbr
Numeric 4
Contains the sequence number that ties the benefit to the employee deduction master and to the employee pre-tax deduction amount.
BN100 BN101
BN102 BN103
BN105 BN145
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB01.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-AFT-SEQ-NBR
Element: Aft Seq Nbr
Numeric 4
Identifies the after-tax sequence number that ties the benefit to the employee after tax deduction in the employee deduction master.
BN100 BN101
BN102 BN103
BN105 BN145
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-FLEX-DED-SEQ
Element: Flex Ded Seq
Numeric 4
Contains the sequence number used to tie the benefit to the employee flex company deduction in the employee deduction master.
BN100 BN101
BN102 BN103
BN105 BN145
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-STM-SEQ-NBR
Element: Stm Seq Nbr
Numeric 4
Contains the sequence number that ties the benefit to the employee's standard time record in the employee standard time record file.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-TA-UPD-FLAG
Element: Ta Upd Flag
Alpha 1
Used by BN138 (Vacation Hours Update) to indicate the hours have been updated to the Time Accrual plan.
LP138
BEN-COV-OVER-FLG
Element: Cov Over Flg
Alpha 1
Contains a flag that identifies if the coverage amount has been overridden and should not be recalculated when running BN100 (Employee Change Benefit Update) or BN102 (Plan Employee Update).
" " = No
Y = Yes
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-TAKEN-FLAG
Element: Taken Flag
Alpha 1
Indicates the benefit deduction has been taken at least once This field also does not allow the benefit to be deleted.
BEN-CYCLES-REMAIN
Element: Cycles Remain
Numeric 2
Contains the number of payroll cycles in which the deduction is taken.
BN100 BN101
BN102 BN103
BN104 BN105
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-YTD-FLEX-CONT
Element: Ytd Flex Cont
Signed 13.2
Contains an employee's year to date contribution amount.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
PR197 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-ELIG-GROUP
Element: Elig Group
Alpha 10
Contains the employee group name of the eligibility record used for this benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-COV-GROUP
Element: Cov Group
Alpha 10
Contains the coverage group name of the coverage record used for this benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-PREM-GROUP
Element: Prem Group
Alpha 10
Contains the employee group name of the premium record used for this benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-GL-GROUP
Element: Gl Group
Alpha 10
Contains the employee group name of the gl override record used for this benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-MULTIPLE
Element: Multiple
Signed 6.3
Contains the multiple of salary elected by employee.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-ANNUAL-AMT
Element: Annual Amt4
Signed 11.4
Contains the annual contribution amount.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-SMOKER
Element: Smoker
Alpha 1
Indicates whether rates are used to calculate contributions.
Y = Yes
N = No
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
Indicates the date the benefit was added to the system.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-UPD-DATE
Element: Upd Date
Numeric 8 (yyyymmdd)
Contains the last date the benefit was updated.
BN100 BN101
BN102 BN103
BN104 BN105
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1 PR797
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-LAST-SEQ-PURCH
Element: Last Seq Purch
Numeric 2
Contains the last bond sequence number used to purchase a savings bond.
BN140
BEN-COV-SAL-DATE
Element: Cov Sal Date
Numeric 8 (yyyymmdd)
Contains the date used to determine the salary for coverage calculations.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-COV-AGE-DATE
Element: Cov Age Date
Numeric 8 (yyyymmdd)
Contains the date used to determine the age for contribution calculations.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-CNT-SAL-DATE
Element: Cnt Sal Date
Numeric 8 (yyyymmdd)
Contains the date used to determine salary for contribution calculations.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-CNT-AGE-DATE
Element: Cnt Age Date
Numeric 8 (yyyymmdd)
Contains the date used to determine the age for contribution calculations.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-CNT-SERV-DATE
Element: Cnt Serv Date
Numeric 8 (yyyymmdd)
Contains the date used to determine the years of service for contribution calculations.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-EFD-START-DATE
Element: Efd Start Date
Numeric 8 (yyyymmdd)
Contains the date of employee flex dollars record used to calculate flex contributions.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-PRE-AFT-FLAG
Element: Pre Aft Flag
Alpha 1
Contains the type of employee contribution for the benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-PEND-EVIDENCE
Element: Pend Evidence
Alpha 1
Indicates the status of evidence of insurability.
A = Approved
P = Pending
N = No
" "
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-EMP-CONTRIB
Element: Emp Contrib
Derived
Contains the employee contributions. The calculation is: Emp-Pre-Cont + Emp-Aft-Cont
BEN-COMP-CONTRIB
Element: Comp Contrib
Derived
Contains the company contribution. The calculation is: Comp Cont + Cmp Flx Cont
BEN-TOT-CONTRIB
Element: Tot Contrib
Derived
Contains the total contribution. The calculation is: ((Comp Cont + Comp Flx Cnt) + Emp Pre Cont) + Emp Aft Cont
BEN-WK-EMP-CONT
Element: Wk Emp Cont
Derived
Contains the weekly employee contribution. The calculation is: Emp Contrib / 52.000000
BEN-BI-EMP-CONT
Element: Bi Emp Cont
Derived
Contains the bi-weekly employee contribution. The calculation is: Emp Contrib / 26
BEN-SM-EMP-CONT
Element: Sm Emp Cont
Derived
Contains the semi-monthly employee contribution. The calculation is: Emp Contrib / 24
BEN-MO-EMP-CONT
Element: Mo Emp Cont
Derived
Contains the monthly employee contribution. The calculation is: Emp Contrib / 12
BEN-EMP-PER-AMT
Element: Emp Per Amt
Derived
Contains the employee pay period amount. The calculation is: If (weekly) Wk Emp Cont Else If (Bi Weekly) Bi Emp Cont Else If (Semi Monthly) Sm Emp Cont Else Mo Emp Cont
BEN-MO-COMP-CONT
Element: Mo Comp Cont
Derived
Contains the monthly company contribution. The calculation is: Comp Cont / 12
BEN-MO-COMP-FLX
Element: Mo Comp Flx
Derived
Contains the monthly company flex contribution. Comp Flx Cont / 12
BEN-MO-EMP-PRE
Element: Mo Emp Pre
Derived
Contains the monthly employee pretax contribution. The calculation is: Emp Pre Cont / 12
BEN-MO-EMP-AFT
Element: Mo Emp Aft
Derived
Contains the monthly employee after-tax contribution. The calculation is: Empl Aft Cont / 12
BEN-MO-DIS-COVER
Element: Mo Dis Cover
Derived
Contains the The calculation is: Cover Amt / 12
BEN-PLAN-TYPE-2
Element: Plan Type 2
Derived
Contains the plan type.
BEN-SECCLASS
Element: Secclass
Derived
This field is not used.
BEN-COMP-MATCH
Element: Comp Match
Signed 5.2
Contains the percent of the company match.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-MTCH-UP-TO
Element: Mtch Up To
Signed 5.2
Contains the percent of the employee contribution that the company will match.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-SOURCE
Element: Source
Alpha 1
The source of the transaction. Input or output. Input transactions are Accounts Payable. Output transactions are Accounts Receivable.
I = Interactive Voice Response
K = KIOSK
W = Web
BEN-VACATION-COST
Element: Vacation Cost
Derived
Contains the vacation cost. The calculation is: ((Comp Flx Cont + Emp Pre Cont) + Empl Aft Cont) / Nbr Hours
BEN-FLEX-PT
Element: Flex Pt
Derived
BEN-FLEX-PT-AT
Element: Flex Pt At
Derived
BEN-PT-AT
Element: Pt At
Derived
BEN-FLEX-PT-AT-CMP
Element: Flex Pt At Cmp
Derived
BEN-PT-AT-CMP
Element: Pt At Cmp
Derived
BEN-WK-FLEX-PT
Element: Wk Flex Pt
Derived
BEN-BI-FLEX-PT
Element: Bi Flex Pt
Derived
BEN-SM-FLEX-PT
Element: Sm Flex Pt
Derived
BEN-MO-FLEX-PT
Element: Mo Flex Pt
Derived
BEN-WK-FLEX-PT-AT
Element: Wk Flex Pt At
Derived
BEN-BI-FLEX-PT-AT
Element: Bi Flex Pt At
Derived
BEN-SM-FLEX-PT-AT
Element: Sm Flex Pt At
Derived
BEN-MO-FLEX-PT-AT
Element: Mo Flex Pt At
Derived
BEN-PP-FLEX-PT
Element: Pp Flex Pt
Derived
BEN-PP-FLEX-PT-AT
Element: Pp Flex Pt At
Derived
BEN-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-USER-ID
Element: User
Alpha 10 (Lower Case)
BN100 BN101
BN102 BN103
BN104 BN105
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1 PR797
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN100 BN101
BN102 BN103
BN104 BN105
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1 PR797
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-TRAN-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
BEN-TA-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-CO-PCT-AMT
Element: Pct Amt Flag
Alpha 1

A = Amount
P = Percent
BEN-EMP-YTD-CONT
Element: Ytd Cont
Signed 13.2
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN65.1
BS32.1 PR197
PR797 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BEN-DED-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-DED-STOP-DATE
Element: Stop Date
Numeric 8 (yyyymmdd)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BEN-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3


BENEFIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BENSET1 COMPANY
PLAN-TYPE
EMPLOYEE
START-DATE
PLAN-CODE
...
BN00.1 BN100
BN101 BN102
BN103 BN104
BN105 BN106
BN145 BN232
BN238 BN245
BN258 BN260
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN321 BN331
BN335 BN340
BN36.1 BN430
BN45.1 BN53.1
BN531 BN532
BENSET2 COMPANY
PLAN-TYPE
PLAN-CODE
EMPLOYEE
START-DATE*
...
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5 BN04.1
BN102 BN103
BN104 BN105
BN106 BN140
BN141 BN15.1
BN150 BN16.1
BN16.2 BN16.3
BN16.4 BN17.1
BN17.2 BN17.3
BN18.1 BN18.2
BN18.3 BN18.4
BN18.5 BN18.6
BN18.7 BN19.1
BENSET3 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
START-DATE*
...
BN100 BN101
BN102 BN103
BN105 BN145
BN231 BN232
BN240 BN242
BN245 BN246
BN260 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN340
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BENSET4 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
START-DATE
...
BN100 BN101
BN102 BN103
BN105 BN106
BN145 BN245
BN260 BN31.1
BN31.2 BN31.4
BN31.5 BN32.1
BN32.2 BN32.3
BN325 BN331
BN335 BN340
BN45.1 BN46.2
BN47.1 BN51.1
BN51.2 BN531
BN532 BN547
BN55.1 BN55.2
BENSET5 COMPANY
PLAN-TYPE
PLAN-CODE
PREM-UPD-DT
PREM-GROUP
EMPLOYEE
START-DATE
KeyChange
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
BENSET6 COMPANY
PLAN-TYPE
PLAN-CODE
START-DATE
EMPLOYEE
BN02.5 BN15.1
BN16.1 BN16.2
BN16.3 BN16.4
BN17.1
BENSET7 COMPANY
EMPLOYEE
EFD-START-DATE
PLAN-TYPE
PLAN-CODE
START-DATE
BN100 BN102
BN103
BENSET8 COMPANY
EMPLOYEE
PLAN-OPTION
PLAN-TYPE
PLAN-CODE
START-DATE
BN100 BN101


BENEFIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Aft Ded Code A EMDEDMASTR Required
When BEN-AFT-SEQ-NBR !=Zeroes
AndBEN-PCT-AMT-FLAG ="A"
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-AFT-DED-CODE-A->EDM-DED-CODE
BEN-AFT-SEQ-NBR->EDM-SEQ-NBR
Aft Ded Code P EMDEDMASTR Required
When BEN-AFT-SEQ-NBR !=Zeroes
AndBEN-PCT-AMT-FLAG !="A"
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-AFT-DED-CODE-P->EDM-DED-CODE
BEN-AFT-SEQ-NBR->EDM-SEQ-NBR
Aft Ded Mtch A EMDEDMASTR Required
When BEN-CMP-AFT-SEQ !=Zeroes
AndBEN-PCT-AMT-FLAG ="A"
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-AFT-DED-MTCH-A->EDM-DED-CODE
BEN-CMP-AFT-SEQ->EDM-SEQ-NBR
Aft Ded Mtch P EMDEDMASTR Required
When BEN-CMP-AFT-SEQ !=Zeroes
AndBEN-PCT-AMT-FLAG ="P"
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-AFT-DED-MTCH-P->EDM-DED-CODE
BEN-CMP-AFT-SEQ->EDM-SEQ-NBR
Bncovopt BNCOVOPT Required
When PLN-COVERAGE-TYPE ="1"
BEN-COMPANY->COP-COMPANY
BEN-PLAN-TYPE->COP-PLAN-TYPE
BEN-PLAN-CODE->COP-PLAN-CODE
BEN-COV-OPTION->COP-COVERAGE-OPT
Cmp Ded Code A EMDEDMASTR Required
When BEN-CMP-SEQ-NBR !=Zeroes
AndBEN-PCT-AMT-FLAG ="A"
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-CMP-DED-CODE-A->EDM-DED-CODE
BEN-CMP-SEQ-NBR->EDM-SEQ-NBR
Cmp Ded Code P EMDEDMASTR Required
When BEN-CMP-SEQ-NBR !=Zeroes
AndBEN-PCT-AMT-FLAG !="A"
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-CMP-DED-CODE-P->EDM-DED-CODE
BEN-CMP-SEQ-NBR->EDM-SEQ-NBR
Company BNCOMPANY Required
BEN-COMPANY->BNC-COMPANY
Company Name PRSYSTEM Required
BEN-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Cont Group PERSGROUP Not Required
BEN-COMPANY->PRG-COMPANY
BEN-PREM-GROUP->PRG-GROUP-NAME
Contrib 0 PLAN Required
When PLN-CONTRIB-TYPE ="0"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Contrib 1 PLAN Required
When PLN-CONTRIB-TYPE ="1"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Contrib 2 PLAN Required
When PLN-CONTRIB-TYPE ="2"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Contrib 3 PLAN Required
When PLN-CONTRIB-TYPE ="3"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Contrib 4 PLAN Required
When PLN-CONTRIB-TYPE ="4"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Contrib 5 PLAN Required
When PLN-CONTRIB-TYPE ="5"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Contrib 6 PLAN Required
When PLN-CONTRIB-TYPE ="6"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Contrib 7 PLAN Required
When PLN-CONTRIB-TYPE ="7"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Cov Group PERSGROUP Not Required
BEN-COMPANY->PRG-COMPANY
BEN-COV-GROUP->PRG-GROUP-NAME
Coverage 0 PLAN Required
When PLN-COVERAGE-TYPE ="0"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Coverage 1 PLAN Required
When PLN-COVERAGE-TYPE ="1"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Coverage 2 PLAN Required
When PLN-COVERAGE-TYPE ="2"
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Currency CUCODES Required
BEN-CURRENCY-CODE->CUC-CURRENCY-CODE
Elig Group PERSGROUP Not Required
BEN-COMPANY->PRG-COMPANY
BEN-ELIG-GROUP->PRG-GROUP-NAME
Emp Flex Ded EMDEDMASTR Required
When BEN-FLEX-DED-SEQ !=Zeroes
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-FLEX-DED-CODE->EDM-DED-CODE
BEN-FLEX-DED-SEQ->EDM-SEQ-NBR
Employee EMPLOYEE Required
BEN-COMPANY->EMP-COMPANY
BEN-EMPLOYEE->EMP-EMPLOYEE
Flex Plan FLEXPLAN Required
When BEN-FLEX-PLAN !=Spaces
BEN-COMPANY->FLP-COMPANY
BEN-FLEX-PLAN->FLP-FLEX-PLAN
Gl Group PERSGROUP Not Required
BEN-COMPANY->PRG-COMPANY
BEN-GL-GROUP->PRG-GROUP-NAME
Pa Employee PAEMPLOYEE Required
BEN-COMPANY->PEM-COMPANY
BEN-EMPLOYEE->PEM-EMPLOYEE
Plan PLAN Required
BEN-COMPANY->PLN-COMPANY
BEN-PLAN-TYPE->PLN-PLAN-TYPE
BEN-PLAN-CODE->PLN-PLAN-CODE
Pre Ded Code A EMDEDMASTR Required
When BEN-PRE-SEQ-NBR !=Zeroes
AndBEN-PCT-AMT-FLAG ="A"
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-PRE-DED-CODE-A->EDM-DED-CODE
BEN-PRE-SEQ-NBR->EDM-SEQ-NBR
Pre Ded Code P EMDEDMASTR Required
When BEN-PRE-SEQ-NBR !=Zeroes
AndBEN-PCT-AMT-FLAG !="A"
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-PRE-DED-CODE-P->EDM-DED-CODE
BEN-PRE-SEQ-NBR->EDM-SEQ-NBR
Pre Ded Mtch A EMDEDMASTR Required
When BEN-CMP-SEQ-NBR !=Zeroes
AndBEN-PCT-AMT-FLAG ="A"
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-PRE-DED-MTCH-A->EDM-DED-CODE
BEN-CMP-SEQ-NBR->EDM-SEQ-NBR
Pre Ded Mtch P EMDEDMASTR Required
When BEN-CMP-SEQ-NBR !=Zeroes
AndBEN-PCT-AMT-FLAG ="P"
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
PLN-PRE-DED-MTCH-P->EDM-DED-CODE
BEN-CMP-SEQ-NBR->EDM-SEQ-NBR
Standtime STANDTIME Not Required
BEN-COMPANY->STM-COMPANY
BEN-EMPLOYEE->STM-EMPLOYEE
Spaces->STM-TIME-GROUP
PLN-FLEX-PAY-CODE->STM-PAY-CODE
BEN-STM-SEQ-NBR->STM-SEQ-NBR


BENEFIT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Beneficiaries BENEFICRY Delete Restricted
BEN-COMPANY->BNF-COMPANY
BEN-EMPLOYEE->BNF-EMPLOYEE
BEN-PLAN-TYPE->BNF-PLAN-TYPE
BEN-PLAN-CODE->BNF-PLAN-CODE
  BNF-SEQ-NBR
Bn Ta Employee BNTAEMPBAL
BEN-COMPANY->BTE-COMPANY
BEN-PLAN-CODE->BTE-PLAN-CODE
BEN-EMPLOYEE->BTE-EMPLOYEE
BEN-START-DATE->BTE-START-DATE
  BTE-EMPLOYEE-GROUP
  BTE-POSITION
Bond Beneficry BONDBENIF Delete Restricted
BEN-COMPANY->BON-COMPANY
BEN-EMPLOYEE->BON-EMPLOYEE
BEN-PLAN-CODE->BON-PLAN-CODE
BEN-START-DATE->BON-START-DATE
  BON-BOND-NBR
Coda Account CODA Delete Restricted
BEN-COMPANY->COD-COMPANY
BEN-EMPLOYEE->COD-EMPLOYEE
BEN-PLAN-TYPE->COD-PLAN-TYPE
BEN-PLAN-CODE->COD-PLAN-CODE
  COD-PLAN-YEAR
  COD-PROCESS-LEVEL
  COD-BUS-NBR-GRP
  COD-QC-ENT-NBR-GRP
Comphist COMPHIST Delete Restricted
BEN-COMPANY->CPH-COMPANY
BEN-EMPLOYEE->CPH-EMPLOYEE
BEN-PLAN-TYPE->CPH-PLAN-TYPE
BEN-PLAN-CODE->CPH-PLAN-CODE
  CPH-PLAN-YEAR
Deductions EMDEDMASTR
BEN-COMPANY->EDM-COMPANY
BEN-EMPLOYEE->EDM-EMPLOYEE
  EDM-DED-CODE
  EDM-SEQ-NBR
Dependents HRDEPBEN Delete Restricted
BEN-COMPANY->HDB-COMPANY
BEN-EMPLOYEE->HDB-EMPLOYEE
BEN-PLAN-TYPE->HDB-PLAN-TYPE
BEN-PLAN-CODE->HDB-PLAN-CODE
BEN-START-DATE->HDB-EMP-START
  HDB-DEPENDENT
  HDB-START-DATE
Emp Comments BNCOMMENTS
BEN-COMPANY->BCM-COMPANY
"EM"->BCM-CMT-TYPE
BEN-EMPLOYEE->BCM-EMPLOYEE
Zeroes->BCM-PARTICIPNT
BEN-PLAN-TYPE->BCM-PLAN-TYPE
BEN-PLAN-CODE->BCM-PLAN-CODE
Spaces->BCM-GROUP-NAME
BEN-START-DATE->BCM-START-DATE
  BCM-SEQ-NBR
Invest Distrib EMPINVEST Delete Cascades
BEN-COMPANY->EMI-COMPANY
BEN-EMPLOYEE->EMI-EMPLOYEE
BEN-PLAN-CODE->EMI-PLAN-CODE
BEN-START-DATE->EMI-START-DATE
  EMI-SEQ-NBR
  EMI-DIST-ST-DATE
Res Acct Trans RESTRANS Delete Restricted
BEN-COMPANY->RTR-COMPANY
BEN-EMPLOYEE->RTR-EMPLOYEE
BEN-PLAN-CODE->RTR-PLAN-CODE
BEN-START-DATE->RTR-START-DATE
  RTR-DATE
  RTR-CHECK-NBR
Stock Purchase SPHIST Delete Restricted
BEN-COMPANY->SPH-COMPANY
BEN-EMPLOYEE->SPH-EMPLOYEE
BEN-PLAN-CODE->SPH-PLAN-CODE
BEN-START-DATE->SPH-START-DATE
  SPH-DATE-PURCH
Vesting Hours VESTHOURS Delete Restricted
BEN-COMPANY->VES-COMPANY
BEN-EMPLOYEE->VES-EMPLOYEE
BEN-PLAN-TYPE->VES-PLAN-TYPE
BEN-PLAN-CODE->VES-PLAN-CODE
  VES-PLAN-YEAR


File created: Thu Jun 09 02:09:52 2016

Home
Contact Us



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