 |
Lawson Insight Technical Documentation |
|
PREMIUM FILE
Benefit Plan Premium
The Benefit Plan Premium file contains contributions for a benefit plan. It
includes premiums for employees, retirees, and COBRA participants.
REFERENCED BY
BN100 BN101 BN102 BN103 BN145 BN17.1
BN180 BN220 BN242 BN245 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN320 BN331 BN45.1
BN531 BN65.1 BN71.1 BN72.1 BS09.1 BS10.1
BS11.1 BS12.1 BS13.1 BS14.1 BS15.1 BS32.1
HR55.1 PRBN.1 BN215 BN230
UPDATED BY
BN00.1 BN02.1 BN02.2 BN02.3 BN02.4 BN02.5
BN105 BN15.1 BN18.1 BN18.2 BN18.3 BN18.4
BN18.5 BN18.6 BN18.7 BN19.1 BN19.2 BN19.3
BN19.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRE-COMPANY Numeric 4 BN15.1 BN18.1
Company Contains the company number. BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-PLAN-TYPE Alpha 2 BN15.1 BN18.1
Type Contains the type of benefit plan. BN18.2 BN18.3
HL = Health BN18.4 BN18.5
DN = Dental BN18.6 BN18.7
DI = Disability BN19.1 BN19.2
EL = Life BN19.3 BN19.4
DL = Dependent Life
DC = Defined Contribution
DB = Defined Benefit
VA = Vacation
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
PRE-PLAN-CODE Alpha 4 BN15.1 BN18.1
Plan Contains a user-defined field used to BN18.2 BN18.3
represent a specific plan. BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-START-DATE Numeric 8 (yyyymmdd) BN15.1 BN18.1
Start Date Contains the start date for the premium BN18.2 BN18.3
record. BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-GROUP-NAME Alpha 10 BN15.1 BN18.1
Group Name Contains the group that uses the BN18.2 BN18.3
contribution record. This field may BN18.4 BN18.5
contain spaces. BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-CONTRIB-TYPE Alpha 2 BN15.1 BN18.1
Contrib Type Contains the contribution type. It must BN18.2 BN18.3
match the plan contribution type. BN18.4 BN18.5
1 = Option Amounts BN18.6 BN18.7
2 = Option Rate Table BN19.1 BN19.2
3 = Amount BN19.3 BN19.4
4 = Coverage or Salary Rate Table
5 = Contribution Limits
6 = Service Schedule
7 = Percent Schedule
X = Custom Calculation
PRE-CALC-TYPE Alpha 1 BN15.1 BN18.1
Calculation Type Determines how the contribution is BN18.2 BN18.3
calculated. BN18.4 BN18.5
1 = Flat Amount BN18.6 BN18.7
2 = Flat Percent BN19.1 BN19.2
3 = Percent of Salary
4 = Rate Table
X = Custom Calculation
PRE-SALARY-TYPE Alpha 2 BN15.1 BN18.1
Salary Type If contributions are based on salary, BN18.2 BN18.3
this field determines the salary to be BN18.4 BN18.5
used. BN18.6 BN18.7
EM = HR11 Salary BN19.1 BN19.2
B1 = Benefit Salary 1 BN19.3 BN19.4
B2 = Benefit Salary 2
B3 = Benefit Salary 3
B4 = Benefit Salary 4
B5 = Benefit Salary 5
E1 = HR11 and Ben Sal 1
E2 = HR11 and Ben Sal 2
E3 = HR11 and Ben Sal 3
E4 = HR11 and Ben Sal 4
E5 = HR11 and Ben Sal 5
X = Custom Calculation
FL = Flex Salary
PRE-SALARY-DATE Numeric 4 (mmdd) BN15.1 BN18.1
Salary Date If contributions are based on salary BN18.2 BN18.3
and if the salary first month is an "as BN18.4 BN18.5
of" date, this field contains the month BN18.6 BN18.7
and day the salary should be determined. BN19.1 BN19.2
This field may be used with the salary BN19.3 BN19.4
year.
PRE-SAL-FIRST-MO Alpha 1 BN15.1 BN18.1
Sal First Mo If contributions are based on salary, BN18.2 BN18.3
this field determines the salary BN18.4 BN18.5
calculation date. BN18.6 BN18.7
C = Current BN19.1 BN19.2
M = First of Month BN19.3 BN19.4
A = As of Date
F = Flex Calc Date
PRE-ROUND-METH Alpha 1 BN15.1 BN18.1
Rounding Method If contributions are based on salary, BN18.2 BN18.3
this field contains the rounding method BN18.4 BN18.5
used to calculate the annual salary. BN18.6 BN18.7
H = High BN19.1 BN19.2
L = Low BN19.3 BN19.4
N = No Rounding
R = Normal
PRE-BEF-AFT-FLAG Alpha 1 BN15.1 BN18.1
Before/After If the contribution is based on salary, BN18.2 BN18.3
this field indicates if rounding is done BN18.4 BN18.5
before or after multiplying salary. BN18.6 BN18.7
A = After BN19.1 BN19.2
B = Before BN19.3 BN19.4
PRE-ROUND-TO Signed 9.4 BN15.1 BN18.1
Round To If contributions are based on salary, BN18.2 BN18.3
this field determines the place to which BN18.4 BN18.5
the salary is rounded; for example 1, BN18.6 BN18.7
.1, .01, and so on. BN19.1 BN19.2
BN19.3 BN19.4
PRE-AMT-MINIMUM Signed 11.2 BN15.1 BN18.1
Amt Minimum Indicates if the salary minimum amount BN18.2 BN18.3
is used. BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-AMT-MAXIMUM Signed 11.2 BN15.1 BN18.1
Amt Maximum Indicates if the salary maximum amount BN18.2 BN18.3
is used. BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-TABLE-TYPE Alpha 2 BN15.1 BN18.1
Table Type If the premium is tied to a rate table, BN18.2 BN18.3
this field indicates the type of table BN18.4 BN18.5
used. BN18.6 BN18.7
1 = Age BN19.2
2 = Salary
3 = Years of Service
X = Custom Calculation
PRE-EMP-SPS-AGE Alpha 1 BN15.1 BN18.1
Emp Sps Age If the contribution is based on age, BN18.2 BN18.3
this field indicates whether the BN18.4 BN18.5
contribution is base on the employee BN18.6 BN18.7
age or spouse age. BN19.2
E = Employee
S = Spouse
PRE-AGE-DATE Numeric 4 (mmdd) BN15.1 BN18.1
Age Date If the contribution is based on age, BN18.2 BN18.3
this field contains the date for the "as BN18.4 BN18.5
of" date. BN18.6 BN18.7
BN19.2
PRE-AGE-FIRST-MO Alpha 1 BN15.1 BN18.1
Age First Mo If the contribution is based on age, BN18.2 BN18.3
this field contains indicates the date BN18.4 BN18.5
used to calculate the age. BN18.6 BN18.7
C = Current BN19.2
M = First of Month
A = As of Date
F = Flex Calc Date
PRE-FROM-DATE Alpha 2 BN15.1 BN18.1
From Date If the contribution is based on BN18.2 BN18.3
service, this field is used to calculate BN18.4 BN18.5
the years of service. BN18.6 BN18.7
HI = Hire Date BN19.2 BN19.3
AJ = Adjusted Hire Date BN19.4
AN = Anniversary Date
SN = Seniority Date
B1 = Benefit Date 1
B2 = Benefit Date 2
B3 = Benefit Date 3
B4 = Benefit Date 4
B5 = Benefit Date 5
X = Custom Calculation
PRE-SERV-DATE Numeric 4 (mmdd) BN15.1 BN18.1
Serv Date If the contribution is based on BN18.2 BN18.3
service, this field contains the date BN18.4 BN18.5
through which the service is calculated. BN18.6 BN18.7
BN19.2 BN19.3
PRE-SERV-FIRST-MO Alpha 1 BN15.1 BN18.1
Serv First Mo If contributions are based on service, BN18.2 BN18.3
this field contains the date through BN18.4 BN18.5
which the years of service is BN18.6 BN18.7
calculated. BN19.2 BN19.3
C = Current
M = First of Month
A = As of Date
F = Flex Calc Date
PRE-EMP-CONT Signed 7.2 BN15.1 BN18.1
Emp Cont If the contribution type is a flat BN18.2 BN18.3
contribution, this field contains the BN18.4 BN18.5
employee contribution amount. BN18.6 BN18.7
PRE-COMP-CONT Signed 7.2 BN15.1 BN18.1
Company Contribution If the contribution type is a flat BN18.2 BN18.3
contribution, this field contains the BN18.4 BN18.5
company contribution. BN18.6 BN18.7
PRE-FLEX-CONT Signed 7.2 BN15.1 BN18.1
Flex Cont If the contribution type is a flat BN18.2 BN18.3
contribution, this field contains the BN18.4 BN18.5
flex credit contribution. BN18.6 BN18.7
PRE-RATE-TABLE Alpha 4 BN15.1 BN18.1
Rate Table Indicates the rate table used to BN18.2 BN18.3
calculate contributions for the plan. BN18.4 BN18.5
This field is used only for flat BN18.6 BN18.7
contributions and for salary or coverage
rate table contributions.
PRE-CONTRIB-BASIS Alpha 1 BN15.1 BN18.1
Contrib Basis If the contribution type is salary or BN18.2 BN18.3
coverage rate table, this field BN18.4 BN18.5
indicates if the contribution is based BN18.6 BN18.7
on the salary or coverage amount on the
benefit.
C = Coverage
S = Salary
PRE-COST-PER-CVG Signed 9.2 BN15.1 BN18.1
Premium Per Dollars If the premium is calculated by a rate BN18.2 BN18.3
per dollars of coverage, this is the BN18.4 BN18.5
amount on which the rate is based. BN18.6 BN18.7
PRE-ANN-AMT-MIN Signed 11.2 BN15.1 BN18.1
Ann Amt Min If the contribution type is a BN18.2 BN18.3
contribution limit, this field contains BN18.4 BN18.5
the minimum annual amount. BN18.6 BN18.7
PRE-ANN-AMT-MAX Signed 11.2 BN15.1 BN18.1
Ann Amt Max If the contribution type is BN18.2 BN18.3
contribution limit, this field contains BN18.4 BN18.5
the maximum annual amount. BN18.6 BN18.7
PRE-PCT-MINIMUM Signed 5.2 BN15.1 BN18.1
Pct Minimum If the contribution type is BN18.2 BN18.3
contribution limit, this field contains BN18.4 BN18.5
the minimum annual percent. BN18.6 BN18.7
PRE-PCT-MAXIMUM Signed 5.2 BN15.1 BN18.1
Pct Maximum If the contribution type is BN18.2 BN18.3
contribution limit, this field contains BN18.4 BN18.5
the maximum annual percent. BN18.6 BN18.7
PRE-COMP-AMT Signed 7.2 BN15.1 BN18.1
Comp Amt If the contribution type is BN18.2 BN18.3
contribution limit, this field contains BN18.4 BN18.5
the company amount contribution. BN18.6 BN18.7
PRE-COMP-PCT Signed 5.2 BN15.1 BN18.1
Comp Pct If the contribution type is BN18.2 BN18.3
contribution limit, this field contains BN18.4 BN18.5
the company percent contribution. BN18.6 BN18.7
PRE-VAC-MAX-HOURS Signed 6.3 BN15.1 BN18.1
Vac Max Hours If the plan type is vacation and the BN18.2 BN18.3
contribution type is contribution limit, BN18.4 BN18.5
this field contains the maximum vacation BN18.6 BN18.7
hours that can be bought or sold.
PRE-VAC-COST Signed 5.2 BN15.1 BN18.1
Cost If the plan type is vacation and the BN18.2 BN18.3
contribution type is contribution limit, BN18.4 BN18.5
this field contains the cost of each BN18.6 BN18.7
hour purchased or sold.
PRE-INCREMENT Signed 5.2 BN15.1 BN18.1
Percent Increments If the contribution type is match limit BN18.2 BN18.3
schedule or match percent schedule, this BN18.4 BN18.5
field contains the increments an BN18.6 BN18.7
employee must elect. BN19.3 BN19.4
PRE-EMP-CONT-TYPE Alpha 1 BN15.1 BN18.1
Emp Cont Type If the contribution type is match limit BN18.2 BN18.3
schedule or match percent schedule, this BN18.4 BN18.5
field indicates the type of employee BN18.6 BN18.7
contribution. BN19.3 BN19.4
A = Amount
P = Percent
B = Both
N = No Contribution
PRE-CONT-TAX-STS Alpha 1 BN15.1 BN18.1
Cont Tax Sts Indicates how an employee can BN18.2 BN18.3
contribute. BN18.4 BN18.5
P = Pre-Tax BN18.6 BN18.7
A = After-Tax BN19.1 BN19.2
B = Both BN19.3 BN19.4
N = No Contribution
PRE-MATCH-OPTION Alpha 1 BN15.1 BN18.1
Match Option If the contribution type is match limit BN18.2 BN18.3
schedule or match percent schedule, this BN18.4 BN18.5
field indicates which contributions are BN18.6 BN18.7
matched. BN19.3 BN19.4
P = Pre-Tax
A = After-Tax
B = Both
PRE-MATCH-CALC Alpha 1 BN15.1 BN18.1
Match Calc If the contribution type is match BN18.2 BN18.3
percent schedule, this field indicates BN18.4 BN18.5
how the match is determined. BN18.6 BN18.7
C = Cumulative BN19.4
F = Fixed
PRE-END-PCT Numeric 3 BN15.1 BN18.1
End Pct If the contribution type is match BN18.2 BN18.3
percent schedule, this field indicates BN18.4 BN18.5
the maximum contribution percent. BN18.6 BN18.7
BN19.4
PRE-E-COMP-CONT1 Signed 7.2 BN15.1 BN18.1
Company - Single This field is not used. BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-R-COMP-CONT1 Signed 7.2 BN15.1 BN18.1
Company - Single This field is not used. BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-RET-RATE-TBL Alpha 2 BN15.1 BN18.1
Retiree Rate Table This field is not used. BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-STATUS Numeric 1 BN02.1 BN02.2
Status This field is not used. BN02.3 BN02.4
0 = New Group New Date BN02.5 BN105
1 = Existing Group New Date BN15.1 BN18.1
2 = Change Existing Record BN18.2 BN18.3
3 = Updated BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-RET-STATUS Numeric 1 BN02.1 BN02.2
Retiree Premium This field is not used. BN02.3 BN02.4
Status 0 = New Group New Date BN02.5 BN105
1 = Existing Group New Date BN15.1 BN18.1
2 = Change Existing Record BN18.2 BN18.3
3 = Updated BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-EARLY-RT-AGE Numeric 2 BN15.1 BN18.1
Early Retiree Age This field is not used. BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-REG-RT-AGE Numeric 2 BN15.1 BN18.1
Regular Retiree Age This field is not used. BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-FLEX-CONT1 Signed 7.2 BN15.1 BN18.1
Flex Credits - This field is not used. BN18.2 BN18.3
Single BN18.4 BN18.5
BN18.6 BN18.7
PRE-DEFAUL-TAX-TYP Alpha 1 BN15.1 BN18.1
Defaul Tax Typ Contains the default contribution tax BN18.2 BN18.3
type for the employee contribution. BN18.4 BN18.5
P = Pre-Tax BN18.6 BN18.7
A = After-Tax BN19.1 BN19.2
BN19.3 BN19.4
PRE-SALARY-YEAR Numeric 4 BN15.1 BN18.1
Salary Year If contributions are based on salary BN18.2 BN18.3
and an "as of" date is used, this field BN18.4 BN18.5
contains the year. BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-AGE-YEAR Numeric 4 BN15.1 BN18.1
Age Year If contributions are based on age and BN18.2 BN18.3
an "as of" date, this field contains the BN18.4 BN18.5
year. BN18.6 BN18.7
BN19.2
PRE-SERV-YEAR Numeric 4 BN15.1 BN18.1
Serv Year If contributions are based on a service BN18.2 BN18.3
and an "as of" date, this field contains BN18.4 BN18.5
the year. BN18.6 BN18.7
BN19.3
PRE-PAY-PER-MIN Signed 6.2 BN15.1 BN18.1
Pay Per Min If the contribution type is BN18.2 BN18.3
contribution limit, this field contains BN18.4 BN18.5
the pay period minimum contribution BN18.6 BN18.7
amount.
PRE-PAY-PER-MAX Signed 6.2 BN15.1 BN18.1
Pay Per Max If the contribution type is BN18.2 BN18.3
contribution limit, this field contains BN18.4 BN18.5
the maximum pay period amount. BN18.6 BN18.7
PRE-COVER-TYPE Alpha 1 BN15.1 BN18.1
Cover Type Indicates if the coverage is for BN18.2 BN18.3
employees, retirees, or COBRA BN18.4 BN18.5
participants for each premium record. BN18.6 BN18.7
E = Employees BN19.1 BN19.2
R = Retirees BN19.3 BN19.4
C = COBRA
PRE-COBRA-STATUS Numeric 1 BN02.1 BN02.2
Cobra Status If the coverage type is COBRA, this BN02.3 BN02.4
field indicates the status. If the BN02.5 BN105
status is New Group New Record, Existing BN15.1 BN18.1
Group New Date, or Change Existing BN18.2 BN18.3
Record, the premium record must be BN18.4 BN18.5
updated before an invoice can be BN18.6 BN18.7
generated. BN19.1 BN19.2
0 = New Group New Record BN19.3 BN19.4
1 = Existing Group New Date
2 = Change Existing Record
3 = Updated
PREMIUM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRESET1 COMPANY BN00.1 BN02.1
PLAN-TYPE BN02.2 BN02.3
PLAN-CODE BN02.4 BN100
COVER-TYPE BN101 BN102
START-DATE BN103 BN105
GROUP-NAME BN145 BN15.1
BN17.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN180 BN19.1
BN19.2 BN19.3
BN19.4 BN220
BN242 BN245
BN31.1 BN31.2
...
PRESET3 COMPANY BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN145
COVER-TYPE BN215 BN230
START-DATE* BN245 BN31.1
GROUP-NAME BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS09.1
BS10.1 BS11.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1
PRESET5 COMPANY BN18.1 BN18.2
CONTRIB-TYPE BN18.3 BN18.4
PLAN-TYPE BN18.5 BN18.6
PLAN-CODE BN18.7
COVER-TYPE
START-DATE
GROUP-NAME
PRESET6 COMPANY KeyChange BN02.1 BN02.2
COVER-TYPE BN02.3 BN02.4
RATE-TABLE BN02.5
START-DATE
PLAN-TYPE
PLAN-CODE
GROUP-NAME
PRESET7 COMPANY BN15.1 BN18.1
PLAN-TYPE BN18.2 BN18.3
PLAN-CODE BN18.4 BN18.5
COVER-TYPE BN18.6 BN18.7
GROUP-NAME BN19.1 BN19.2
START-DATE* BN19.3 BN19.4
PREMIUM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Age Rate Table RATETBLHDR Not Required
Valid When PRE-TABLE-TYPE = "1 "
PRE-COMPANY -> RTH-COMPANY
PRE-RATE-TABLE -> RTH-TABLE-CODE
PRE-START-DATE -> RTH-START-DATE
Company BNCOMPANY Required
PRE-COMPANY -> BNC-COMPANY
Company Name PRSYSTEM Required
PRE-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Contrib 0 PLAN Required
When PRE-CONTRIB-TYPE = "0 "
PRE-COMPANY -> PLN-COMPANY
PRE-PLAN-TYPE -> PLN-PLAN-TYPE
PRE-PLAN-CODE -> PLN-PLAN-CODE
Contrib 1 PLAN Required
When PRE-CONTRIB-TYPE = "1 "
PRE-COMPANY -> PLN-COMPANY
PRE-PLAN-TYPE -> PLN-PLAN-TYPE
PRE-PLAN-CODE -> PLN-PLAN-CODE
Contrib 2 PLAN Required
When PRE-CONTRIB-TYPE = "2 "
PRE-COMPANY -> PLN-COMPANY
PRE-PLAN-TYPE -> PLN-PLAN-TYPE
PRE-PLAN-CODE -> PLN-PLAN-CODE
Contrib 3 PLAN Required
When PRE-CONTRIB-TYPE = "3 "
PRE-COMPANY -> PLN-COMPANY
PRE-PLAN-TYPE -> PLN-PLAN-TYPE
PRE-PLAN-CODE -> PLN-PLAN-CODE
Contrib 4 PLAN Required
When PRE-CONTRIB-TYPE = "4 "
PRE-COMPANY -> PLN-COMPANY
PRE-PLAN-TYPE -> PLN-PLAN-TYPE
PRE-PLAN-CODE -> PLN-PLAN-CODE
Contrib 5 PLAN Required
When PRE-CONTRIB-TYPE = "5 "
PRE-COMPANY -> PLN-COMPANY
PRE-PLAN-TYPE -> PLN-PLAN-TYPE
PRE-PLAN-CODE -> PLN-PLAN-CODE
Contrib 6 PLAN Required
When PRE-CONTRIB-TYPE = "6 "
PRE-COMPANY -> PLN-COMPANY
PRE-PLAN-TYPE -> PLN-PLAN-TYPE
PRE-PLAN-CODE -> PLN-PLAN-CODE
Contrib 7 PLAN Required
When PRE-CONTRIB-TYPE = "7 "
PRE-COMPANY -> PLN-COMPANY
PRE-PLAN-TYPE -> PLN-PLAN-TYPE
PRE-PLAN-CODE -> PLN-PLAN-CODE
Contrib User PLAN Required
When PRE-CONTRIB-TYPE = "X "
PRE-COMPANY -> PLN-COMPANY
PRE-PLAN-TYPE -> PLN-PLAN-TYPE
PRE-PLAN-CODE -> PLN-PLAN-CODE
Persgroup PERSGROUP Not Required
PRE-COMPANY -> PRG-COMPANY
PRE-GROUP-NAME -> PRG-GROUP-NAME
Plan PLAN Required
PRE-COMPANY -> PLN-COMPANY
PRE-PLAN-TYPE -> PLN-PLAN-TYPE
PRE-PLAN-CODE -> PLN-PLAN-CODE
Prsystem PRSYSTEM Required
PRE-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Rate Table RATETBLHDR Not Required
PRE-COMPANY -> RTH-COMPANY
PRE-RATE-TABLE -> RTH-TABLE-CODE
PRE-START-DATE -> RTH-START-DATE
Sal Rate Table RATETBLHDR Not Required
Valid When PRE-TABLE-TYPE = "2 "
PRE-COMPANY -> RTH-COMPANY
PRE-RATE-TABLE -> RTH-TABLE-CODE
PRE-START-DATE -> RTH-START-DATE
Serv Rate Tbl RATETBLHDR Not Required
Valid When PRE-TABLE-TYPE = "3 "
PRE-COMPANY -> RTH-COMPANY
PRE-RATE-TABLE -> RTH-TABLE-CODE
PRE-START-DATE -> RTH-START-DATE
PREMIUM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bnprmopt BNPRMOPT Delete Cascades
PRE-COMPANY -> PCV-COMPANY
PRE-PLAN-TYPE -> PCV-PLAN-TYPE
PRE-PLAN-CODE -> PCV-PLAN-CODE
PRE-COVER-TYPE -> PCV-COVER-TYPE
PRE-START-DATE -> PCV-START-DATE
PRE-GROUP-NAME -> PCV-GROUP-NAME
PCV-COVERAGE-OPT
Contrdetl CONTRDETL
PRE-COMPANY -> CND-COMPANY
PRE-PLAN-TYPE -> CND-PLAN-TYPE
PRE-PLAN-CODE -> CND-PLAN-CODE
PRE-START-DATE -> CND-START-DATE
PRE-GROUP-NAME -> CND-GROUP-NAME
CND-BEGIN-YEAR-PCT
Contrib Sch CONTRDETL
PRE-COMPANY -> CND-COMPANY
PRE-PLAN-TYPE -> CND-PLAN-TYPE
PRE-PLAN-CODE -> CND-PLAN-CODE
PRE-START-DATE -> CND-START-DATE
PRE-GROUP-NAME -> CND-GROUP-NAME
CND-BEGIN-YEAR-PCT
Rate Tbl Dtl RATETBLDTL Delete Restricted
PRE-COMPANY -> RTD-COMPANY
PRE-RATE-TABLE -> RTD-TABLE-CODE
PRE-START-DATE -> RTD-START-DATE
RTD-BEG-AGE-YR-SAL
RTD-SMOKER
|