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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RTDSET1
  1. COMPANY
  2. TABLE-CODE
  3. START-DATE
  4. BEG-AGE-YR-SAL
  5. SMOKER
PrimaryBN00.1, BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN15.1, BN17.3 +12 more
RTDSET2
  1. COMPANY
  2. TABLE-CODE
  3. START-DATE
  4. SMOKER
  5. BEG-AGE-YR-SAL ↓
BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN31.1 +21 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BNCOMPANYRATETBLHDRRATETBLDTL

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyBNCOMPANYRequired
RTD-COMPANY→BNC-COMPANY
Rate TableRATETBLHDRRequired
RTD-COMPANY→RTH-COMPANY
RTD-TABLE-CODE→RTH-TABLE-CODE
RTD-START-DATE→RTH-START-DATE

Programs

Updated by (6)

Referenced by (43)