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
BN53.1


UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN138 BN140 BN145 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN430 BN45.1 BN531 BS32.1
LP138 PR197 PR797 BN00.1 BN106 BN238
BN249 BN258 BN29.2 BN320 BN321 BN331
BN335 BN36.1 BN532 BN71.1 BN72.1 BN729
BN990 XB500 XB510 XB520 XB706 HR13.1
HR13.2 HR13.3 HR13.4 HR513 LP34.1 PA218
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 PR39.1
PR39.5 PR539 PR80.3 BN231 BN232 BN242
BN245 BN246 BN305 BN340 BN65.1 BN991
BS10.1 BS12.1 BS13.1 BS14.1 BS15.1 HR11.1
HR11.2 HR170 HR511 HR70.1 PA02.1 PA100
PA102 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR13.9
XR901 BN325 BN46.2 BN47.1 BN51.1 BN51.2
BN547 BN59.1 BN59.3 BN60.1 BN61.1 BN90.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BEN-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN531
BS32.1
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 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN531
BS32.1
BEN-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN531
BS32.1
BEN-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the effective date of the benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN531
BS32.1
BEN-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code representing a specific plan.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN531
BS32.1
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
BEN-STOP-DATE
Element: Stop Date		Numeric 8 (yyyymmdd)
Identifies the ending effective date for the benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
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
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
BEN-CMP-FLX-CONT
Element: Cmp Flx Cont		Signed 11.2
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
BEN-EMP-PRE-CONT
Element: Emp Pre Cont		Signed 11.2
Contains the employee's annual pre-tax contribution for the benefit.
BN100 BN101
BN102 BN103
BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
BEN-EMP-AFT-CONT
Element: Emp Aft Cont		Signed 11.2
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
BEN-COMP-CONT
Element: Comp Cont		Signed 11.2
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
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
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
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
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
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 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
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
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
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
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
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
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
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 BN729
BN991 BS13.1
BS14.1 BS15.1
BS32.1
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 BN729
BN991 BS13.1
BS14.1 BS15.1
BS32.1
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 BN729
BN991 BS13.1
BS14.1 BS15.1
BS32.1
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 BN729
BN991 BS13.1
BS14.1 BS15.1
BS32.1
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 BN729
BN991 BS13.1
BS14.1 BS15.1
BS32.1
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
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.
BN138 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
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
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
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
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
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
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
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
BEN-ANNUAL-AMT
Element: Annual Amt		Signed 9.2
Contains the annual contribution amount.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
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
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
BEN-UPD-DATE
Element: Upd Date		Numeric 8 (yyyymmdd)
Contains the last date the benefit was updated.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
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
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
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
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
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
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
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
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
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
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
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
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
BEN-USER-ID
Element: User		Alpha 10 (Lower Case)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
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
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
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
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
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
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


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
BN138 BN145
BN238 BN249
BN258 BN29.2
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN321 BN331
BN335 BN36.1
BN430 BN45.1
BN53.1 BN531
BN532 BN71.1
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 BN138
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
BENSET3 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
START-DATE*
...
BN100 BN101
BN102 BN103
BN105 BN145
BN231 BN232
BN240 BN242
BN245 BN246
BN305 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN340
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BN729
BN991 BS10.1
BS12.1 BS13.1
BENSET4 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
START-DATE
...
BN100 BN101
BN102 BN103
BN105 BN106
BN145 BN245
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 BN555
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: Wed Jun 08 20:48:04 2016

Home
Contact Us



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