Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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