Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PREMIUM


                              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     BN104     BN145
BN17.1    BN180     BN220     BN242     BN245     BN31.1
BN31.2    BN32.1    BN32.2    BN32.3    BN320     BN331
BN340     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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Calculation TyDetermines 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
Element: 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
Element: 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
Element: 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
Element: Rounding MethoIf 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
Element: 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
Element: 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
Element: 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
Element: 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                                   BN100   BN15.1
Element: Table Type    If the premium is tied to a rate table,   BN18.1  BN18.2
                       this field indicates the type of table    BN18.3  BN18.4
                       used.                                     BN18.5  BN18.6
                       1 = Age                                   BN18.7  BN19.2
                       2 = Salary
                       3 = Years of Service
                       X = Custom Calculation

PRE-EMP-SPS-AGE        Alpha 1                                   BN15.1  BN18.1
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Company ContriIf 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
Element: 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
Element: 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
Element: 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
Element: Premium Per DoIf 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Percent IncremIf 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Company - SingThis 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
Element: Company - SingThis 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
Element: Retiree Rate TThis field is not used.                   BN18.2  BN18.3
                                                                 BN18.4  BN18.5
                                                                 BN18.6  BN18.7

PRE-STATUS             Numeric 1                                 BN02.1  BN02.2
Element: 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
Element: Early Retiree 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
Element: Regular RetireThis 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
Element: Defaul Tax TypContains 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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   BN104
          GROUP-NAME                                             BN105   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
                                                                 ...

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
                                                                 BN320   BN331
                                                                 BN340   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 RTH-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 PLN-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 RTH-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 RTH-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