Lawson Insight Technical Documentation |
|
BENEFIT
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 BN106 BN230 BN238 BN258 BN320
BN321 BN325 BN331 BN335 BN36.1 BN53.1
BN532 BN71.1 BN72.1 HR13.2 HR13.3 HR13.4
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 BN236 BN237
BN240 BN330 BN345 BN350 BN50.1 BN55.1
BN555 BN56.1 PR39.1 PR39.5 BN231 BN232
BN242 BN245 BN246 BN65.1 BS10.1 BS14.1
BS15.1 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR15.1 HR155 HR170 HR511
HR515 HR54.1 HR55.2 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 BN547
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 BN104 BN105
BN138 BN140 BN145 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN430 BN45.1 BN531 BS32.1
PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BEN-COMPANY Numeric 4 BN100 BN101
Element: Company Hr Contains the company number. BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN531
BS32.1
BEN-PLAN-TYPE Alpha 2 BN100 BN101
Element: 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 BN430 BN531
DL = Dependent Life BS32.1
DC = Defined Contribution
DB = Defined Benefit
VA = Vacation
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
BEN-EMPLOYEE Numeric 9 BN100 BN101
Element: Employee Contains the employee number. BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN531
BS32.1
BEN-START-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Start Date Contains the effective date of the BN102 BN103
benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN531
BS32.1
BEN-PLAN-CODE Alpha 4 BN100 BN101
Element: Plan Contains the user-defined code BN102 BN103
representing a specific plan. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN531
BS32.1
BEN-FLEX-PLAN Alpha 4 BN100 BN101
Element: 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
Element: 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
Element: 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
Element: Coverage OptioContains 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 11.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 11.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 11.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 11.2 BN100 BN101
Element: Company ContriContains 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
Element: Premium UpdateContains 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Number of HourContains 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. BN104 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
Element: Ytd Cont Contains the year-to-date contribution BN102 BN103
amount. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
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
Element: 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
Element: 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
Element: 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
Element: Cycles Remain Contains the number of payroll cycles BN102 BN103
in which the deduction is taken. BN104 BN105
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1
BEN-YTD-FLEX-CONT Signed 13.2 BN100 BN101
Element: 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
BN531 BS32.1
PR197
BEN-ELIG-GROUP Alpha 10 BN100 BN101
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Last Seq PurchContains the last bond sequence number
used to purchase a savings bond.
BEN-COV-SAL-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Efd Start DateContains 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
Element: 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
Element: 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
Element: Emp Contrib Contains the employee contributions.
The calculation is:
Emp-Pre-Cont + Emp-Aft-Cont
BEN-COMP-CONTRIB Derived
Element: Comp Contrib Contains the company contribution.
The calculation is:
Comp Cont + Cmp Flx Cont
BEN-TOT-CONTRIB Derived
Element: 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
Element: Wk Emp Cont Contains the weekly employee
contribution.
The calculation is:
Emp Contrib / 52.000000
BEN-BI-EMP-CONT Derived
Element: Bi Emp Cont Contains the bi-weekly employee
contribution.
The calculation is:
Emp Contrib / 26
BEN-SM-EMP-CONT Derived
Element: Sm Emp Cont Contains the semi-monthly employee
contribution.
The calculation is:
Emp Contrib / 24
BEN-MO-EMP-CONT Derived
Element: Mo Emp Cont Contains the monthly employee
contribution.
The calculation is:
Emp Contrib / 12
BEN-EMP-PER-AMT Derived
Element: 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
Element: Mo Comp Cont Contains the monthly company
contribution.
The calculation is:
Comp Cont / 12
BEN-MO-COMP-FLX Derived
Element: Mo Comp Flx Contains the monthly company flex
contribution.
Comp Flx Cont / 12
BEN-MO-EMP-PRE Derived
Element: Mo Emp Pre Contains the monthly employee pretax
contribution.
The calculation is:
Emp Pre Cont / 12
BEN-MO-EMP-AFT Derived
Element: Mo Emp Aft Contains the monthly employee after-tax
contribution.
The calculation is:
Empl Aft Cont / 12
BEN-MO-DIS-COVER Derived
Element: Mo Dis Cover Contains the
The calculation is:
Cover Amt / 12
BEN-PLAN-TYPE-2 Derived
Element: Plan Type 2 Contains the plan type.
BEN-SECCLASS Derived
Element: Secclass This field is not used.
BEN-COMP-MATCH Signed 5.2 BN100 BN101
Element: 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
Element: 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
Element: 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
Element: Vacation Cost Contains the vacation cost.
The calculation is:
((Comp Flx Cont + Emp Pre Cont) + Empl
Aft Cont) / Nbr Hours
BEN-FLEX-PT Derived
Element: Flex Pt
BEN-FLEX-PT-AT Derived
Element: Flex Pt At
BEN-PT-AT Derived
Element: Pt At
BEN-FLEX-PT-AT-CMP Derived
Element: Flex Pt At Cmp
BEN-PT-AT-CMP Derived
Element: Pt At Cmp
BEN-WK-FLEX-PT Derived
Element: Wk Flex Pt
BEN-BI-FLEX-PT Derived
Element: Bi Flex Pt
BEN-SM-FLEX-PT Derived
Element: Sm Flex Pt
BEN-MO-FLEX-PT Derived
Element: Mo Flex Pt
BEN-WK-FLEX-PT-AT Derived
Element: Wk Flex Pt At
BEN-BI-FLEX-PT-AT Derived
Element: Bi Flex Pt At
BEN-SM-FLEX-PT-AT Derived
Element: Sm Flex Pt At
BEN-MO-FLEX-PT-AT Derived
Element: Mo Flex Pt At
BEN-PP-FLEX-PT Derived
Element: Pp Flex Pt
BEN-PP-FLEX-PT-AT Derived
Element: Pp Flex Pt At
BEN-CURRENCY-CODE Alpha 5 BN100 BN101
Element: 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
Account Currency Represents the number of decimals BN102 BN103
Code 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
Element: User 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
Element: 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
BEN-TRAN-SEQ-NBR Numeric 4
Element: Sequence Number
BEN-TA-OBJ-ID Numeric 12
Object
Identification
BENEFIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BENSET1 COMPANY BN00.1 BN100
PLAN-TYPE BN101 BN102
EMPLOYEE BN103 BN104
START-DATE BN105 BN106
PLAN-CODE BN138 BN145
BN230 BN238
BN258 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN321
BN325 BN331
BN335 BN36.1
BN430 BN45.1
BN53.1 BN531
BN532 BN71.1
...
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
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 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
HAP3.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
...
BENSET4 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
PLAN-TYPE BN105 BN106
PLAN-CODE BN145 BN245
START-DATE BN31.1 BN31.2
BN31.4 BN31.5
BN32.1 BN32.2
BN32.3 BN331
BN45.1 BN46.2
BN47.1 BN51.1
BN51.2 BN531
BN547 BN55.1
BN555 BN56.1
BN59.1 BN59.2
BN59.3 BN60.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
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
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
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
|