RATETBLHDR

Rate Table Header

The Rate Table Header file contains the start date and the description of the rate table for the Rate Table file.

REFERENCED BY
BN08.1 BN100 BN101 BN102 BN103 BN104
BN105 BN145 BN15.1 BN17.3 BN18.1 BN18.2
BN18.3 BN18.4 BN18.5 BN18.6 BN18.7 BN19.1
BN19.2 BN215 BN230 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 BN320 BN202 BN206


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTH-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
RTH-TABLE-CODE
Element: Table Code		Alpha 4
Contains a user-defined code that represents a rate table.
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTH-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
RTH-TABLE-TYPE
Element: Table Type		Alpha 2
Table type is used to uniquely define a percent table record for depreciation calculation purposes. This field allows you to define more than one table for any given in-service year and month. Blanks are valid as a table type value.
1 = Age
2 = Salary
3 = Years of Service
4 = Coverage Reduction
5 = Flex Credits
X = Custom Calculation
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5 BN18.3
BN18.4
RTH-DESC
Element: Description		Alpha 30 (Lower Case)
Contains a description of the rate table.
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5 BN18.3
BN18.4
RTH-PCT-RATE-FLG
Element: Pct Rate Flg		Alpha 1
Determines whether the insurance is a percent or a rate per dollars of coverage.
P = Percent
A = Amount
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTH-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTH-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTH-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTH-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTH-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTH-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTH-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
RTH-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5


RATETBLHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTHSET1 COMPANY
TABLE-CODE
START-DATE
...
BN00.1 BN02.1
BN02.2 BN02.3
BN02.4 BN02.5
BN08.1 BN100
BN101 BN102
BN103 BN104
BN105 BN145
BN15.1 BN17.3
BN18.1 BN18.2
BN18.3 BN18.4
BN18.5 BN18.6
BN18.7 BN19.1
BN19.2 BN215
BN230 BN245
BN31.1 BN31.2
RTHSET2 COMPANY
TABLE-CODE
START-DATE*
BN100 BN101
BN102 BN103
BN105 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN531 BN65.1
BN71.1 BN72.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
RTHSET3 COMPANY
TABLE-TYPE
TABLE-CODE
START-DATE
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5 BN202
BN206


RATETBLHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
RTH-COMPANY->BNC-COMPANY
Company Name PRSYSTEM Required
RTH-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
RTH-CURRENCY-CODE->CUC-CURRENCY-CODE


RATETBLHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Ratetbldtl RATETBLDTL
RTH-COMPANY->RTD-COMPANY
RTH-TABLE-CODE->RTD-TABLE-CODE
RTH-START-DATE->RTD-START-DATE
  RTD-BEG-AGE-YR-SAL
  RTD-SMOKER

File created: Thu Jun 09 02:10:16 2016

Home
Contact Us



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