BENEFIT – Employee Benefit

System: Benefits (BN)
Prefix: BEN
Primary key: COMPANY, PLAN-TYPE, EMPLOYEE, START-DATE, PLAN-CODE
Fields: 100
Updated by: 42 programs
Referenced by: 122 programs

BENEFIT is the Employee Benefit table in Lawson Benefits (prefix BEN). It is indexed by COMPANY, PLAN-TYPE, EMPLOYEE, START-DATE, PLAN-CODE (BENSET1); alternate indexes: BENSET2, BENSET3, BENSET4, BENSET5, BENSET6, BENSET7 and BENSET8. It is related 1:1 to EMDEDMASTR, BNCOVOPT, BNCOMPANY, PRSYSTEM, PERSGROUP, PLAN, CUCODES, EMPLOYEE and 3 more and 1:M to BENEFICRY, BNTAEMPBAL, BONDBENIF, CODA, COMPHIST, EMDEDMASTR, HRDEPBEN, BNCOMMENTS and 4 more. It is updated by BN100, BN101, BN102, BN103, BN104, BN105, BN140, BN145 and 34 more and referenced by BN00.1, BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN04.1, BN106 and 114 more. The table has 100 fields, 8 indexes and 47 documented relations.

About BENEFIT

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

Fields (100)

Column = COBOL field name without the BEN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`BEN-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +29 more
`BEN-PLAN-TYPE` PK 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 +29 more
`BEN-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number.	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +30 more
`BEN-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	Contains the effective date of the benefit.	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +30 more
`BEN-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code representing a specific plan.	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +30 more
`BEN-FLEX-PLAN` FLEX_PLAN	Alpha 4	Identifies the flex plan associated with this benefit.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
`BEN-STOP-DATE` STOP_DATE	Numeric 8 (yyyymmdd)	Identifies the ending effective date for the benefit.	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +30 more
`BEN-PLAN-OPTION` PLAN_OPTION	Numeric 2	Contains the plan category.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
`BEN-COV-OPTION` COV_OPTION	Numeric 2	Contains the selected coverage option for this benefit.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more
`BEN-CMP-FLX-CONT` CMP_FLX_CONT	Signed 13.4	Contains the company's annual flex contribution to the benefit.	BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
`BEN-EMP-PRE-CONT` EMP_PRE_CONT	Signed 13.4	Contains the employee's annual pre-tax contribution for the benefit.	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
`BEN-EMP-AFT-CONT` EMP_AFT_CONT	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 +10 more
`BEN-COMP-CONT` COMP_CONT	Signed 13.4	Contains the company's annual dollar contribution for the benefit.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
`BEN-PREM-UPD-DT` 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 +10 more
`BEN-ELIG-UPD-DT` 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 +10 more
`BEN-COV-UPD-DT` 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 +10 more
`BEN-GL-UPD-DT` 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 +10 more
`BEN-PAY-RATE` 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 +28 more
`BEN-COVER-AMT` COVER_AMT	Signed 11.2	Contains the coverage amount associated with the benefit.	BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
`BEN-DEP-COVER-AMT` 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 +10 more
`BEN-PCT-AMT-FLAG` 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 +11 more
`BEN-NBR-HOURS` 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 +10 more
`BEN-BOND-DED-AMT` BOND_DED_AMT	Signed 11.2	Identifies the pay period contribution amount.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN31.1 +13 more
`BEN-NBR-PURCH` NBR_PURCH	Numeric 3	Contains the number of bonds purchased by the employee.	—
`BEN-YTD-CONT` YTD_CONT	Signed 13.2	Contains the year-to-date contribution amount.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more
`BEN-CMP-SEQ-NBR` 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 +22 more
`BEN-CMP-AFT-SEQ` 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 +21 more
`BEN-PRE-SEQ-NBR` 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 +22 more
`BEN-AFT-SEQ-NBR` 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 +21 more
`BEN-FLEX-DED-SEQ` 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 +21 more
`BEN-STM-SEQ-NBR` 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 +10 more
`BEN-TA-UPD-FLAG` 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` 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 +10 more
`BEN-TAKEN-FLAG` 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` 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 +11 more
`BEN-YTD-FLEX-CONT` 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 +11 more
`BEN-ELIG-GROUP` 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 +10 more
`BEN-COV-GROUP` 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 +10 more
`BEN-PREM-GROUP` 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 +10 more
`BEN-GL-GROUP` 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 +10 more
`BEN-MULTIPLE` MULTIPLE	Signed 6.3	Contains the multiple of salary elected by employee.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
`BEN-ANNUAL-AMT` ANNUAL_AMT	Signed 11.4	Contains the annual contribution amount.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
`BEN-SMOKER` 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 +10 more
`BEN-CREATION-DATE` 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 +10 more
`BEN-UPD-DATE` UPD_DATE	Numeric 8 (yyyymmdd)	Contains the last date the benefit was updated.	BN100, BN101, BN102, BN103, BN104, BN105, BN31.1, BN31.2 +12 more
`BEN-LAST-SEQ-PURCH` LAST_SEQ_PURCH	Numeric 2	Contains the last bond sequence number used to purchase a savings bond.	BN140
`BEN-COV-SAL-DATE` 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 +10 more
`BEN-COV-AGE-DATE` 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 +10 more
`BEN-CNT-SAL-DATE` 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 +10 more
`BEN-CNT-AGE-DATE` 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 +10 more
`BEN-CNT-SERV-DATE` 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 +10 more
`BEN-EFD-START-DATE` 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 +10 more
`BEN-PRE-AFT-FLAG` 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 +10 more
`BEN-PEND-EVIDENCE` 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 +10 more
`BEN-EMP-CONTRIB` EMP_CONTRIB	Derived	Contains the employee contributions. The calculation is: Emp-Pre-Cont + Emp-Aft-Cont	—
`BEN-COMP-CONTRIB` COMP_CONTRIB	Derived	Contains the company contribution. The calculation is: Comp Cont + Cmp Flx Cont	—
`BEN-TOT-CONTRIB` 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` WK_EMP_CONT	Derived	Contains the weekly employee contribution. The calculation is: Emp Contrib / 52.000000	—
`BEN-BI-EMP-CONT` BI_EMP_CONT	Derived	Contains the bi-weekly employee contribution. The calculation is: Emp Contrib / 26	—
`BEN-SM-EMP-CONT` SM_EMP_CONT	Derived	Contains the semi-monthly employee contribution. The calculation is: Emp Contrib / 24	—
`BEN-MO-EMP-CONT` MO_EMP_CONT	Derived	Contains the monthly employee contribution. The calculation is: Emp Contrib / 12	—
`BEN-EMP-PER-AMT` 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` MO_COMP_CONT	Derived	Contains the monthly company contribution. The calculation is: Comp Cont / 12	—
`BEN-MO-COMP-FLX` MO_COMP_FLX	Derived	Contains the monthly company flex contribution. Comp Flx Cont / 12	—
`BEN-MO-EMP-PRE` MO_EMP_PRE	Derived	Contains the monthly employee pretax contribution. The calculation is: Emp Pre Cont / 12	—
`BEN-MO-EMP-AFT` MO_EMP_AFT	Derived	Contains the monthly employee after-tax contribution. The calculation is: Empl Aft Cont / 12	—
`BEN-MO-DIS-COVER` MO_DIS_COVER	Derived	Contains the The calculation is: Cover Amt / 12	—
`BEN-PLAN-TYPE-2` PLAN_TYPE_2	Derived	Contains the plan type.	—
`BEN-SECCLASS` SECCLASS	Derived	This field is not used.	—
`BEN-COMP-MATCH` COMP_MATCH	Signed 5.2	Contains the percent of the company match.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
`BEN-MTCH-UP-TO` 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 +10 more
`BEN-SOURCE` 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` VACATION_COST	Derived	Contains the vacation cost. The calculation is: ((Comp Flx Cont + Emp Pre Cont) + Empl Aft Cont) / Nbr Hours	—
`BEN-FLEX-PT` FLEX_PT	Derived	—	—
`BEN-FLEX-PT-AT` FLEX_PT_AT	Derived	—	—
`BEN-PT-AT` PT_AT	Derived	—	—
`BEN-FLEX-PT-AT-CMP` FLEX_PT_AT_CMP	Derived	—	—
`BEN-PT-AT-CMP` PT_AT_CMP	Derived	—	—
`BEN-WK-FLEX-PT` WK_FLEX_PT	Derived	—	—
`BEN-BI-FLEX-PT` BI_FLEX_PT	Derived	—	—
`BEN-SM-FLEX-PT` SM_FLEX_PT	Derived	—	—
`BEN-MO-FLEX-PT` MO_FLEX_PT	Derived	—	—
`BEN-WK-FLEX-PT-AT` WK_FLEX_PT_AT	Derived	—	—
`BEN-BI-FLEX-PT-AT` BI_FLEX_PT_AT	Derived	—	—
`BEN-SM-FLEX-PT-AT` SM_FLEX_PT_AT	Derived	—	—
`BEN-MO-FLEX-PT-AT` MO_FLEX_PT_AT	Derived	—	—
`BEN-PP-FLEX-PT` PP_FLEX_PT	Derived	—	—
`BEN-PP-FLEX-PT-AT` PP_FLEX_PT_AT	Derived	—	—
`BEN-CURRENCY-CODE` 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 +10 more
`BEN-CURR-ND` CURR_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 +10 more
`BEN-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN100, BN101, BN102, BN103, BN104, BN105, BN31.1, BN31.2 +12 more
`BEN-TIME-STAMP` 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 +12 more
`BEN-TRAN-SEQ-NBR` TRAN_SEQ_NBR	Numeric 4	An automatically assigned sequence number.	—
`BEN-TA-OBJ-ID` TA_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 +10 more
`BEN-CO-PCT-AMT` CO_PCT_AMT	Alpha 1	— `A` Amount `P` Percent	—
`BEN-EMP-YTD-CONT` EMP_YTD_CONT	Signed 13.2	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +13 more
`BEN-DED-START-DATE` DED_START_DATE	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
`BEN-DED-STOP-DATE` DED_STOP_DATE	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
`BEN-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
`BEN-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more

Indexes (8)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`BENSET1`	`COMPANY`, `PLAN-TYPE`, `EMPLOYEE`, `START-DATE`, `PLAN-CODE`	Primary	BN00.1, BN100, BN101, BN102, BN103, BN104, BN105, BN106 +22 more (list truncated in source)
`BENSET2`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `EMPLOYEE`, `START-DATE*`		BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN04.1, BN102, BN103 +22 more (list truncated in source)
`BENSET3`	`COMPANY`, `EMPLOYEE`, `PLAN-TYPE`, `PLAN-CODE`, `START-DATE*`		BN100, BN101, BN102, BN103, BN105, BN145, BN231, BN232 +22 more (list truncated in source)
`BENSET4`	`COMPANY`, `EMPLOYEE`, `PLAN-TYPE`, `PLAN-CODE`, `START-DATE`		BN100, BN101, BN102, BN103, BN105, BN106, BN145, BN245 +22 more (list truncated in source)
`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 +4 more
`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

Relations

One to one (35) — lookups and parents

Relation	Table	Rules	Condition	Field map
Aft Ded Code A	EMDEDMASTR	Required	When BEN-AFT-SEQ-NBR != Zeroes And BEN-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 And BEN-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 And BEN-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 And BEN-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 And BEN-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 And BEN-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 And BEN-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 And BEN-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 And BEN-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 And BEN-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`

One to many (12) — child tables

Relation	Table	Rules	Field map
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`

Programs

Updated by (42)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN104 Frequency Table Update
BN105 Plan Update
BN140 Savings Bond Update
BN145 Flex Dollars Calculation
BN232 Benefits Statement
BN245 Benefit Election Form
BN260 Employee Benefit Extract
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN320 Premium Report
BN331 HIPAA Certification Report
BN340 ADP and ACP Tests
BN430 Benefit Purge
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN65.1 Election Simulation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS10.1 Web Enrollment Current Benefit Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
LP138 Absence Plan Hours Update
PR197 Payroll Close
PR797 Benefit EMP YTD Contribution Update
ZB01.1 Years Of Service Calculation
ZB10.1 Coverage Options Calculator
ZB10.2 Get Benefit Eligibility Dates
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add

Referenced by (122)

BN00.1 Benefits Company
BN02.1 Age Rate Table
BN02.2 Salary Rate Table
BN02.3 Service Rate Table
BN02.4 Credits Rate Table
BN02.5 Coverage Reduction Table
BN04.1 Frequency Table
BN106 Benefit Transaction Export
BN141 Stock Purchase Update
BN15.1 Benefit Plan
BN150 Life Insurance Reportable Income
BN16.1 Benefit Entry Rules
BN16.2 Add Rules
BN16.3 Change Rules
BN16.4 Termination Rules
BN17.1 Coverage Options by Plan
BN17.2 Coverage Option Defaults
BN17.3 Coverage Amounts
BN18.1 Options Amount
BN18.2 Options Amount Range
BN18.3 Flat Contributions
BN18.4 Salary or Coverage Rate Table
BN18.5 Contribution Limits
BN18.6 Match Limit Schedule
BN18.7 Match Percent Schedule
BN19.1 Options Rates
BN19.2 Options Rate Tables
BN19.3 Match Limits
BN19.4 Match Percents
BN20.1 General Ledger Overrides
BN230 Plan Participant Report
BN231 Employee Benefit Report
BN236 Participation Report
BN237 Vesting Report
BN238 Vacation Hours History
BN240 Savings Bond Balance Report
BN242 One Page Benefits Statement
BN246 Flex Missing Benefits Report
BN258 Spending Account Balance
BN305 Highly Compensated Employees
BN321 Dependent Benefit Listing
BN325 Benefit Exception Report
BN330 Defined Contribution Plan Contributions
BN335 Employee Deferral Report
BN345 Percentage Test
BN350 Coverage Test - Classification
BN36.1 Investment
BN46.2 Flex Benefits Inquiry
BN47.1 Beneficiaries
BN50.1 Current Plan Participants
BN51.1 Employee Benefit Summary
BN51.2 Employee Benefit Detail
BN53.1 Benefit Transactions
BN532 Batch Dependent Benefit Enrollment
BN547 Beneficiaries Conversion
BN55.1 Defined Contribution or Defined Benefit Acct Balance
BN55.2 Vested Amounts
BN555 Defined Benefit or Defined Contribution Balance Conv
BN556 Compensation History Upload
BN56.1 Compensation History
BN59.1 Spending Account Transactions
BN59.2 Enrollment Period Totals
BN59.3 Plan Year Spending Account Totals
BN60.1 Savings Bond History
BN60.2 Savings Bond Balance
BN61.1 Stock Purchase History
BN61.2 Stock Balance
BN90.1 Comments
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR13.1 Dependent
HR13.2 Dependent Benefits
HR13.3 Dependent Benefits
HR13.4 Dependent Benefits
HR170 Human Resource Writer Report Request
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR513 Dependent Conversion
HR70.1 Human Resource Writer Inquiry
LP34.1 Absence Plan Hours Allocation
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA218 Travel Listing
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.2 Employee Automatic Time Record
PR39.1 One Time Deduction
PR39.5 One Time Deduction BN Select
PR512 Employee ACH Distribution Interface
PR539 One Time Deduction Load
PR80.3 Manual Payment One Time Deduction
ZH230 PPH Big Bad Edit
ZH500 Employee Data Extract
ZH510 Update PCP from ZPENDPCP
ZH568 Reed Employee Census Interface
ZP551 Triad FSA Export Interface
ZP552 Fidelity - BiWeekly
ZP555 HealthEquity Export Interface
ZP560 PPH Medical-Dental Interfaces
ZP562 Sharp Medical Export Interface
ZP565 Hyatt - Legal - Monthly
ZP567 Vision Enrollment