RATETBLHDR – Rate Table Header

System
Benefits (BN)
Prefix
RTH
Primary key
COMPANY, TABLE-CODE, START-DATE
Fields
14
Updated by
6 programs
Referenced by
47 programs

RATETBLHDR is the Rate Table Header table in Lawson Benefits (prefix RTH). It is indexed by COMPANY, TABLE-CODE, START-DATE (RTHSET1); alternate indexes: RTHSET2 and RTHSET3. It is related 1:1 to BNCOMPANY, PRSYSTEM and CUCODES and 1:M to RATETBLDTL. It is updated by BN00.1, BN02.1, BN02.2, BN02.3, BN02.4 and BN02.5 and referenced by BN08.1, BN100, BN101, BN102, BN103, BN104, BN105, BN145 and 39 more. The table has 14 fields, 3 indexes and 4 documented relations.

About RATETBLHDR

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

Fields (14)

Column = COBOL field name without the RTH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
RTH-COMPANY PK
COMPANY		Numeric 4Contains the company number. The number correlates all information about the company.BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-TABLE-CODE PK
TABLE_CODE		Alpha 4Contains a user-defined code that represents a rate table.BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the effective date of the rate table.BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-TABLE-TYPE
TABLE_TYPE		Alpha 2Table type is used to uniquely define a percent table record for depreciation calculation purposes. This field allows 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
BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN18.3, BN18.4
RTH-DESC
DESC		Alpha 30 (Lower Case)Contains a description of the rate table.BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN18.3, BN18.4
RTH-PCT-RATE-FLG
PCT_RATE_FLG		Alpha 1Determines whether the insurance is a percent or a rate per dollars of coverage.
  • P Percent
  • A Amount
BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTH-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RTHSET1COMPANY, TABLE-CODE, START-DATEPrimaryBN00.1, BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN08.1, BN100 +22 more (list truncated in source)
RTHSET2COMPANY, TABLE-CODE, START-DATE*BN100, BN101, BN102, BN103, BN105, BN245, BN31.1, BN31.2 +17 more
RTHSET3COMPANY, TABLE-TYPE, TABLE-CODE, START-DATEBN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN202, BN206

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyBNCOMPANYRequiredRTH-COMPANY → BNC-COMPANY
Company NamePRSYSTEMRequiredRTH-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredRTH-CURRENCY-CODE → CUC-CURRENCY-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
RatetbldtlRATETBLDTLRTH-COMPANY → RTD-COMPANY, RTH-TABLE-CODE → RTD-TABLE-CODE, RTH-START-DATE → RTD-START-DATE, → RTD-BEG-AGE-YR-SAL, → RTD-SMOKER

Programs

Updated by (6)

Referenced by (47)