 |
Lawson Insight Technical Documentation |
|
BENEFIT FILE
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 BN230 BN238 BN258 BN320 BN321
BN325 BN331 BN335 BN36.1 BN532 BN71.1
BN72.1 HR13.2 HR13.3 HR13.4 BN02.1 BN02.2
BN02.3 BN02.4 BN02.5 BN04.1 BN104 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 BN236 BN237 BN240
BN330 BN345 BN350 BN50.1 BN55.1 BN555
BN56.1 PR39.1 PR39.5 PR80.3 BN231 BN232
BN242 BN245 BN246 BN65.1 BS10.1 BS14.1
BS15.1 HR11.1 HR11.2 HR15.1 HR155 HR170
HR511 HR515 HR54.1 HR55.2 HR650 HR70.1
HRS1.1 HRSC.1 PA02.1 PA100 PA102 PA113
PA115 PA13.1 PA13.2 PA16.1 PA20.1 PA21.1
PA22.1 PA24.1 PA27.1 PA34.1 PA35.1 PA36.1
PA38.1 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA520 PA54.1 TR21.1 TR22.1 TR26.1
TR500 PR110 PR113 PR120 PR13.1 PR13.5
PR13.6 PR13.8 PRSC.1 BN46.2 BN47.1 BN51.1
BN51.2 BN59.1 BN59.2 BN59.3 BN60.1 BN60.2
BN61.1 BN61.2 BN90.1 BS12.1 BS13.1
UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN138
BN140 BN145 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN430 BN45.1 BN500 BN531 BS32.1
PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BEN-COMPANY Numeric 4 BN100 BN101
Company Contains the company number. BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-PLAN-TYPE Alpha 2 BN100 BN101
Type Contains the benefit type. BN102 BN103
HL = Health BN105 BN31.1
DN = Dental BN31.2 BN32.1
DI = Disability BN32.2 BN32.3
EL = Employee Life BN531 BS32.1
DL = Dependent Life
DC = Defined Contribution
DB = Defined Benefit
VA = Vacation
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
BEN-EMPLOYEE Numeric 9 BN100 BN101
Employee Contains the employee number. BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-START-DATE Numeric 8 (yyyymmdd) BN100 BN101
Start Date Contains the effective date of the BN102 BN103
benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-PLAN-CODE Alpha 4 BN100 BN101
Plan Contains the user-defined code BN102 BN103
representing a specific plan. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-FLEX-PLAN Alpha 4 BN100 BN101
Flex Plan Identifies the flex plan associated BN102 BN103
with this benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-STOP-DATE Numeric 8 (yyyymmdd) BN100 BN101
Stop Date Identifies the ending effective date BN102 BN103
for the benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-PLAN-OPTION Numeric 2 BN100 BN101
Plan Option Contains the plan category. BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-COV-OPTION Numeric 2 BN100 BN101
Coverage Option Contains the selected coverage option BN102 BN103
for this benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-CMP-FLX-CONT Signed 7.2 BN100 BN101
Amt of Company Flex Contains the company's annual flex BN102 BN103
Dollars contribution to the benefit. BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
BEN-EMP-PRE-CONT Signed 7.2 BN100 BN101
Employee Pre Tax Contains the employee's annual pre-tax BN102 BN103
Contribution contribution for the benefit. BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
BEN-EMP-AFT-CONT Signed 7.2 BN100 BN101
Employee After Tax Contains the employee's annual BN102 BN103
Contrib after-tax contribution for the benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-COMP-CONT Signed 7.2 BN100 BN101
Company Contribution Contains the company's annual dollar BN102 BN103
contribution for the benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-PREM-UPD-DT Numeric 8 (yyyymmdd) BN100 BN101
Premium Update Date Contains the start date of the BN102 BN103
contribution record used for this BN105 BN31.1
benefit. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-ELIG-UPD-DT Numeric 8 (yyyymmdd) BN100 BN101
Elig Upd Dt Contains the start date of the BN102 BN103
eligibility record used for this BN105 BN31.1
benefit. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-COV-UPD-DT Numeric 8 (yyyymmdd) BN100 BN101
Cov Upd Dt Contains the start date of the coverage BN102 BN103
record used for this benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-GL-UPD-DT Numeric 8 (yyyymmdd) BN100 BN101
Gl Upd Dt Contains the start date of the general BN102 BN103
ledger override record used for this BN105 BN31.1
benefit. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-PAY-RATE Signed 13.4 BN100 BN101
Rate of Pay Contains the employee's salary used to BN102 BN103
calculate coverage for the benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-COVER-AMT Signed 11.2 BN100 BN101
Flat Amount Contains the coverage amount associated BN102 BN103
with the benefit. BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
BEN-DEP-COVER-AMT Signed 11.2 BN100 BN101
Dep Cover Amt Contains the dependent's coverage BN102 BN103
amount associated with the benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-PCT-AMT-FLAG Alpha 1 BN100 BN101
Percent or Amount Identifies if the contribution amount BN102 BN103
Indicator is a percent or flat amount. BN105 BN31.1
A = Amount BN31.2 BN32.1
P = Percent BN32.2 BN32.3
BN531 BS32.1
BEN-NBR-HOURS Signed 6.3 BN100 BN101
Number of Hours Contains the number of hours of BN102 BN103
vacation the employee has purchased or BN105 BN31.1
sold under a flex plan for the current BN31.2 BN32.1
year. BN32.2 BN32.3
BN531 BS32.1
BEN-BOND-DED-AMT Signed 11.2 BN100 BN101
Savings Bond Identifies the pay period contribution BN102 BN103
Deduction Amt amount. BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
BEN-NBR-PURCH Numeric 3
Nbr of Savings Contains the number of bonds purchased
Bonds Purchased by the employee.
BEN-YTD-CONT Signed 13.2 BN100 BN101
Ytd Cont Contains the year-to-date contribution BN102 BN103
amount. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN500 BN531
BN65.1 BS32.1
PR197
BEN-CMP-SEQ-NBR Numeric 4 BN100 BN101
Company Deduction Contains the sequence number that BN102 BN103
Seq Number allows the tie to the employee deduction BN105 BN145
master file for the company deduction. BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1
BEN-CMP-AFT-SEQ Numeric 4 BN100 BN101
Aft Tax Comp Match Contains the sequence number that ties BN102 BN103
Deduct Seq the benefit deduction to the employee BN105 BN145
deduction master containing the company BN245 BN31.1
matched after tax deduction. BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1
BEN-PRE-SEQ-NBR Numeric 4 BN100 BN101
Pre Tax Deduction Contains the sequence number that ties BN102 BN103
Seq Number the benefit to the employee deduction BN105 BN145
master and to the employee pre-tax BN245 BN31.1
deduction amount. BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1
BEN-AFT-SEQ-NBR Numeric 4 BN100 BN101
After Tax Deduct Identifies the after-tax sequence BN102 BN103
Sequence Nbr number that ties the benefit to the BN105 BN145
employee after tax deduction in the BN245 BN31.1
employee deduction master. BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1
BEN-FLEX-DED-SEQ Numeric 4 BN100 BN101
Flex Ded Seq Contains the sequence number used to BN102 BN103
tie the benefit to the employee flex BN105 BN145
company deduction in the employee BN245 BN31.1
deduction master. BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1
BEN-STM-SEQ-NBR Numeric 4 BN100 BN101
Stm Seq Nbr Contains the sequence number that ties BN102 BN103
the benefit to the employee's standard BN105 BN31.1
time record in the employee standard BN31.2 BN32.1
time record file. BN32.2 BN32.3
BN531 BS32.1
BEN-TA-UPD-FLAG Alpha 1 BN138
Time Accrual Update Used by BN138 (Vacation Hours Update)
Flag to indicate the hours have been updated
to the Time Accrual plan.
BEN-COV-OVER-FLG Alpha 1 BN100 BN101
Override Coverage Contains a flag that identifies if the BN102 BN103
Flag coverage amount has been overridden and BN105 BN31.1
should not be recalculated when running BN31.2 BN32.1
BN100 (Employee Change Benefit Update) BN32.2 BN32.3
or BN102 (Plan Employee Update). BN531 BS32.1
" " = No
Y = Yes
BEN-TAKEN-FLAG Alpha 1 BN500
Taken Flag Indicates the benefit deduction has
been taken at least once This field also
does not allow the benefit to be
deleted.
BEN-CYCLES-REMAIN Numeric 2 BN100 BN101
Cycles Remain Contains the number of payroll cycles BN102 BN103
in which the deduction is taken. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-YTD-FLEX-CONT Signed 13.2 BN100 BN101
Ytd Flex Cont Contains an employee's year to date BN102 BN103
contribution amount. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN500 BN531
BS32.1 PR197
BEN-ELIG-GROUP Alpha 10 BN100 BN101
Elig Group Contains the employee group name of the BN102 BN103
eligibility record used for this BN105 BN31.1
benefit. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-COV-GROUP Alpha 10 BN100 BN101
Cov Group Contains the coverage group name of the BN102 BN103
coverage record used for this benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-PREM-GROUP Alpha 10 BN100 BN101
Prem Group Contains the employee group name of the BN102 BN103
premium record used for this benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-GL-GROUP Alpha 10 BN100 BN101
Gl Group Contains the employee group name of the BN102 BN103
gl override record used for this BN105 BN31.1
benefit. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-MULTIPLE Signed 6.3 BN100 BN101
Multiple Contains the multiple of salary elected BN102 BN103
by employee. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-ANNUAL-AMT Signed 9.2 BN100 BN101
Annual Amt Contains the annual contribution BN102 BN103
amount. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-SMOKER Alpha 1 BN100 BN101
Smoker Indicates whether rates are used to BN102 BN103
calculate contributions. BN105 BN31.1
Y = Yes BN31.2 BN32.1
N = No BN32.2 BN32.3
BN531 BS32.1
BEN-CREATION-DATE Numeric 8 (yyyymmdd) BN100 BN101
Creation Date Indicates the date the benefit was BN102 BN103
added to the system. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-UPD-DATE Numeric 8 (yyyymmdd) BN100 BN101
Upd Date Contains the last date the benefit was BN102 BN103
updated. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-LAST-SEQ-PURCH Numeric 2 BN140
Last Seq Purch Contains the last bond sequence number
used to purchase a savings bond.
BEN-COV-SAL-DATE Numeric 8 (yyyymmdd) BN100 BN101
Cov Sal Date Contains the date used to determine the BN102 BN103
salary for coverage calculations. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-COV-AGE-DATE Numeric 8 (yyyymmdd) BN100 BN101
Cov Age Date Contains the date used to determine the BN102 BN103
age for contribution calculations. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-CNT-SAL-DATE Numeric 8 (yyyymmdd) BN100 BN101
Cnt Sal Date Contains the date used to determine BN102 BN103
salary for contribution calculations. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-CNT-AGE-DATE Numeric 8 (yyyymmdd) BN100 BN101
Cnt Age Date Contains the date used to determine the BN102 BN103
age for contribution calculations. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-CNT-SERV-DATE Numeric 8 (yyyymmdd) BN100 BN101
Cnt Serv Date Contains the date used to determine the BN102 BN103
years of service for contribution BN105 BN31.1
calculations. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-EFD-START-DATE Numeric 8 (yyyymmdd) BN100 BN101
Efd Start Date Contains the date of employee flex BN102 BN103
dollars record used to calculate flex BN105 BN31.1
contributions. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-PRE-AFT-FLAG Alpha 1 BN100 BN101
Pre Aft Flag Contains the type of employee BN102 BN103
contribution for the benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-PEND-EVIDENCE Alpha 1 BN100 BN101
Pend Evidence Indicates the status of evidence of BN102 BN103
insurability. BN105 BN31.1
A = Approved BN31.2 BN32.1
P = Pending BN32.2 BN32.3
N = No BN531 BS32.1
" "
BEN-EMP-CONTRIB Derived
Emp Contrib Contains the employee contributions.
The calculation is:
Emp-Pre-Cont + Emp-Aft-Cont
BEN-COMP-CONTRIB Derived
Comp Contrib Contains the company contribution.
The calculation is:
Comp Cont + Cmp Flx Cont
BEN-TOT-CONTRIB Derived
Tot Contrib Contains the total contribution.
The calculation is:
((Comp Cont + Comp Flx Cnt) + Emp Pre
Cont) + Emp Aft Cont
BEN-WK-EMP-CONT Derived
Wk Emp Cont Contains the weekly employee
contribution.
The calculation is:
Emp Contrib / 52.000000
BEN-BI-EMP-CONT Derived
Bi Emp Cont Contains the bi-weekly employee
contribution.
The calculation is:
Emp Contrib / 26
BEN-SM-EMP-CONT Derived
Sm Emp Cont Contains the semi-monthly employee
contribution.
The calculation is:
Emp Contrib / 24
BEN-MO-EMP-CONT Derived
Mo Emp Cont Contains the monthly employee
contribution.
The calculation is:
Emp Contrib / 12
BEN-EMP-PER-AMT Derived
Emp Per Amt 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 Derived
Mo Comp Cont Contains the monthly company
contribution.
The calculation is:
Comp Cont / 12
BEN-MO-COMP-FLX Derived
Mo Comp Flx Contains the monthly company flex
contribution.
Comp Flx Cont / 12
BEN-MO-EMP-PRE Derived
Mo Emp Pre Contains the monthly employee pretax
contribution.
The calculation is:
Emp Pre Cont / 12
BEN-MO-EMP-AFT Derived
Mo Emp Aft Contains the monthly employee after-tax
contribution.
The calculation is:
Empl Aft Cont / 12
BEN-MO-DIS-COVER Derived
Mo Dis Cover Contains the
The calculation is:
Cover Amt / 12
BEN-PLAN-TYPE-2 Derived
Plan Type 2 Contains the plan type.
BEN-SECCLASS Derived
Secclass This field is not used.
BEN-COMP-MATCH Signed 5.2 BN100 BN101
Comp Match Contains the percent of the company BN102 BN103
match. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-MTCH-UP-TO Signed 5.2 BN100 BN101
Mtch Up To Contains the percent of the employee BN102 BN103
contribution that the company will BN105 BN31.1
match. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-SOURCE Alpha 1
Source 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 Derived
Vacation Cost Contains the vacation cost.
The calculation is:
((Comp Flx Cont + Emp Pre Cont) + Empl
Aft Cont) / Nbr Hours
BEN-FLEX-PT Derived
Flex Pt
BEN-FLEX-PT-AT Derived
Flex Pt At
BEN-PT-AT Derived
Pt At
BEN-FLEX-PT-AT-CMP Derived
Flex Pt At Cmp
BEN-PT-AT-CMP Derived
Pt At Cmp
BEN-WK-FLEX-PT Derived
Wk Flex Pt
BEN-BI-FLEX-PT Derived
Bi Flex Pt
BEN-SM-FLEX-PT Derived
Sm Flex Pt
BEN-MO-FLEX-PT Derived
Mo Flex Pt
BEN-WK-FLEX-PT-AT Derived
Wk Flex Pt At
BEN-BI-FLEX-PT-AT Derived
Bi Flex Pt At
BEN-SM-FLEX-PT-AT Derived
Sm Flex Pt At
BEN-MO-FLEX-PT-AT Derived
Mo Flex Pt At
BEN-PP-FLEX-PT Derived
Pp Flex Pt
BEN-PP-FLEX-PT-AT Derived
Pp Flex Pt At
BEN-CURRENCY-CODE Alpha 5 BN100 BN101
Currency Code This field contains the company base BN102 BN103
currency code established in Company BN105 BN31.1
(GL10.1 ). BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-CURR-ND Numeric 1 BN100 BN101
Currency Number of Represents the number of decimals BN102 BN103
Decimals defined for the currency of the object. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-USER-ID Alpha 10 (Lower Case) BN100 BN101
User ID Name Contains the user ID of the person who BN102 BN103
last changed this record. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BEN-TIME-STAMP Numeric 6 (hhmmss) BN100 BN101
Time Stamp Contains the server time (hour, minute, BN102 BN103
and second) when the record was last BN105 BN31.1
changed. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
BENEFIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BENSET1 COMPANY BN00.1 BN100
PLAN-TYPE BN101 BN102
EMPLOYEE BN103 BN105
START-DATE BN138 BN145
PLAN-CODE BN230 BN238
BN258 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN321
BN325 BN331
BN335 BN36.1
BN430 BN45.1
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.2
...
BENSET2 COMPANY BN02.1 BN02.2
PLAN-TYPE BN02.3 BN02.4
PLAN-CODE BN02.5 BN04.1
EMPLOYEE BN102 BN103
START-DATE* BN104 BN105
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 BN19.1
...
BENSET3 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
PLAN-TYPE BN105 BN231
PLAN-CODE BN232 BN242
START-DATE* BN245 BN246
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN531 BN65.1
BN71.1 BN72.1
BS10.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR15.1 HR155
HR170 HR511
...
BENSET4 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
PLAN-TYPE BN105 BN145
PLAN-CODE BN245 BN31.1
START-DATE BN31.2 BN31.4
BN31.5 BN32.1
BN32.2 BN32.3
BN331 BN45.1
BN46.2 BN47.1
BN51.1 BN51.2
BN531 BN55.1
BN555 BN56.1
BN59.1 BN59.2
BN59.3 BN60.1
BN60.2 BN61.1
...
BENSET5 COMPANY KeyChange BN15.1 BN18.1
PLAN-TYPE BN18.2 BN18.3
PLAN-CODE BN18.4 BN18.5
PREM-UPD-DT BN18.6 BN18.7
PREM-GROUP BN19.1 BN19.2
EMPLOYEE BN19.3 BN19.4
START-DATE
BENSET6 COMPANY BN02.5 BN15.1
PLAN-TYPE BN16.1 BN16.2
PLAN-CODE BN16.3 BN16.4
START-DATE BN17.1
EMPLOYEE
BENSET7 COMPANY BN100 BN102
EMPLOYEE BN103
EFD-START-DATE
PLAN-TYPE
PLAN-CODE
START-DATE
BENSET8 COMPANY BN100 BN101
EMPLOYEE
PLAN-OPTION
PLAN-TYPE
PLAN-CODE
START-DATE
BENEFIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
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
Coda Ltd Bal CODA Not Required
BEN-COMPANY -> COD-COMPANY
BEN-EMPLOYEE -> COD-EMPLOYEE
BEN-PLAN-TYPE -> COD-PLAN-TYPE
BEN-PLAN-CODE -> COD-PLAN-CODE
Zeroes -> COD-PLAN-YEAR
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 BEN-CONTRIB-TYPE = "0 "
BEN-COMPANY -> PLN-COMPANY
BEN-PLAN-TYPE -> PLN-PLAN-TYPE
BEN-PLAN-CODE -> PLN-PLAN-CODE
Contrib 1 PLAN Required
When BEN-CONTRIB-TYPE = "0 "
BEN-COMPANY -> PLN-COMPANY
BEN-PLAN-TYPE -> PLN-PLAN-TYPE
BEN-PLAN-CODE -> PLN-PLAN-CODE
Contrib 2 PLAN Required
When BEN-CONTRIB-TYPE = "2 "
BEN-COMPANY -> PLN-COMPANY
BEN-PLAN-TYPE -> PLN-PLAN-TYPE
BEN-PLAN-CODE -> PLN-PLAN-CODE
Contrib 3 PLAN Required
When BEN-CONTRIB-TYPE = "3 "
BEN-COMPANY -> PLN-COMPANY
BEN-PLAN-TYPE -> PLN-PLAN-TYPE
BEN-PLAN-CODE -> PLN-PLAN-CODE
Contrib 4 PLAN Required
When BEN-CONTRIB-TYPE = "4 "
BEN-COMPANY -> PLN-COMPANY
BEN-PLAN-TYPE -> PLN-PLAN-TYPE
BEN-PLAN-CODE -> PLN-PLAN-CODE
Contrib 5 PLAN Required
When BEN-CONTRIB-TYPE = "5 "
BEN-COMPANY -> PLN-COMPANY
BEN-PLAN-TYPE -> PLN-PLAN-TYPE
BEN-PLAN-CODE -> PLN-PLAN-CODE
Contrib 6 PLAN Required
When BEN-CONTRIB-TYPE = "6 "
BEN-COMPANY -> PLN-COMPANY
BEN-PLAN-TYPE -> PLN-PLAN-TYPE
BEN-PLAN-CODE -> PLN-PLAN-CODE
Contrib 7 PLAN Required
When BEN-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 BEN-COVERAGE-TYPE = "0 "
BEN-COMPANY -> PLN-COMPANY
BEN-PLAN-TYPE -> PLN-PLAN-TYPE
BEN-PLAN-CODE -> PLN-PLAN-CODE
Coverage 1 PLAN Required
When BEN-COVERAGE-TYPE = "1 "
BEN-COMPANY -> PLN-COMPANY
BEN-PLAN-TYPE -> PLN-PLAN-TYPE
BEN-PLAN-CODE -> PLN-PLAN-CODE
Coverage 2 PLAN Required
When BEN-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
BENEFIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
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
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
|