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     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
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
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
Start 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
Beg Age Yr Sal       Contains 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
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
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
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
Coverage Percent     Contains the percent of coverage for
                     each age range.

RTD-COVER-AMT        Signed 11.2                                 BN02.5
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

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