Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RATETBLHDR


                            RATETBLHDR FILE

                           Rate Table Header

The Rate Table Header file contains the start date and the description of the
rate table for the Rate Table file.

REFERENCED BY

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

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RTH-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.

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

RTH-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

RTH-TABLE-TYPE         Alpha 2                                   BN02.1  BN02.2
Element: Table Type    Table type is used to uniquely define a   BN02.3  BN02.4
                       percent table record for depreciation     BN02.5  BN18.3
                       calculation purposes. This field allows   BN18.4
                       you to define more than one table for
                       any given in-service year and month.
                       Blanks are valid as a table type value.
                       1 = Age
                       2 = Salary
                       3 = Years of Service
                       4 = Coverage Reduction
                       5 = Flex Credits
                       X = Custom Calculation

RTH-DESC               Alpha 30  (Lower Case)                    BN02.1  BN02.2
Element: Description   Contains a description of the rate        BN02.3  BN02.4
                       table.                                    BN02.5  BN18.3
                                                                 BN18.4

RTH-PCT-RATE-FLG       Alpha 1                                   BN02.1  BN02.2
Element: Basis         Determines whether the insurance is a     BN02.3  BN02.4
                       percent or a rate per dollars of          BN02.5
                       coverage.
                       P = Percent
                       A = Amount

RTH-CURRENCY-CODE      Alpha 5                                   BN02.1  BN02.2
Element: Currency Code This field contains the company base      BN02.3  BN02.4
                       currency code established in Company      BN02.5
                       (GL10.1 ).

RTH-CURR-ND            Numeric 1                                 BN02.1  BN02.2
Account Currency                                                 BN02.3  BN02.4
Code                                                             BN02.5

                         RATETBLHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RTHSET1   COMPANY                                                BN00.1  BN02.1
          TABLE-CODE                                             BN02.2  BN02.3
          START-DATE                                             BN02.4  BN02.5
                                                                 BN08.1  BN100
                                                                 BN101   BN102
                                                                 BN103   BN104
                                                                 BN105   BN145
                                                                 BN15.1  BN17.3
                                                                 BN18.1  BN18.2
                                                                 BN18.3  BN18.4
                                                                 BN18.5  BN18.6
                                                                 BN18.7  BN19.1
                                                                 BN19.2  BN215
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 ...

RTHSET2   COMPANY                                                BN100   BN101
          TABLE-CODE                                             BN102   BN103
          START-DATE*                                            BN105   BN245
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN320
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1

RTHSET3   COMPANY                                                BN02.1  BN02.2
          TABLE-TYPE                                             BN02.3  BN02.4
          TABLE-CODE                                             BN02.5  BN202
          START-DATE                                             BN206

                         RATETBLHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            RTH-COMPANY          -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            RTH-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required

                            RTH-CURRENCY-CODE    -> CUC-CURRENCY-CODE

                         RATETBLHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ratetbldtl     RATETBLDTL

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