Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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