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
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 BS10.1 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3


UPDATED BY
BN00.1 BN02.1 BN02.2 BN02.3 BN02.4 BN02.5

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
RTD-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTD-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTD-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTD-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTD-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTD-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN02.1 BN02.2
BN02.3 BN02.4
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 BS10.1
BS12.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 02:10:16 2016

Home
Contact Us



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