Lawson Insight Technical Documentation

                            RATETBLDTL FILE

                           Rate Table Detail

The Rate Table Detail file contains information about rate tables.

BN02.1 (Rate Table) is the primary program that updates this file.

REFERENCED BY

BN15.1    BN17.3    BN18.1    BN18.2    BN18.3    BN18.4
BN18.5    BN18.6    BN18.7    BN19.1    BN19.2    BN202
BN206     BN320     BN100     BN101     BN102     BN103
BN105     BN145     BN245     BN31.1    BN31.2    BN32.1
BN32.2    BN32.3    BN45.1    BN531     BN65.1    BN71.1
BN72.1    BS13.1    BS14.1    BS15.1    BS32.1

UPDATED BY

BN00.1    BN02.1    BN02.2    BN02.3    BN02.4    BN02.5

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RTD-COMPANY            Numeric 4                                 BN02.1  BN02.2
Element: Company       Contains the company number. The number   BN02.3  BN02.4
                       correlates all information about the      BN02.5
                       company.

RTD-TABLE-CODE         Alpha 4                                   BN02.1  BN02.2
Element: Table Code    Contains the user-defined code that       BN02.3  BN02.4
                       represents a rate table.                  BN02.5

RTD-START-DATE         Numeric 8  (yyyymmdd)                     BN02.1  BN02.2
Element: Date          Contains the effective date of the rate   BN02.3  BN02.4
                       table.                                    BN02.5

RTD-BEG-AGE-YR-SAL     Numeric 13                                BN02.1  BN02.2
Element: Beg Age Yr SalContains the beginning value for a        BN02.3  BN02.4
                       range based on a rate table header type.  BN02.5

                       This value can be an age, year, or
                       salary.

RTD-SMOKER             Alpha 1                                   BN02.1  BN02.2
Element: Smoker        Indicates whether the rate table entry    BN02.3
                       is for smoking or non-smoking rates.
                       N = NO
                       Y = YES

RTD-EMP-RATE           Signed 9.4                                BN02.1  BN02.2
Element: Employee Rate Contains the employee rate or percent     BN02.3
                       used for the employee's contribution.

RTD-COMP-RATE          Signed 9.4                                BN02.1  BN02.2
Company Annual         Contains the company's rate or percent    BN02.3
Contrib Rate           of contribution.

RTD-FLEX-RATE          Signed 9.4                                BN02.1  BN02.2
Element: Flex Rate     Contains the amount of flex dollars       BN02.3  BN02.4
                       employees receive for choosing a
                       benefit.

                       Contains used for disability and
                       employee life/AD&D plans.

RTD-COVER-PCT          Signed 7.4                                BN02.5
Element: Coverage PerceContains the percent of coverage for
                       each age range.

RTD-COVER-AMT          Signed 11.2                               BN02.5
Element: Flat Amount

                         RATETBLDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RTDSET1   COMPANY                                                BN00.1  BN02.1
          TABLE-CODE                                             BN02.2  BN02.3
          START-DATE                                             BN02.4  BN02.5
          BEG-AGE-YR-SAL                                         BN15.1  BN17.3
          SMOKER                                                 BN18.1  BN18.2
                                                                 BN18.3  BN18.4
                                                                 BN18.5  BN18.6
                                                                 BN18.7  BN19.1
                                                                 BN19.2  BN202
                                                                 BN206   BN320

RTDSET2   COMPANY                                                BN100   BN101
          TABLE-CODE                                             BN102   BN103
          START-DATE                                             BN105   BN145
          SMOKER                                                 BN245   BN31.1
          BEG-AGE-YR-SAL*                                        BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1

                         RATETBLDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            RTD-COMPANY       -> BNC-COMPANY

Rate Table     RATETBLHDR   Required

                            RTD-COMPANY       -> RTH-COMPANY
                            RTD-TABLE-CODE    -> RTH-TABLE-CODE
                            RTD-START-DATE    -> RTH-START-DATE