RATETBLDTL – Rate Table Detail

System
Benefits (BN)
Prefix
RTD
Primary key
COMPANY, TABLE-CODE, START-DATE, BEG-AGE-YR-SAL, SMOKER
Fields
16
Updated by
6 programs
Referenced by
43 programs

RATETBLDTL is the Rate Table Detail table in Lawson Benefits (prefix RTD). It is indexed by COMPANY, TABLE-CODE, START-DATE, BEG-AGE-YR-SAL, SMOKER (RTDSET1); alternate indexes: RTDSET2. It is related 1:1 to BNCOMPANY and RATETBLHDR. It is updated by BN00.1, BN02.1, BN02.2, BN02.3, BN02.4 and BN02.5 and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN17.3 and 35 more. The table has 16 fields, 2 indexes and 2 documented relations.

About RATETBLDTL

The Rate Table Detail file contains information about rate tables. BN02.1 (Rate Table) is the primary program that updates this file.

Fields (16)

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

Field / columnTypeDescription & valuesUpdated by
RTD-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
RTD-TABLE-CODE PK
TABLE_CODE		Alpha 4Contains the user-defined code that represents a rate table.BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTD-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
RTD-BEG-AGE-YR-SAL PK
BEG_AGE_YR_SAL		Numeric 13Contains the beginning value for a range based on a rate table header type. This value can be an age, year, or salary.BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTD-SMOKER PK
SMOKER		Alpha 1Indicates whether the rate table entry is for smoking or non-smoking rates.
  • N NO
  • Y YES
BN02.1, BN02.2, BN02.3
RTD-EMP-RATE
EMP_RATE		Signed 9.4Contains the employee rate or percent used for the employee's contribution.BN02.1, BN02.2, BN02.3
RTD-COMP-RATE
COMP_RATE		Signed 9.4Contains the company's rate or percent of contribution.BN02.1, BN02.2, BN02.3
RTD-FLEX-RATE
FLEX_RATE		Signed 9.4Contains the amount of flex dollars employees receive for choosing a benefit. Contains used for disability and employee life/AD&D plans.BN02.1, BN02.2, BN02.3, BN02.4
RTD-COVER-PCT
COVER_PCT		Signed 7.4Contains the percent of coverage for each age range.BN02.5
RTD-COVER-AMT
COVER_AMT		Signed 11.2—BN02.5
RTD-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTD-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTD-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTD-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTD-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
RTD-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN02.1, BN02.2, BN02.3, BN02.4, BN02.5

Indexes (2)

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

IndexKeysFlagsConditionUsed in
RTDSET1COMPANY, TABLE-CODE, START-DATE, BEG-AGE-YR-SAL, SMOKERPrimaryBN00.1, BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN15.1, BN17.3 +12 more
RTDSET2COMPANY, TABLE-CODE, START-DATE, SMOKER, BEG-AGE-YR-SAL*BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN31.1 +21 more

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyBNCOMPANYRequiredRTD-COMPANY → BNC-COMPANY
Rate TableRATETBLHDRRequiredRTD-COMPANY → RTH-COMPANY, RTD-TABLE-CODE → RTH-TABLE-CODE, RTD-START-DATE → RTH-START-DATE

Programs

Updated by (6)

Referenced by (43)