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