 |
Lawson Insight Technical Documentation |
|
RATETBLHDR FILE
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 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 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 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 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.
RTH-TABLE-CODE Alpha 4 BN02.1 BN02.2
Table Code Contains a user-defined code that BN02.3 BN02.4
represents a rate table. BN02.5
RTH-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
RTH-TABLE-TYPE Alpha 2 BN02.1 BN02.2
Table Type Table type is used to uniquely define a BN02.3 BN02.4
percent table record for depreciation BN02.5 BN18.3
calculation purposes. This field allows BN18.4
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
RTH-DESC Alpha 30 (Lower Case) BN02.1 BN02.2
Description Contains a description of the rate BN02.3 BN02.4
table. BN02.5 BN18.3
BN18.4
RTH-PCT-RATE-FLG Alpha 1 BN02.1 BN02.2
Basis Determines whether the insurance is a BN02.3 BN02.4
percent or a rate per dollars of BN02.5
coverage.
P = Percent
A = Amount
RTH-CURRENCY-CODE Alpha 5 BN02.1 BN02.2
Currency Code This field contains the company base BN02.3 BN02.4
currency code established in Company BN02.5
(GL10.1 ).
RTH-CURR-ND Numeric 1 BN02.1 BN02.2
Currency Number of Represents the number of decimals BN02.3 BN02.4
Decimals defined for the currency of the object. BN02.5
RATETBLHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTHSET1 COMPANY BN00.1 BN02.1
TABLE-CODE BN02.2 BN02.3
START-DATE BN02.4 BN02.5
BN08.1 BN100
BN101 BN102
BN103 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 BN245
BN31.1 BN31.2
BN32.1 BN32.2
...
RTHSET2 COMPANY BN100 BN101
TABLE-CODE BN102 BN103
START-DATE* BN105 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN65.1 BN71.1
BN72.1 BS14.1
BS15.1 BS32.1
RTHSET3 COMPANY BN02.1 BN02.2
TABLE-TYPE BN02.3 BN02.4
TABLE-CODE BN02.5 BN202
START-DATE BN206
RATETBLHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|