RATETBLDTL

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
BN19.1 BN19.2 BN206


UPDATED BY
BN00.1 BN02.1 BN02.2 BN02.3 BN02.4 BN02.5
BN100 BN101 BN102 BN103 BN105 BN145
BN15.1 BN17.3 BN18.1 BN18.2 BN18.3 BN18.4
BN18.5 BN18.6 BN18.7 BN202 BN245 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN320 BN45.1
BN531 BN65.1 BN71.1 BN72.1 BS13.1 BS14.1
BS15.1 BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1
ZB32.2 ZB32.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTD-COMPANY
Element: Company Hr		Numeric 4
Contains the company number. The number correlates all information about the company.
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTD-TABLE-CODE
Element: Table Code		Alpha 4
Contains the user-defined code that represents a rate table.
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTD-START-DATE
Element: 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
Element: Beg Age Yr Sal		Numeric 13
Contains 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
Element: Smoker		Alpha 1
Indicates 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
Element: Emp Rate		Signed 9.4
Contains the employee rate or percent used for the employee's contribution.
BN02.1 BN02.2
BN02.3
RTD-COMP-RATE
Element: Comp Rate		Signed 9.4
Contains the company's rate or percent of contribution.
BN02.1 BN02.2
BN02.3
RTD-FLEX-RATE
Element: Flex Rate		Signed 9.4
Contains 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
Element: Cover Pct		Signed 7.4
Contains the percent of coverage for each age range.
BN02.5
RTD-COVER-AMT
Element: Cover Amt		Signed 11.2
BN02.5


RATETBLDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTDSET1 COMPANY
TABLE-CODE
START-DATE
BEG-AGE-YR-SAL
SMOKER
BN00.1 BN02.1
BN02.2 BN02.3
BN02.4 BN02.5
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
RTDSET2 COMPANY
TABLE-CODE
START-DATE
SMOKER
BEG-AGE-YR-SAL*
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 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3


RATETBLDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:10:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.