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
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. |
|
||||||
RTD-TABLE-CODE Element: Table Code | Alpha 4 Contains the user-defined code that represents a rate table. |
|
||||||
RTD-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the effective date of the rate table. |
|
||||||
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. |
|
||||||
RTD-SMOKER Element: Smoker | Alpha 1 Indicates whether the rate table entry is for smoking or non-smoking rates. N = NO Y = YES |
|
||||||
RTD-EMP-RATE Element: Emp Rate | Signed 9.4 Contains the employee rate or percent used for the employee's contribution. |
|
||||||
RTD-COMP-RATE Element: Comp Rate | Signed 9.4 Contains the company's rate or percent of contribution. |
|
||||||
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. |
|
||||||
RTD-COVER-PCT Element: Cover Pct | Signed 7.4 Contains the percent of coverage for each age range. |
|
||||||
RTD-COVER-AMT Element: Cover Amt | Signed 11.2 |
|
||||||
RTD-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||||
RTD-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||||
RTD-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
||||||
RTD-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||||
RTD-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||||
RTD-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RTDSET1 |
COMPANY TABLE-CODE START-DATE BEG-AGE-YR-SAL SMOKER |
|
| ||||||||||||||||||||||||||||||||||||
RTDSET2 |
COMPANY TABLE-CODE START-DATE SMOKER BEG-AGE-YR-SAL* |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Company | BNCOMPANY |
Required
| |||||||||
Rate Table | RATETBLHDR |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.