Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PLAN


                               PLAN FILE

                              Benefit Plan

The Benefit Plan file contains information about benefit plans such as
coverage and contribution types, deductions, vesting and compensation
parameters, and account numbers used for COBRA participants and retirees.

REFERENCED BY

BN02.5    BN03.1    BN06.1    BN100     BN101     BN102
BN103     BN105     BN106     BN13.1    BN138     BN140
BN141     BN145     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    BN180
BN181     BN19.1    BN19.2    BN19.3    BN19.4    BN20.1
BN206     BN215     BN216     BN220     BN230     BN231
BN232     BN233     BN236     BN237     BN238     BN240
BN242     BN245     BN246     BN247     BN248     BN252
BN258     BN259     BN305     BN31.1    BN31.2    BN31.4
BN31.5    BN310     BN32.1    BN32.2    BN32.3    BN320
BN321     BN325     BN330     BN331     BN335     BN340
BN345     BN350     BN36.1    BN430     BN45.1    BN47.1
BN48.2    BN50.1    BN51.1    BN51.2    BN53.1    BN531
BN532     BN547     BN55.1    BN55.2    BN555     BN56.1
BN57.1    BN59.1    BN60.1    BN60.2    BN61.1    BN65.1
BN65.2    BN66.1    BN71.1    BN72.1    BN77.1    BN80.1
BN81.2    BS03.1    BS03.2    BS03.3    BS04.1    BS10.1
BS12.1    BS13.1    BS14.1    BS15.1    BS30.1    BS31.1
BS32.1    BS531     ET530     ETI1.1    ETI2.1    HPLN.1
HR11.1    HR11.2    HR13.1    HR13.2    HR13.3    HR13.4
HR170     HR511     HR513     HR55.1    HR55.2    HR55.3
HR70.1    LP01.1    LP02.1    LP130     LP138     LP15.1
LP34.1    PA02.1    PA100     PA102     PA115     PA13.1
PA13.2    PA218     PA502     PA513     PA52.1    PA52.3
PA52.4    PA52.5    PR110     PR113     PR120     PR128
PR13.1    PR13.2    PR13.5    PR13.6    PR13.8    PR130
PR131     PR132     PR134     PR136     PR14.1    PR14.2
PR140     PR15.1    PR15.2    PR189     PR195     PR197
PR20.1    PR20.4    PR205     PR240     PR241     PR242
PR26.1    PR26.2    PR27.1    PR27.2    PR29.1    PR32.2
PR33.2    PR33.3    PR35.1    PR35.2    PR35.3    PR35.4
PR35.5    PR35.6    PR35.8    PR35.9    PR36.1    PR39.1
PR39.2    PR39.5    PR45.1    PR47.1    PR47.2    PR514
PR529     PR530     PR539     PR560     PR80.1    PR80.3
PR82.1    PR89.1    PRBN.1    UK102     UK201     UK47.1
UK47.2    UK50.3    UK560     TA147     BN52.1    PR297
PR299     BN11.1

UPDATED BY

BN00.1    BN04.1    BN104     BN15.1    BN15.2    BN90.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PLN-COMPANY            Numeric 4                                 BN15.1
Element: Company Hr    Contains the company number.

PLN-PLAN-TYPE          Alpha 2                                   BN15.1
Element: Plan          Contains the type of benefit plan.
                       HL = Health
                       DN = Dental
                       DI = Disability
                       EL = Life
                       DL = Dependent Life
                       DC = Defined Contribution
                       DB = Defined Benefit
                       VA = Vacation
                       RS = Spending Account
                       SB = Savings Bond
                       SP = Stock Purchase
                       FL = Flex

PLN-PLAN-CODE          Alpha 4                                   BN15.1
Element: Plan          Contains the user-defined code used to
                       represent a specific benefit plan. The
                       plan code is unique within a plan type.

PLN-START-DATE         Numeric 8  (yyyymmdd)                     BN15.1
Element: Start Date    Contains the first date an employee may
                       enroll in a benefit plan. For defined
                       contribution and defined benefit plan
                       types, the month and day define the
                       beginning date for each plan year.

PLN-PLAN-OPTION        Numeric 2                                 BN15.1
Element: Type          Contains the plan category within a
                       plan type. It further defines the type
                       of  plan.
                       01 = Profit Sharing
                       02 = Money Purchase
                       03 = ESOP
                       04 = 401(k)
                       05 = 403(b)
                       06 = 457
                       07 = Thrift or Savings
                       10 = Medical Reimbursement
                       11 = Dependent Care
                       12 = Legal Account
                       14 = Vacation Buy
                       15 = Vacation Sell
                       18 = Life
                       19 = AD&D
                       20 = STD
                       21 = LTD
                       25 = Medical
                       26 = Vision
                       27 = Long Term Care

PLN-STOP-DATE          Numeric 8  (yyyymmdd)                     BN15.1
Element: Stop Date     Contains the last day an employee can
                       be added into the plan.

PLN-EMP-COVERED        Alpha 1                                   BN15.1
Element: Emp Covered   Indicates whether employee benefits can
                       be added under a plan.
                       Y = Yes
                       N = No

PLN-GROUP-NAME         Alpha 10                                  BN15.1
Element: Employee GroupContains the employee group used to
                       determine which employees are eligible
                       for the plan. The employee must be in
                       this group to be eligible for the plan.

PLN-RET-COVERED        Alpha 1                                   BN15.1
Element: Ret Covered   Indicates whether retiree benefits can
                       be added under a plan. This field is
                       used only for health, dental, life, and
                       disability plans.
                       Y = Yes
                       N = No

PLN-RET-GROUP-NAME     Alpha 10                                  BN15.1
Element: Ret Group NameContains the an employee group used to
                       determine which retirees are eligible
                       for the plan. The retiree must be in
                       this group to be eligible.

PLN-POST-CODE-TBL      Alpha 30                                  BN15.1
Element: Post Code Tbl Contains the table of postal codes used
                       to determine employee eligibility for
                       the plan. The employee must have a
                       benefit postal code which is on this
                       table to be eligible for the plan.

PLN-FLEX-PLAN          Alpha 4                                   BN15.1
Element: Flex Plan     Contains the flexible benefit plan code
                       which is used to determine which flex
                       plan this benefit plan is associated
                       with.

                       If this is not a spending account only
                       plan, the employee must have a flex
                       dollar record to enroll in the benefit
                       plan.

PLN-DESC               Alpha 30  (Lower Case)                    BN15.1
Element: Description   Contains the description of the benefit
                       plan.

PLN-VEST-DATE          Alpha 2                                   BN15.1
Element: Vest Date     Contains the type of year used in
                       determining the vesting computation
                       period. This field is used for defined
                       contribution and defined benefit plans
                       only.
                       CA = Calendar Year
                       EM = Employment Year
                       PL = Plan Year

PLN-VEST-BEF-FLG       Alpha 1                                   BN15.1
Element: Vest Bef Flg  If the employee was hired prior to the
                       plan start date this field is used to
                       specify whether the years prior to the
                       plan start date should be used to
                       calculate the employees vested
                       percent.  Yes means the system will
                       include years prior to the plan start
                       date in vesting calculations.
                       No means the system will begin vesting
                       with the plan start date.

                       This field is for defined contribution
                       and defined benefit plans only.
                       Y = Yes
                       N = No

PLN-VESTED-AGE         Numeric 2                                 BN15.1
Element: Vested Age    Contains the age when the employee is
                       100 percent vested regardless of vesting
                       years of service. This field is for
                       defined contribution and defined benefit
                       plans only.

PLN-VEST-SCHED         Alpha 2                                   BN15.1
Element: Vest Sched    Contains the vesting schedule code for
                       this plan, if applicable.
                       This field is used only for defined
                       contribution and defined benefit plans.

PLN-VEST-FROM-DATE     Alpha 2                                   BN15.1
Element: Vest From DateContains the start date for employee
                       vesting calculations. This field is for
                       defined contribution and defined benefit
                       plans only.
                       HI = Hire Date
                       AJ = Adjusted Hire Date
                       SN = Seniority Date
                       AN = Anniversary Date
                       B1 = Benefit Date 1
                       B2 = Benefit Date 2
                       B3 = Benefit Date 3
                       B4 = Benefit Date 4
                       B5 = Benefit Date 5

PLN-DED-TABLE          Alpha 2                                   BN100   BN102
Element: Frequency TablIf deductions or pay codes have been      BN15.1
                       set up for this plan, this field is the
                       frequency table used to determine
                       premium divisors (if applicable) and
                       deduction cycles for benefits added
                       under this plan.

PLN-ACT-EMP-FLAG       Alpha 1                                   BN15.1
Element: Act Emp Flag  Specifies if an employee must be active
                       on the last day of the plan year to
                       receive the company plan contribution.

                       This field is used for defined
                       contribution and defined benefit plans
                       only.
                       N = No
                       Y = Yes

PLN-CONT-ANN-HRS       Numeric 4                                 BN15.1
Element: Cont Ann Hrs  This field specifies the minimum number
                       of  hours that an employee must work in
                       a  plan year in order to receive a plan
                       contribution.

                       This field is used with defined benefit
                       and defined contribution plans only.

PLN-MIN-HOURS          Numeric 4                                 BN15.1
Element: Min Hours     This field is the minimum number of
                       hours that an employee must work in a
                       plan year to prevent the year from being
                       considered a break in service.

                       This field is only used with defined
                       contribution and defined benefit plans.

PLN-VEST-HOURS         Signed 7.2                                BN15.1
Element: Vest Hours    This field is the minimum number of
                       hours an employee must work in a plan
                       year in order to vest for the year.

                       This field is only used with defined
                       contribution and defined benefit plans.

PLN-INV-DIST-FLG       Alpha 1                                   BN15.1
Element: Inv Dist Flg  This field determines if an employee is
                       able to choose the distribution of plan
                       contributions to investment accounts.

                       This field is used only with defined
                       contribution plans.
                       N = No
                       Y = Yes

PLN-LAST-CMT-SEQ       Numeric 4                                 BN15.1  BN90.1
Element: Last Cmt Seq  This is the last sequence number of the
                       comments added for the plan.

PLN-PLAN-NAME          Alpha 10                                  BN15.1
Element: Plan          If using Time Accrual this is the name
                       of the vacation plan to be updated with
                       the number of hours bought or sold
                       through Benefits.

                       This field is only used with vacation
                       plans.

PLN-ACR-DIST-CO        Numeric 4                                 BN15.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PLN-ACR-ACCT-UNT       Alpha 15                                  BN15.1
Accrual Accounting     If COBRA participants and retirees are
Unit                   covered under the plan, this field is
                       the accrual accounting unit for the
                       plan. This field is only used with
                       health, dental, life, dependent life,
                       spending account plans.

PLN-ACR-ACCOUNT        Numeric 6                                 BN15.1
Element: Accrual AccounContains the accrual account for plans.

                       This field is only used with health,
                       dental, life, dependent life, and
                       spending account plans.

PLN-ACR-SUB-ACCT       Numeric 4                                 BN15.1
Element: Accrual SubaccContains the accrual subaccount for
                       health plans.

                       This field is used only with savings
                       bond plans.

PLN-BOND-VALUE         Signed 11.2                               BN15.1
Element: Bond Value    Contains the face value of the bond
                       that can be purchased under this plan.

                       This field is only used with savings
                       bond plans.

PLN-BOND-COST          Signed 11.2                               BN15.1
Element: Bond Cost     Contains the cost to the employee for
                       purchasing one bond of this value.

                       This field is used only with savings
                       bond plans.

PLN-CORE-BEN-FLG       Alpha 1                                   BN15.1
Element: Core Plan     Specifies whether the plan is the core
                       benefit under a flex plan.

                       This field is used for health, dental,
                       life, disability, and dependent life
                       plans. If yes is entered this field is
                       used only for health and dental plans.
                       N = No
                       S = Spouse
                       Y = Yes

PLN-AR-DIST-CO         Numeric 4                                 BN15.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PLN-AR-ACCT-UNIT       Alpha 15                                  BN15.1
Element: A/R AccountingThis field is the accounts receivable
                       account unit that contains the part of
                       the premium COBRA participants and
                       retirees, for the health plan.

                       This field is used only for health,
                       dental, life, dependent life, and
                       spending account plans.

PLN-AR-ACCOUNT         Numeric 6                                 BN15.1
Element: A/R Account   This field is the accounts receivable
                       account that contains the part of the
                       premium COBRA participants and retirees,
                       for the health plan.

                       This field is used only for health,
                       dental, life, dependent life, and
                       spending account plans.

PLN-AR-SUB-ACCT        Numeric 4                                 BN15.1
Element: A/R SubaccountSee PLN-AR-ACCT-UNIT.

                       This field is used only with health,
                       dental, life, dependent life, and
                       spending account plans.

PLN-EXP-DIST-CO        Numeric 4                                 BN15.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PLN-EXP-ACCT-UNT       Alpha 15                                  BN15.1
Expense Accounting     If retirees are covered under the
Unit                   health plan, this is the expense account
                       that contains the expense amount.

                       This field is used only with health,
                       dental, life, dependent life, and
                       spending account plans.

PLN-EXP-ACCOUNT        Numeric 6                                 BN15.1
Element: Expense AccounSee PLN-EXP-ACCT-UNT.

                       This field is used only with health,
                       dental, life, dependent life, and
                       spending account plans.

PLN-EXP-SUB-ACCT       Numeric 4                                 BN15.1
Element: Expense SubaccSee PLN-EXP-ACCT-UNT.

                       This field is used only with health,
                       dental, life, dependent life, and
                       spending account plans.

PLN-GRP-LIFE-FLG       Alpha 1                                   BN15.1
Element: Reportable LifThis field flags a plan as being a
                       group life plan.  If the plan if group
                       term life, coverage under the plan will
                       be included in the calculations of
                       excess life insurance cost for
                       employees.

                       This field is used only with life and
                       dependent life plans.
                       N = No
                       Y = Yes

PLN-INCREMENT          Signed 5.2                                BN15.1
Element: Increment     Regulates the percent increments that
                       the employee can elect for distribution
                       for the defined contribution account
                       funds on the plan.

PLN-PAY-EXP-FLAG       Numeric 1                                 BN15.1
Element: Pay Exp Flag  Identifies whether an employee can be
                       reimbursed for expenses up to the
                       employee's contribution-to-date amount
                       (less withdrawals-to-date) or up to the
                       amount to be contributed for the entire
                       plan year or if system displays a
                       warning only.

                       This field is used with spending
                       account plans only.
                       1 = Stop at Annual Limit
                       2 = Stop at Current Limit
                       3 = Warning over Annual Limit
                       4 = Warning over Current Limit
                       5 = None

PLN-DED-FREQ-FLAG      Numeric 1                                 BN04.1  BN104
Element: Frequency TablThis field is updated when the            BN15.1
                       deduction frequency table is changed.
                       Run BN104 (Deduction Frequency Update)
                       when the flag is set to one.
                       0 = Not Updated
                       1 = Updated

PLN-FLEX-PAY-CODE      Alpha 4                                   BN15.1
Element: Flex Pay Code Contains the plan's flex credit pay
                       code.

PLN-FLEX-DED-CODE      Alpha 4                                   BN15.1
Element: Flex Ded Code Contains the plan's flex company
                       deduction.

PLN-COBRA-COVERED      Alpha 1                                   BN15.1
Element: Cobra Covered Indicates whether COBRA participants
                       can elect benefits under a plan. This
                       field is only used with health, dental,
                       life, and spending account plans.
                       Y = Yes
                       N = No

PLN-INS-CARRIER        Alpha 4                                   BN15.1
Element: Ins Carrier   Contains the insurance carrier assigned
                       to the plan.

PLN-CONTRACT-NMBR      Alpha 30                                  BN15.1
Element: Contract Nmbr Contains the contract the number of the
                       insurance plan.

PLN-COMP-CLASS         Alpha 3                                   BN15.1
Element: Comp Class    Contains the pay class used to keep
                       track of an employee's covered
                       compensation.

                       This field is used for defined
                       contribution and defined benefit plans.

PLN-MAX-COMP-LIMIT     Alpha 1                                   BN15.1
Element: Max Comp LimitIndicates whether the maximum
                       compensation limit for 401k and 403b
                       plans is checked by PR140 (Earning and
                       Deductions Calculations). If yes is
                       entered, deductions stop when the
                       maximum compensation limit is met.

                       The maximum compensation limit is
                       defined in the Benefit Limits file.

                       This field is used only with defined
                       contribution plans.
                       Y = First limit met; comp or addt
                       N = Annual additions limit only
                       B = Do not apply either limit

PLN-WAIVE-FLAG         Alpha 1                                   BN15.1
Element: Waive Flag    Indicates whether the plan is a waive
                       plan.

                       A waive plan tracks employees who do
                       not elect coverage.
                       N = No
                       Y = Yes

PLN-VEST-CLASS         Alpha 3                                   BN15.1
Element: Vest Class    Contains the pay class that keeps track
                       of the number of vesting hours each
                       employee accumulates for a year.

                       This field is used with defined
                       contribution plans only.

PLN-CHG-ELIG           Alpha 1                                   BN15.1
Element: Chg Elig      This field is not used.
                       0 = Changed
                       1 = Not Changed

PLN-DEFAULT            Alpha 1                                   BN15.1
Element: Default       Indicates whether benefits should
                       automatically be added to an employee
                       who is eligible for a plan. This field
                       is used by BN100 (Employee Change
                       Benefit Update) and BN101 (Mass Benefit
                       Add).
                       A = Always Default
                       T = Default for Plan Type
                       O = Default for Plan Option
                       N = Do Not Default
                       C = Default for Plan Category

PLN-COVERAGE-TYPE      Alpha 2                                   BN15.1
Element: Coverage Type Defines the type of coverage for
                       benefits under a plan. If coverage
                       options are used, the user will define
                       coverage options the employee may elect.
                       If coverage amounts are used, the system
                       will calculate a dollar amount of
                       coverage.
                       0 = No Coverage
                       1 = Coverage Options
                       2 = Coverage Amount
                       X = Custom Calculation

PLN-CONTRIB-TYPE       Alpha 2                                   BN15.1
Element: Contrib Type  Defines the contribution type used by
                       the plan.
                       0 = No Contribution
                       1 = Options Amount
                       2 = Options Amount Range
                       3 = Flat Contributions
                       4 = Salary or Coverage Rate Table
                       5 = Contribution Limits
                       6 = Match Limit Schedule
                       7 = Match Percent Schedule
                       X = Custom Calculation

PLN-PRE-DED-CODE-A     Alpha 4                                   BN15.1
Element: Pre Ded Code AContains the pre-tax amount deduction
                       code.

PLN-AFT-LMT-DED-A      Alpha 4                                   BN15.1
Element: Aft Lmt Ded A Contains the after-limit amount
                       deduction code.

PLN-AFT-DED-CODE-A     Alpha 4                                   BN15.1
Element: Aft Ded Code AContains the after-tax amount deduction
                       code.

PLN-CMP-DED-CODE-A     Alpha 4                                   BN15.1
Element: Cmp Ded Code AContains the compensation amount
                       deduction code.

PLN-PRE-DED-CODE-P     Alpha 4                                   BN15.1
Element: Pre Ded Code PContains the pre-tax percent deduction.

PLN-AFT-LMT-DED-P      Alpha 4                                   BN15.1
Element: Aft Lmt Ded P Contains the after-limit percent
                       deduction code.

PLN-AFT-DED-CODE-P     Alpha 4                                   BN15.1
Element: Aft Ded Code PContains the after-limit percent
                       deduction code.

PLN-CMP-DED-CODE-P     Alpha 4                                   BN15.1
Element: Cmp Ded Code PContains the company percent deduction
                       code.

PLN-PRE-DED-MTCH-A     Alpha 4                                   BN15.1
Element: Pre Ded Mtch AContains the company match of the
                       pre-tax deduction amount.

PLN-AFT-LMT-MTCH-A     Alpha 4                                   BN15.1
Element: Aft Lmt Mtch AContains the company match of the
                       pre-tax percent deduction.

PLN-AFT-DED-MTCH-A     Alpha 4                                   BN15.1
Element: Aft Ded Mtch AContains the company match of the
                       after-limit percent deduction.

PLN-PRE-DED-MTCH-P     Alpha 4                                   BN15.1
Element: Pre Ded Mtch PContains the company match of the
                       pre-tax percent deduction.

PLN-AFT-LMT-MTCH-P     Alpha 4                                   BN15.1
Element: Aft Lmt Mtch PContains the company match of the
                       after-tax percent deduction.

PLN-AFT-DED-MTCH-P     Alpha 4                                   BN15.1
Element: Aft Ded Mtch PContains the company match of the
                       after-limit percent deduction.

PLN-DISPLAY-DESC       Alpha 15                                  BN15.1
Element: Display Desc  Contains the short plan description
                       displayed on benefit entry.

PLN-PLAN-TYPE-2        Derived
Element: Plan Type 2

PLN-CURRENCY-CODE      Alpha 5                                   BN15.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

PLN-CURR-ND            Numeric 1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


PLN-REGISTR-NBR        Alpha 7                                   BN15.1
Element: Registr Nbr   Contains the registration number.

PLN-COUNTRY-CODE       Alpha 2                                   BN15.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

PLN-SCON-NBR           Alpha 9                                   BN15.1
Element: Scon Nbr

PLN-CREATE-TRANS       Alpha 1                                   BN15.2
Element: Create Trans  Y = Yes
                       N = No

PLN-SPONSOR-ID         Alpha 30                                  BN15.2
Element: Sponsor Id

PLN-MEMBER-ID          Numeric 1                                 BN15.2
Element: Member Id

PLN-HIPAA-INS-CODE     Alpha 3                                   BN15.2
Element: Hipaa Ins CodeAG = Preventive Care
                       AH = 24 Hour Care
                       AJ = Medicare Risk
                       AK = Mental Health
                       DCP = Dental Capitation (DMO)
                       DEN = Dental
                       EPO = Exclusive Provider Org.
                       FAC = Facility
                       HE = Hearing
                       HLT = Health
                       HMO = Health Maint. Org.
                       LTC = Long Term Care
                       LTD = Long Term Disability
                       MM = Major Medical
                       MOD = Mail Order Drug
                       PDG = Prescription Drug
                       POS = Point of Service
                       PPO = Preferred Provider Org.
                       PRA = Practitioners
                       STD = Short Term Disability
                       UR = Utilization Review
                       VIS = Vision

                         PLAN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PLNSET1   COMPANY                                                BN00.1  BN02.5
          PLAN-TYPE                                              BN03.1  BN04.1
          PLAN-CODE                                              BN06.1  BN100
                                                                 BN101   BN102
                                                                 BN103   BN104
                                                                 BN105   BN106
                                                                 BN13.1  BN138
                                                                 BN140   BN141
                                                                 BN145   BN15.1
                                                                 BN15.2  BN150
                                                                 BN16.1  BN16.2
                                                                 BN16.3  BN16.4
                                                                 BN17.1  BN17.2
                                                                 BN17.3  BN18.1
                                                                 BN18.2  BN18.3
                                                                 ...

PLNSET2   COMPANY       KeyChange                                BN52.1  PR297
          PLAN-TYPE                                              PR299
          START-DATE*
          PLAN-CODE

PLNSET3   COMPANY       KeyChange                                BN52.1
          START-DATE*
          PLAN-TYPE
          PLAN-CODE

PLNSET4   COMPANY       Subset                                   BN104
          PLAN-TYPE     Where DED-FREQ-FLAG = Zeroes
          PLAN-CODE

PLNSET5   POST-CODE-TBL KeyChange                                BN11.1
          COMPANY
          PLAN-TYPE
          PLAN-CODE

PLNSET6   COMPANY       KeyChange                                BN04.1  BN100
          FLEX-PLAN
          PLAN-TYPE
          PLAN-CODE

PLNSET8   COMPANY       KeyChange                                BN04.1
          DED-TABLE
          PLAN-TYPE
          PLAN-CODE

                         PLAN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acr Account    GLMASTER     Required
                            When PLN-ACR-ACCT-UNT != Spaces
                            And  PLN-ACR-ACCOUNT  != Zeroes
                            And  PLN-ACR-SUB-ACCT != Zeroes

                            PLN-COMPANY           -> GLM-COMPANY
                            PLN-ACR-ACCT-UNT      -> GLM-ACCT-UNIT
                            PLN-ACR-ACCOUNT       -> GLM-ACCOUNT
                            PLN-ACR-SUB-ACCT      -> GLM-SUB-ACCOUNT

Aft Ded Code A DEDCODE      Required
                            When PLN-AFT-DED-CODE-A != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-AFT-DED-CODE-A    -> DDC-DED-CODE

Aft Ded Code P DEDCODE      Required
                            When PLN-AFT-DED-MTCH-P != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-AFT-DED-CODE-P    -> DDC-DED-CODE

Aft Ded Mtch A DEDCODE      Required
                            When PLN-AFT-DED-MTCH-A != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-AFT-DED-MTCH-A    -> DDC-DED-CODE

Aft Ded Mtch P DEDCODE      Required
                            When PLN-AFT-DED-MTCH-P != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-AFT-DED-MTCH-P    -> DDC-DED-CODE

Aft Lmt Ded A  DEDCODE      Required
                            When PLN-AFT-LMT-DED-A != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-AFT-LMT-DED-A     -> DDC-DED-CODE

Aft Lmt Ded P  DEDCODE      Required
                            When PLN-AFT-LMT-DED-P != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-AFT-LMT-DED-P     -> DDC-DED-CODE

Aft Lmt Mtch A DEDCODE      Required
                            When PLN-AFT-LMT-MTCH-A != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-AFT-LMT-MTCH-A    -> DDC-DED-CODE

Aft Lmt Mtch P DEDCODE      Required
                            When PLN-AFT-LMT-MTCH-P != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-AFT-DED-MTCH-P    -> DDC-DED-CODE

Ar Account     GLMASTER     Required
                            When PLN-AR-ACCT-UNIT != Spaces
                            And  PLN-AR-ACCOUNT   != Zeroes
                            And  PLN-AR-SUB-ACCT  != Zeroes

                            PLN-COMPANY           -> GLM-COMPANY
                            PLN-AR-ACCT-UNIT      -> GLM-ACCT-UNIT
                            PLN-AR-ACCOUNT        -> GLM-ACCOUNT
                            PLN-AR-SUB-ACCT       -> GLM-SUB-ACCOUNT

Cmp Ded Code A DEDCODE      Required
                            When PLN-CMP-DED-CODE-A != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-CMP-DED-CODE-A    -> DDC-DED-CODE

Cmp Ded Code P DEDCODE      Required
                            When PLN-CMP-DED-CODE-P != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-CMP-DED-CODE-P    -> DDC-DED-CODE

Comp Class     PAYCLASS     Required
                            When PLN-COMP-CLASS != Spaces

                            PLN-COMPANY           -> PCL-COMPANY
                            PLN-COMP-CLASS        -> PCL-PAY-CLASS

Company Name   PRSYSTEM     Required

                            PLN-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Country        INSTCTRYCD   Required

                            PLN-COUNTRY-CODE      -> INT-COUNTRY-CODE

Currency       CUCODES      Required
                            When PLN-CURRENCY-CODE != Spaces

                            PLN-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Ded Freq Table DEDFREQTBL   Required
                            When PLN-DED-TABLE != Spaces

                            PLN-COMPANY           -> DFT-COMPANY
                            PLN-DED-TABLE         -> DFT-TABLE-CODE

Exp Account    GLMASTER     Required
                            When PLN-EXP-ACCT-UNT != Spaces
                            And  PLN-EXP-ACCOUNT  != Zeroes
                            And  PLN-EXP-SUB-ACCT != Zeroes

                            PLN-COMPANY           -> GLM-COMPANY
                            PLN-EXP-ACCT-UNT      -> GLM-ACCT-UNIT
                            PLN-EXP-ACCOUNT       -> GLM-ACCOUNT
                            PLN-EXP-SUB-ACCT      -> GLM-SUB-ACCOUNT

Flex Ded Code  DEDCODE      Required
                            When PLN-FLEX-DED-CODE != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-FLEX-DED-CODE     -> DDC-DED-CODE

Flex Pay Code  PRPAYCODE    Required
                            When PLN-FLEX-PAY-CODE != Spaces

                            PLN-COMPANY           -> PCD-COMPANY
                            PLN-FLEX-PAY-CODE     -> PCD-PAY-CODE
                            Spaces                -> PCD-PROCESS-LEVEL
                            Spaces                -> PCD-JOB-CODE

Flexible Plan  FLEXPLAN     Required
                            When PLN-FLEX-PLAN != Spaces

                            PLN-COMPANY           -> FLP-COMPANY
                            PLN-FLEX-PLAN         -> FLP-FLEX-PLAN

Ins Carrier    BNCARRIER    Required
                            When PLN-INS-CARRIER != Spaces

                            PLN-INS-CARRIER       -> BCR-INS-CARRIER

Persgroup      PERSGROUP    Not Required

                            PLN-COMPANY           -> PRG-COMPANY
                            PLN-GROUP-NAME        -> PRG-GROUP-NAME

Personnel Grp  PERSGROUP    Required
                            When PLN-GROUP-NAME != Spaces

                            PLN-COMPANY           -> PRG-COMPANY
                            PLN-GROUP-NAME        -> PRG-GROUP-NAME

Plan Name      PLANMASTER   Required
                            When PLN-PLAN-NAME != Spaces

                            PLN-COMPANY           -> PLM-COMPANY
                            PLN-PLAN-NAME         -> PLM-PLAN-NAME

Pre Ded Code A DEDCODE      Required
                            When PLN-PRE-DED-CODE-A != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-PRE-DED-CODE-A    -> DDC-DED-CODE

Pre Ded Code P DEDCODE      Required
                            When PLN-PRE-DED-CODE-P != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-PRE-DED-CODE-P    -> DDC-DED-CODE

Pre Ded Mtch A DEDCODE      Required
                            When PLN-PRE-DED-MTCH-A != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-PRE-DED-MTCH-A    -> DDC-DED-CODE

Pre Ded Mtch P DEDCODE      Required
                            When PLN-PRE-DED-MTCH-P != Spaces

                            PLN-COMPANY           -> DDC-COMPANY
                            PLN-PRE-DED-MTCH-P    -> DDC-DED-CODE

Prsystem       PRSYSTEM     Required

                            PLN-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Retiree Group  PERSGROUP    Not Required

                            PLN-COMPANY           -> PRG-COMPANY
                            PLN-RET-GROUP-NAME    -> PRG-GROUP-NAME

Vest Class     PAYCLASS     Required
                            When PLN-VEST-CLASS != Spaces

                            PLN-COMPANY           -> PCL-COMPANY
                            PLN-VEST-CLASS        -> PCL-PAY-CLASS

Vesting Sched  VESTSCHDHD   Required

                            PLN-COMPANY           -> VSH-COMPANY
                            PLN-VEST-SCHED        -> VSH-VEST-SCHED

                         PLAN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Benefit        BENEFIT      Delete Restricted

                            PLN-COMPANY           -> BEN-COMPANY
                            PLN-PLAN-TYPE         -> BEN-PLAN-TYPE
                            PLN-PLAN-CODE         -> BEN-PLAN-CODE
                                                     BEN-EMPLOYEE
                                                     BEN-START-DATE

Bn Ta Group    BNTAGROUP    Delete Cascades
                            Valid When PLN-PLAN-NAME != Spaces

                            PLN-COMPANY           -> BTG-COMPANY
                            PLN-PLAN-CODE         -> BTG-PLAN-CODE
                            PLN-PLAN-NAME         -> BTG-TA-PLAN
                                                     BTG-EMPLOYEE-GROUP

Bnaccounts     BNACCOUNTS

                            PLN-COMPANY           -> BNA-COMPANY
                            PLN-PLAN-TYPE         -> BNA-PLAN-TYPE
                            PLN-PLAN-CODE         -> BNA-PLAN-CODE
                                                     BNA-START-DATE
                                                     BNA-GROUP-NAME
                                                     BNA-DED-CODE

Bncovdft       BNCOVDFT     Delete Cascades

                            PLN-COMPANY           -> BCD-COMPANY
                            PLN-PLAN-TYPE         -> BCD-PLAN-TYPE
                            PLN-PLAN-CODE         -> BCD-PLAN-CODE
                                                     BCD-COVER-TYPE
                                                     BCD-START-DATE
                                                     BCD-GROUP-NAME
                                                     BCD-COVERAGE-OPT

Bncoverage     BNCOVERAGE   Delete Cascades

                            PLN-COMPANY           -> CVR-COMPANY
                            PLN-PLAN-TYPE         -> CVR-PLAN-TYPE
                            PLN-PLAN-CODE         -> CVR-PLAN-CODE
                                                     CVR-COVER-TYPE
                                                     CVR-START-DATE
                                                     CVR-GROUP-NAME

Bncovopt       BNCOVOPT     Delete Cascades

                            PLN-COMPANY           -> COP-COMPANY
                            PLN-PLAN-TYPE         -> COP-PLAN-TYPE
                            PLN-PLAN-CODE         -> COP-PLAN-CODE
                                                     COP-COVERAGE-OPT

Bnprmopt       BNPRMOPT     Delete Cascades

                            PLN-COMPANY           -> PCV-COMPANY
                            PLN-PLAN-TYPE         -> PCV-PLAN-TYPE
                            PLN-PLAN-CODE         -> PCV-PLAN-CODE
                                                     PCV-COVER-TYPE
                                                     PCV-START-DATE
                                                     PCV-GROUP-NAME
                                                     PCV-COVERAGE-OPT

Bnwait         BNWAIT

                            PLN-COMPANY           -> BWT-COMPANY
                            Spaces                -> BWT-RULE-TYPE
                            PLN-PLAN-TYPE         -> BWT-PLAN-TYPE
                            PLN-PLAN-CODE         -> BWT-PLAN-CODE
                                                     BWT-START-DATE
                                                     BWT-GROUP-NAME
                                                     BWT-ACTION-CODE

Cobra Benefits PARTBEN

                            PLN-COMPANY           -> PTB-COMPANY
                            PLN-PLAN-TYPE         -> PTB-PLAN-TYPE
                            PLN-PLAN-CODE         -> PTB-PLAN-CODE
                                                     PTB-PARTICIPNT
                                                     PTB-EMPLOYEE
                                                     PTB-START-DATE

Comments       BNCOMMENTS   Delete Restricted

                            PLN-COMPANY           -> BCM-COMPANY
                            "PL"                  -> BCM-CMT-TYPE
                            Zeroes                -> BCM-EMPLOYEE
                            Zeroes                -> BCM-PARTICIPNT
                            PLN-PLAN-TYPE         -> BCM-PLAN-TYPE
                            PLN-PLAN-CODE         -> BCM-PLAN-CODE
                            Spaces                -> BCM-GROUP-NAME
                            Zeroes                -> BCM-START-DATE
                                                     BCM-SEQ-NBR

Investment     BNINVEST     Delete Restricted

                            PLN-COMPANY           -> BIV-COMPANY
                            PLN-PLAN-CODE         -> BIV-PLAN-CODE
                                                     BIV-SEQ-NBR

Partben        PARTBEN

                            PLN-COMPANY           -> PTB-COMPANY
                            PLN-PLAN-TYPE         -> PTB-PLAN-TYPE
                            PLN-PLAN-CODE         -> PTB-PLAN-CODE
                                                     PTB-PARTICIPNT
                                                     PTB-EMPLOYEE
                                                     PTB-START-DATE

Postal Code    BNPOSTCODE
                            Valid When PLN-POST-CODE-TBL != Spaces

                            PLN-POST-CODE-TBL     -> BPC-POST-CODE-TBL
                                                     BPC-POSTAL-CODE

Premium        PREMIUM      Delete Cascades

                            PLN-COMPANY           -> PRE-COMPANY
                            PLN-PLAN-TYPE         -> PRE-PLAN-TYPE
                            PLN-PLAN-CODE         -> PRE-PLAN-CODE
                                                     PRE-COVER-TYPE
                                                     PRE-START-DATE
                                                     PRE-GROUP-NAME

Retiree Ben    PARTBEN

                            PLN-COMPANY           -> PTB-COMPANY
                            PLN-PLAN-TYPE         -> PTB-PLAN-TYPE
                            PLN-PLAN-CODE         -> PTB-PLAN-CODE
                                                     PTB-PARTICIPNT
                                                     PTB-EMPLOYEE
                                                     PTB-START-DATE

Wait Rules     BNWAIT

                            PLN-COMPANY           -> BWT-COMPANY
                            PLN-PLAN-TYPE         -> BWT-PLAN-TYPE
                            PLN-PLAN-CODE         -> BWT-PLAN-CODE
                                                     BWT-RULE-TYPE
                                                     BWT-START-DATE
                                                     BWT-GROUP-NAME
                                                     BWT-ACTION-CODE