Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              PREMIUM FILE

                          Benefit Plan Premium

The Benefit Plan Premium file contains contributions for a benefit plan. It
includes premiums for employees, retirees, and COBRA participants.

REFERENCED BY

BN100     BN101     BN102     BN103     BN145     BN17.1
BN180     BN220     BN242     BN245     BN31.1    BN31.2
BN32.1    BN32.2    BN32.3    BN331     BN45.1    BN531
BN65.1    BN71.1    BN72.1    BS09.1    BS10.1    BS11.1
BS12.1    BS13.1    BS14.1    BS15.1    BS32.1    HR55.1
PRBN.1    BN215     BN230

UPDATED BY

BN00.1    BN02.1    BN02.2    BN02.3    BN02.4    BN02.5
BN105     BN15.1    BN18.1    BN18.2    BN18.3    BN18.4
BN18.5    BN18.6    BN18.7    BN19.1    BN19.2    BN19.3
BN19.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PRE-COMPANY          Numeric 4                                   BN15.1  BN18.1
Company              Contains the company number.                BN18.2  BN18.3
                                                                 BN18.4  BN18.5
                                                                 BN18.6  BN18.7
                                                                 BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-PLAN-TYPE        Alpha 2                                     BN15.1  BN18.1
Type                 Contains the type of benefit plan.          BN18.2  BN18.3
                     HL = Health                                 BN18.4  BN18.5
                     DN = Dental                                 BN18.6  BN18.7
                     DI = Disability                             BN19.1  BN19.2
                     EL = Life                                   BN19.3  BN19.4
                     DL = Dependent Life
                     DC = Defined Contribution
                     DB = Defined Benefit
                     VA = Vacation
                     RS = Spending Account
                     SB = Savings Bond
                     SP = Stock Purchase

PRE-PLAN-CODE        Alpha 4                                     BN15.1  BN18.1
Plan                 Contains a user-defined field used to       BN18.2  BN18.3
                     represent a specific plan.                  BN18.4  BN18.5
                                                                 BN18.6  BN18.7
                                                                 BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-START-DATE       Numeric 8  (yyyymmdd)                       BN15.1  BN18.1
Start Date           Contains the start date for the premium     BN18.2  BN18.3
                     record.                                     BN18.4  BN18.5
                                                                 BN18.6  BN18.7
                                                                 BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-GROUP-NAME       Alpha 10                                    BN15.1  BN18.1
Group Name           Contains the group that uses the            BN18.2  BN18.3
                     contribution record. This field may         BN18.4  BN18.5
                     contain spaces.                             BN18.6  BN18.7
                                                                 BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-CONTRIB-TYPE     Alpha 2                                     BN15.1  BN18.1
Contrib Type         Contains the contribution type. It must     BN18.2  BN18.3
                     match the plan contribution type.           BN18.4  BN18.5
                     1 = Option Amounts                          BN18.6  BN18.7
                     2 = Option Rate Table                       BN19.1  BN19.2
                     3 = Amount                                  BN19.3  BN19.4
                     4 = Coverage or Salary Rate Table
                     5 = Contribution Limits
                     6 = Service Schedule
                     7 = Percent Schedule
                     X = Custom Calculation

PRE-CALC-TYPE        Alpha 1                                     BN15.1  BN18.1
Calculation Type     Determines how the contribution is          BN18.2  BN18.3
                     calculated.                                 BN18.4  BN18.5
                     1 = Flat Amount                             BN18.6  BN18.7
                     2 = Flat Percent                            BN19.1  BN19.2
                     3 = Percent of Salary
                     4 = Rate Table
                     X = Custom Calculation

PRE-SALARY-TYPE      Alpha 2                                     BN15.1  BN18.1
Salary Type          If contributions are based on salary,       BN18.2  BN18.3
                     this field determines the salary to be      BN18.4  BN18.5
                     used.                                       BN18.6  BN18.7
                     EM = HR11 Salary                            BN19.1  BN19.2
                     B1 = Benefit Salary 1                       BN19.3  BN19.4
                     B2 = Benefit Salary 2
                     B3 = Benefit Salary 3
                     B4 = Benefit Salary 4
                     B5 = Benefit Salary 5
                     E1 = HR11 and Ben Sal 1
                     E2 = HR11 and Ben Sal 2
                     E3 = HR11 and Ben Sal 3
                     E4 = HR11 and Ben Sal 4
                     E5 = HR11 and Ben Sal 5
                     X = Custom Calculation
                     FL = Flex Salary

PRE-SALARY-DATE      Numeric 4  (mmdd)                           BN15.1  BN18.1
Salary Date          If contributions are based on salary        BN18.2  BN18.3
                     and if the salary first month is an "as     BN18.4  BN18.5
                     of" date, this field contains the month     BN18.6  BN18.7
                     and day the salary should be determined.    BN19.1  BN19.2
                     This field may be used with the salary      BN19.3  BN19.4
                     year.

PRE-SAL-FIRST-MO     Alpha 1                                     BN15.1  BN18.1
Sal First Mo         If contributions are based on salary,       BN18.2  BN18.3
                     this field determines the salary            BN18.4  BN18.5
                     calculation date.                           BN18.6  BN18.7
                     C = Current                                 BN19.1  BN19.2
                     M = First of Month                          BN19.3  BN19.4
                     A = As of Date
                     F = Flex Calc Date

PRE-ROUND-METH       Alpha 1                                     BN15.1  BN18.1
Rounding Method      If contributions are based on salary,       BN18.2  BN18.3
                     this field contains the rounding method     BN18.4  BN18.5
                     used to calculate the annual salary.        BN18.6  BN18.7
                     H = High                                    BN19.1  BN19.2
                     L = Low                                     BN19.3  BN19.4
                     N = No Rounding
                     R = Normal

PRE-BEF-AFT-FLAG     Alpha 1                                     BN15.1  BN18.1
Before/After         If the contribution is based on salary,     BN18.2  BN18.3
                     this field indicates if rounding is done    BN18.4  BN18.5
                     before or after multiplying salary.         BN18.6  BN18.7
                     A = After                                   BN19.1  BN19.2
                     B = Before                                  BN19.3  BN19.4

PRE-ROUND-TO         Signed 9.4                                  BN15.1  BN18.1
Round To             If contributions are based on salary,       BN18.2  BN18.3
                     this field determines the place to which    BN18.4  BN18.5
                     the salary is rounded; for example 1,       BN18.6  BN18.7
                     .1, .01, and so on.                         BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-AMT-MINIMUM      Signed 11.2                                 BN15.1  BN18.1
Amt Minimum          Indicates if the salary minimum amount      BN18.2  BN18.3
                     is used.                                    BN18.4  BN18.5
                                                                 BN18.6  BN18.7
                                                                 BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-AMT-MAXIMUM      Signed 11.2                                 BN15.1  BN18.1
Amt Maximum          Indicates if the salary maximum amount      BN18.2  BN18.3
                     is used.                                    BN18.4  BN18.5
                                                                 BN18.6  BN18.7
                                                                 BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-TABLE-TYPE       Alpha 2                                     BN15.1  BN18.1
Table Type           If the premium is tied to a rate table,     BN18.2  BN18.3
                     this field indicates the type of table      BN18.4  BN18.5
                     used.                                       BN18.6  BN18.7
                     1 = Age                                     BN19.2
                     2 = Salary
                     3 = Years of Service
                     X = Custom Calculation

PRE-EMP-SPS-AGE      Alpha 1                                     BN15.1  BN18.1
Emp Sps Age          If the contribution is based on age,        BN18.2  BN18.3
                     this field indicates whether the            BN18.4  BN18.5
                     contribution is base  on the employee       BN18.6  BN18.7
                     age or spouse age.                          BN19.2
                     E = Employee
                     S = Spouse

PRE-AGE-DATE         Numeric 4  (mmdd)                           BN15.1  BN18.1
Age Date             If the contribution is based on age,        BN18.2  BN18.3
                     this field contains the date for the "as    BN18.4  BN18.5
                     of" date.                                   BN18.6  BN18.7
                                                                 BN19.2

PRE-AGE-FIRST-MO     Alpha 1                                     BN15.1  BN18.1
Age First Mo         If the contribution is based on age,        BN18.2  BN18.3
                     this field contains indicates the date      BN18.4  BN18.5
                     used to calculate the age.                  BN18.6  BN18.7
                     C = Current                                 BN19.2
                     M = First of Month
                     A = As of Date
                     F = Flex Calc Date

PRE-FROM-DATE        Alpha 2                                     BN15.1  BN18.1
From Date            If the contribution is based on             BN18.2  BN18.3
                     service, this field is used to calculate    BN18.4  BN18.5
                     the years of service.                       BN18.6  BN18.7
                     HI = Hire Date                              BN19.2  BN19.3
                     AJ = Adjusted Hire Date                     BN19.4
                     AN = Anniversary Date
                     SN = Seniority Date
                     B1 = Benefit Date 1
                     B2 = Benefit Date 2
                     B3 = Benefit Date 3
                     B4 = Benefit Date 4
                     B5 = Benefit Date 5
                     X = Custom Calculation

PRE-SERV-DATE        Numeric 4  (mmdd)                           BN15.1  BN18.1
Serv Date            If the contribution is based on             BN18.2  BN18.3
                     service, this field contains the date       BN18.4  BN18.5
                     through which the service is calculated.    BN18.6  BN18.7
                                                                 BN19.2  BN19.3

PRE-SERV-FIRST-MO    Alpha 1                                     BN15.1  BN18.1
Serv First Mo        If contributions are based on service,      BN18.2  BN18.3
                     this  field contains the date through       BN18.4  BN18.5
                     which the years of service is               BN18.6  BN18.7
                     calculated.                                 BN19.2  BN19.3
                     C = Current
                     M = First of Month
                     A = As of Date
                     F = Flex Calc Date

PRE-EMP-CONT         Signed 7.2                                  BN15.1  BN18.1
Emp Cont             If the contribution type is a flat          BN18.2  BN18.3
                     contribution, this field contains the       BN18.4  BN18.5
                     employee contribution amount.               BN18.6  BN18.7

PRE-COMP-CONT        Signed 7.2                                  BN15.1  BN18.1
Company Contribution If the contribution type is a flat          BN18.2  BN18.3
                     contribution, this field contains the       BN18.4  BN18.5
                     company contribution.                       BN18.6  BN18.7

PRE-FLEX-CONT        Signed 7.2                                  BN15.1  BN18.1
Flex Cont            If the contribution type is a flat          BN18.2  BN18.3
                     contribution, this field contains the       BN18.4  BN18.5
                     flex credit contribution.                   BN18.6  BN18.7

PRE-RATE-TABLE       Alpha 4                                     BN15.1  BN18.1
Rate Table           Indicates the rate table used to            BN18.2  BN18.3
                     calculate contributions for the plan.       BN18.4  BN18.5
                     This field is used only for flat            BN18.6  BN18.7
                     contributions and for salary or coverage
                     rate table contributions.

PRE-CONTRIB-BASIS    Alpha 1                                     BN15.1  BN18.1
Contrib Basis        If the contribution type is salary or       BN18.2  BN18.3
                     coverage rate table, this field             BN18.4  BN18.5
                     indicates if the contribution is based      BN18.6  BN18.7
                     on the salary or coverage amount on the
                     benefit.
                     C = Coverage
                     S = Salary

PRE-COST-PER-CVG     Signed 9.2                                  BN15.1  BN18.1
Premium Per Dollars  If the premium is calculated by a rate      BN18.2  BN18.3
                     per dollars of coverage, this is the        BN18.4  BN18.5
                     amount on which the rate is based.          BN18.6  BN18.7

PRE-ANN-AMT-MIN      Signed 11.2                                 BN15.1  BN18.1
Ann Amt Min          If the contribution type is a               BN18.2  BN18.3
                     contribution limit, this field contains     BN18.4  BN18.5
                     the minimum annual amount.                  BN18.6  BN18.7

PRE-ANN-AMT-MAX      Signed 11.2                                 BN15.1  BN18.1
Ann Amt Max          If the contribution type is                 BN18.2  BN18.3
                     contribution limit, this field contains     BN18.4  BN18.5
                     the maximum annual amount.                  BN18.6  BN18.7

PRE-PCT-MINIMUM      Signed 5.2                                  BN15.1  BN18.1
Pct Minimum          If the contribution type is                 BN18.2  BN18.3
                     contribution limit, this field contains     BN18.4  BN18.5
                     the minimum annual percent.                 BN18.6  BN18.7

PRE-PCT-MAXIMUM      Signed 5.2                                  BN15.1  BN18.1
Pct Maximum          If the contribution type is                 BN18.2  BN18.3
                     contribution limit, this field contains     BN18.4  BN18.5
                     the maximum annual percent.                 BN18.6  BN18.7

PRE-COMP-AMT         Signed 7.2                                  BN15.1  BN18.1
Comp Amt             If the contribution type is                 BN18.2  BN18.3
                     contribution limit, this field contains     BN18.4  BN18.5
                     the company amount contribution.            BN18.6  BN18.7

PRE-COMP-PCT         Signed 5.2                                  BN15.1  BN18.1
Comp Pct             If the contribution type is                 BN18.2  BN18.3
                     contribution limit, this field contains     BN18.4  BN18.5
                     the company percent contribution.           BN18.6  BN18.7

PRE-VAC-MAX-HOURS    Signed 6.3                                  BN15.1  BN18.1
Vac Max Hours        If the plan type is vacation and the        BN18.2  BN18.3
                     contribution type is contribution limit,    BN18.4  BN18.5
                     this field contains the maximum vacation    BN18.6  BN18.7
                     hours that can be bought or sold.

PRE-VAC-COST         Signed 5.2                                  BN15.1  BN18.1
Cost                 If the plan type is vacation and the        BN18.2  BN18.3
                     contribution type is contribution limit,    BN18.4  BN18.5
                     this field contains the cost of each        BN18.6  BN18.7
                     hour purchased or sold.

PRE-INCREMENT        Signed 5.2                                  BN15.1  BN18.1
Percent Increments   If the contribution type is match limit     BN18.2  BN18.3
                     schedule or match percent schedule, this    BN18.4  BN18.5
                     field contains the increments an            BN18.6  BN18.7
                     employee must elect.                        BN19.3  BN19.4

PRE-EMP-CONT-TYPE    Alpha 1                                     BN15.1  BN18.1
Emp Cont Type        If the contribution type is match limit     BN18.2  BN18.3
                     schedule or match percent schedule, this    BN18.4  BN18.5
                     field indicates the type of employee        BN18.6  BN18.7
                     contribution.                               BN19.3  BN19.4
                     A = Amount
                     P = Percent
                     B = Both
                     N = No Contribution

PRE-CONT-TAX-STS     Alpha 1                                     BN15.1  BN18.1
Cont Tax Sts         Indicates how an employee can               BN18.2  BN18.3
                     contribute.                                 BN18.4  BN18.5
                     P = Pre-Tax                                 BN18.6  BN18.7
                     A = After-Tax                               BN19.1  BN19.2
                     B = Both                                    BN19.3  BN19.4
                     N = No Contribution

PRE-MATCH-OPTION     Alpha 1                                     BN15.1  BN18.1
Match Option         If the contribution type is match limit     BN18.2  BN18.3
                     schedule or match percent schedule, this    BN18.4  BN18.5
                     field indicates which contributions are     BN18.6  BN18.7
                     matched.                                    BN19.3  BN19.4
                     P = Pre-Tax
                     A = After-Tax
                     B = Both

PRE-MATCH-CALC       Alpha 1                                     BN15.1  BN18.1
Match Calc           If the contribution type is match           BN18.2  BN18.3
                     percent schedule, this field indicates      BN18.4  BN18.5
                     how the match is determined.                BN18.6  BN18.7
                     C = Cumulative                              BN19.4
                     F = Fixed

PRE-END-PCT          Numeric 3                                   BN15.1  BN18.1
End Pct              If the contribution type is match           BN18.2  BN18.3
                     percent schedule, this field indicates      BN18.4  BN18.5
                     the maximum contribution percent.           BN18.6  BN18.7
                                                                 BN19.4

PRE-E-COMP-CONT1     Signed 7.2                                  BN15.1  BN18.1
Company - Single     This field is not used.                     BN18.2  BN18.3
                                                                 BN18.4  BN18.5
                                                                 BN18.6  BN18.7

PRE-R-COMP-CONT1     Signed 7.2                                  BN15.1  BN18.1
Company - Single     This field is not used.                     BN18.2  BN18.3
                                                                 BN18.4  BN18.5
                                                                 BN18.6  BN18.7

PRE-RET-RATE-TBL     Alpha 2                                     BN15.1  BN18.1
Retiree Rate Table   This field is not used.                     BN18.2  BN18.3
                                                                 BN18.4  BN18.5
                                                                 BN18.6  BN18.7

PRE-STATUS           Numeric 1                                   BN02.1  BN02.2
Status               This field is not used.                     BN02.3  BN02.4
                     0 = New Group New Date                      BN02.5  BN105
                     1 = Existing Group New Date                 BN15.1  BN18.1
                     2 = Change Existing Record                  BN18.2  BN18.3
                     3 = Updated                                 BN18.4  BN18.5
                                                                 BN18.6  BN18.7
                                                                 BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-RET-STATUS       Numeric 1                                   BN02.1  BN02.2
Retiree Premium      This field is not used.                     BN02.3  BN02.4
Status               0 = New Group New Date                      BN02.5  BN105
                     1 = Existing Group New Date                 BN15.1  BN18.1
                     2 = Change Existing Record                  BN18.2  BN18.3
                     3 = Updated                                 BN18.4  BN18.5
                                                                 BN18.6  BN18.7
                                                                 BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-EARLY-RT-AGE     Numeric 2                                   BN15.1  BN18.1
Early Retiree Age    This field is not used.                     BN18.2  BN18.3
                                                                 BN18.4  BN18.5
                                                                 BN18.6  BN18.7

PRE-REG-RT-AGE       Numeric 2                                   BN15.1  BN18.1
Regular Retiree Age  This field is not used.                     BN18.2  BN18.3
                                                                 BN18.4  BN18.5
                                                                 BN18.6  BN18.7

PRE-FLEX-CONT1       Signed 7.2                                  BN15.1  BN18.1
Flex Credits -       This field is not used.                     BN18.2  BN18.3
Single                                                           BN18.4  BN18.5
                                                                 BN18.6  BN18.7

PRE-DEFAUL-TAX-TYP   Alpha 1                                     BN15.1  BN18.1
Defaul Tax Typ       Contains the default contribution tax       BN18.2  BN18.3
                     type for the employee contribution.         BN18.4  BN18.5
                     P = Pre-Tax                                 BN18.6  BN18.7
                     A = After-Tax                               BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-SALARY-YEAR      Numeric 4                                   BN15.1  BN18.1
Salary Year          If contributions are based on salary        BN18.2  BN18.3
                     and an "as of" date is used, this field     BN18.4  BN18.5
                     contains the year.                          BN18.6  BN18.7
                                                                 BN19.1  BN19.2
                                                                 BN19.3  BN19.4

PRE-AGE-YEAR         Numeric 4                                   BN15.1  BN18.1
Age Year             If contributions are based on age and       BN18.2  BN18.3
                     an "as of" date, this field contains the    BN18.4  BN18.5
                     year.                                       BN18.6  BN18.7
                                                                 BN19.2

PRE-SERV-YEAR        Numeric 4                                   BN15.1  BN18.1
Serv Year            If contributions are based on a service     BN18.2  BN18.3
                     and an "as of" date, this field contains    BN18.4  BN18.5
                     the year.                                   BN18.6  BN18.7
                                                                 BN19.3

PRE-PAY-PER-MIN      Signed 6.2                                  BN15.1  BN18.1
Pay Per Min          If the contribution type is                 BN18.2  BN18.3
                     contribution limit, this field contains     BN18.4  BN18.5
                     the pay period minimum contribution         BN18.6  BN18.7
                     amount.

PRE-PAY-PER-MAX      Signed 6.2                                  BN15.1  BN18.1
Pay Per Max          If the contribution type is                 BN18.2  BN18.3
                     contribution limit, this field contains     BN18.4  BN18.5
                     the maximum pay period amount.              BN18.6  BN18.7

PRE-COVER-TYPE       Alpha 1                                     BN15.1  BN18.1
Cover Type           Indicates if the coverage is for            BN18.2  BN18.3
                     employees, retirees, or COBRA               BN18.4  BN18.5
                     participants for each premium record.       BN18.6  BN18.7
                     E = Employees                               BN19.1  BN19.2
                     R = Retirees                                BN19.3  BN19.4
                     C = COBRA

PRE-COBRA-STATUS     Numeric 1                                   BN02.1  BN02.2
Cobra Status         If the coverage type is COBRA, this         BN02.3  BN02.4
                     field indicates the status. If the          BN02.5  BN105
                     status is New Group New Record, Existing    BN15.1  BN18.1
                     Group New Date, or Change Existing          BN18.2  BN18.3
                     Record, the premium record must be          BN18.4  BN18.5
                     updated before an invoice can be            BN18.6  BN18.7
                     generated.                                  BN19.1  BN19.2
                     0 = New Group New Record                    BN19.3  BN19.4
                     1 = Existing Group New Date
                     2 = Change Existing Record
                     3 = Updated

                         PREMIUM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRESET1   COMPANY                                                BN00.1  BN02.1
          PLAN-TYPE                                              BN02.2  BN02.3
          PLAN-CODE                                              BN02.4  BN100
          COVER-TYPE                                             BN101   BN102
          START-DATE                                             BN103   BN105
          GROUP-NAME                                             BN145   BN15.1
                                                                 BN17.1  BN18.1
                                                                 BN18.2  BN18.3
                                                                 BN18.4  BN18.5
                                                                 BN18.6  BN18.7
                                                                 BN180   BN19.1
                                                                 BN19.2  BN19.3
                                                                 BN19.4  BN220
                                                                 BN242   BN245
                                                                 BN31.1  BN31.2
                                                                 ...

PRESET3   COMPANY                                                BN100   BN101
          PLAN-TYPE                                              BN102   BN103
          PLAN-CODE                                              BN105   BN145
          COVER-TYPE                                             BN215   BN230
          START-DATE*                                            BN245   BN31.1
          GROUP-NAME                                             BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN331   BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS09.1  BS10.1
                                                                 BS11.1  BS12.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1

PRESET5   COMPANY                                                BN18.1  BN18.2
          CONTRIB-TYPE                                           BN18.3  BN18.4
          PLAN-TYPE                                              BN18.5  BN18.6
          PLAN-CODE                                              BN18.7
          COVER-TYPE
          START-DATE
          GROUP-NAME

PRESET6   COMPANY       KeyChange                                BN02.1  BN02.2
          COVER-TYPE                                             BN02.3  BN02.4
          RATE-TABLE                                             BN02.5
          START-DATE
          PLAN-TYPE
          PLAN-CODE
          GROUP-NAME

PRESET7   COMPANY                                                BN15.1  BN18.1
          PLAN-TYPE                                              BN18.2  BN18.3
          PLAN-CODE                                              BN18.4  BN18.5
          COVER-TYPE                                             BN18.6  BN18.7
          GROUP-NAME                                             BN19.1  BN19.2
          START-DATE*                                            BN19.3  BN19.4

                         PREMIUM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Age Rate Table RATETBLHDR   Not Required
                            Valid When PRE-TABLE-TYPE = "1 "

                            PRE-COMPANY       -> RTH-COMPANY
                            PRE-RATE-TABLE    -> RTH-TABLE-CODE
                            PRE-START-DATE    -> RTH-START-DATE

Company        BNCOMPANY    Required

                            PRE-COMPANY       -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            PRE-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Contrib 0      PLAN         Required
                            When PRE-CONTRIB-TYPE = "0 "

                            PRE-COMPANY       -> PLN-COMPANY
                            PRE-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PRE-PLAN-CODE     -> PLN-PLAN-CODE

Contrib 1      PLAN         Required
                            When PRE-CONTRIB-TYPE = "1 "

                            PRE-COMPANY       -> PLN-COMPANY
                            PRE-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PRE-PLAN-CODE     -> PLN-PLAN-CODE

Contrib 2      PLAN         Required
                            When PRE-CONTRIB-TYPE = "2 "

                            PRE-COMPANY       -> PLN-COMPANY
                            PRE-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PRE-PLAN-CODE     -> PLN-PLAN-CODE

Contrib 3      PLAN         Required
                            When PRE-CONTRIB-TYPE = "3 "

                            PRE-COMPANY       -> PLN-COMPANY
                            PRE-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PRE-PLAN-CODE     -> PLN-PLAN-CODE

Contrib 4      PLAN         Required
                            When PRE-CONTRIB-TYPE = "4 "

                            PRE-COMPANY       -> PLN-COMPANY
                            PRE-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PRE-PLAN-CODE     -> PLN-PLAN-CODE

Contrib 5      PLAN         Required
                            When PRE-CONTRIB-TYPE = "5 "

                            PRE-COMPANY       -> PLN-COMPANY
                            PRE-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PRE-PLAN-CODE     -> PLN-PLAN-CODE

Contrib 6      PLAN         Required
                            When PRE-CONTRIB-TYPE = "6 "

                            PRE-COMPANY       -> PLN-COMPANY
                            PRE-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PRE-PLAN-CODE     -> PLN-PLAN-CODE

Contrib 7      PLAN         Required
                            When PRE-CONTRIB-TYPE = "7 "

                            PRE-COMPANY       -> PLN-COMPANY
                            PRE-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PRE-PLAN-CODE     -> PLN-PLAN-CODE

Contrib User   PLAN         Required
                            When PRE-CONTRIB-TYPE = "X "

                            PRE-COMPANY       -> PLN-COMPANY
                            PRE-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PRE-PLAN-CODE     -> PLN-PLAN-CODE

Persgroup      PERSGROUP    Not Required

                            PRE-COMPANY       -> PRG-COMPANY
                            PRE-GROUP-NAME    -> PRG-GROUP-NAME

Plan           PLAN         Required

                            PRE-COMPANY       -> PLN-COMPANY
                            PRE-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PRE-PLAN-CODE     -> PLN-PLAN-CODE

Prsystem       PRSYSTEM     Required

                            PRE-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Rate Table     RATETBLHDR   Not Required

                            PRE-COMPANY       -> RTH-COMPANY
                            PRE-RATE-TABLE    -> RTH-TABLE-CODE
                            PRE-START-DATE    -> RTH-START-DATE

Sal Rate Table RATETBLHDR   Not Required
                            Valid When PRE-TABLE-TYPE = "2 "

                            PRE-COMPANY       -> RTH-COMPANY
                            PRE-RATE-TABLE    -> RTH-TABLE-CODE
                            PRE-START-DATE    -> RTH-START-DATE

Serv Rate Tbl  RATETBLHDR   Not Required
                            Valid When PRE-TABLE-TYPE = "3 "

                            PRE-COMPANY       -> RTH-COMPANY
                            PRE-RATE-TABLE    -> RTH-TABLE-CODE
                            PRE-START-DATE    -> RTH-START-DATE

                         PREMIUM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bnprmopt       BNPRMOPT     Delete Cascades

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

Contrdetl      CONTRDETL

                            PRE-COMPANY       -> CND-COMPANY
                            PRE-PLAN-TYPE     -> CND-PLAN-TYPE
                            PRE-PLAN-CODE     -> CND-PLAN-CODE
                            PRE-START-DATE    -> CND-START-DATE
                            PRE-GROUP-NAME    -> CND-GROUP-NAME
                                                 CND-BEGIN-YEAR-PCT

Contrib Sch    CONTRDETL

                            PRE-COMPANY       -> CND-COMPANY
                            PRE-PLAN-TYPE     -> CND-PLAN-TYPE
                            PRE-PLAN-CODE     -> CND-PLAN-CODE
                            PRE-START-DATE    -> CND-START-DATE
                            PRE-GROUP-NAME    -> CND-GROUP-NAME
                                                 CND-BEGIN-YEAR-PCT

Rate Tbl Dtl   RATETBLDTL   Delete Restricted

                            PRE-COMPANY       -> RTD-COMPANY
                            PRE-RATE-TABLE    -> RTD-TABLE-CODE
                            PRE-START-DATE    -> RTD-START-DATE
                                                 RTD-BEG-AGE-YR-SAL
                                                 RTD-SMOKER