PREMIUM

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
BN104 BN145 BN232 BN242 BN245 BN331
BN340 BN45.1 BN65.1 BN71.1 BN72.1 BS09.1
BS10.1 BS11.1 BS12.1 BS13.1 BS14.1 BS15.1
ZB01.1 BN220 PRBN.1


UPDATED BY
BN00.1 BN02.1 BN02.2 BN02.3 BN02.4 BN02.5
BN100 BN101 BN102 BN103 BN105 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 BN215 BN230 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN320 BN531 BS32.1 ZB10.1
ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3 ZB599
HR55.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRE-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-PLAN-TYPE
Element: Plan Type		Alpha 2
Contains the type of benefit plan.
HL = Health
DN = Dental
DI = Disability
EL = Life
DL = Dependent Life
DC = Defined Contribution
DB = Defined Benefit
VA = Vacation
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-PLAN-CODE
Element: Plan Code		Alpha 4
Contains a user-defined field used to represent a specific plan.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the start date for the premium record.
BN100 BN101
BN102 BN103
BN105 BN145
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
BN232 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN340
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
ZB01.1 ZB10.1
ZB10.2 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
PRE-GROUP-NAME
Element: Group Name		Alpha 10
Contains the group that uses the contribution record. This field may contain spaces.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-CONTRIB-TYPE
Element: Contrib Type		Alpha 2
Contains the contribution type. It must match the plan contribution type.
1 = Option Amounts
2 = Option Rate Table
3 = Amount
4 = Coverage or Salary Rate Table
5 = Contribution Limits
6 = Service Schedule
7 = Percent Schedule
X = Custom Calculation
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-CALC-TYPE
Element: Calc Type		Alpha 1
Determines how the contribution is calculated.
1 = Flat Amount
2 = Flat Percent
3 = Percent of Salary
4 = Rate Table
X = Custom Calculation
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
PRE-SALARY-TYPE
Element: Salary Type		Alpha 2
If contributions are based on salary, this field determines the salary to be used.
EM = HR11 Salary
B1 = Benefit Salary 1
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
ET = Total Emp Salary
T1 = Total Emp and Sal 1
T2 = Total Emp and Sal 2
T3 = Total Emp and Sal 3
T4 = Total Emp and Sal 4
T5 = Total Emp and Sal 5
X = Custom Calculation
FL = Flex Salary
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-SALARY-DATE
Element: Salary Date		Numeric 4 (mmdd)
If contributions are based on salary and if the salary first month is an "as of" date, this field contains the month and day the salary should be determined. This field may be used with the salary year.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-SAL-FIRST-MO
Element: Sal First Mo		Alpha 1
If contributions are based on salary, this field determines the salary calculation date.
C = Current
M = First of Month
A = As of Date
F = Flex Calc Date
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-ROUND-METH
Element: Round Meth		Alpha 1
If contributions are based on salary, this field contains the rounding method used to calculate the annual salary.
H = High
L = Low
N = No Rounding
R = Normal
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-BEF-AFT-FLAG
Element: Bef Aft Flag		Alpha 1
If the contribution is based on salary, this field indicates if rounding is done before or after multiplying salary.
A = After
B = Before
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-ROUND-TO
Element: Round To		Signed 9.4
If contributions are based on salary, this field determines the place to which the salary is rounded; for example 1, .1, .01, and so on.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-AMT-MINIMUM
Element: Amt Minimum		Signed 11.2
Indicates if the salary minimum amount is used.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-AMT-MAXIMUM
Element: Amt Maximum		Signed 11.2
Indicates if the salary maximum amount is used.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-TABLE-TYPE
Element: Table Type		Alpha 2
If the premium is tied to a rate table, this field indicates the type of table used.
1 = Age
2 = Salary
3 = Years of Service
X = Custom Calculation
BN100 BN15.1
BN18.1 BN18.2
BN18.3 BN18.4
BN18.5 BN18.6
BN18.7 BN19.2
PRE-EMP-SPS-AGE
Element: Emp Sps Age		Alpha 1
If the contribution is based on age, this field indicates whether the contribution is base on the employee age or spouse age.
E = Employee
S = Spouse
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.2
PRE-AGE-DATE
Element: Age Date		Numeric 4 (mmdd)
If the contribution is based on age, this field contains the date for the "as of" date.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.2
PRE-AGE-FIRST-MO
Element: Age First Mo		Alpha 1
If the contribution is based on age, this field contains indicates the date used to calculate the age.
C = Current
M = First of Month
A = As of Date
F = Flex Calc Date
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.2
PRE-FROM-DATE
Element: From Date		Alpha 2
If the contribution is based on service, this field is used to calculate the years of service.
HI = Hire Date
AJ = Adjusted Hire Date
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
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.2 BN19.3
BN19.4
PRE-SERV-DATE
Element: Serv Date		Numeric 4 (mmdd)
If the contribution is based on service, this field contains the date through which the service is calculated.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.2 BN19.3
PRE-SERV-FIRST-MO
Element: Serv First Mo		Alpha 1
If contributions are based on service, this field contains the date through which the years of service is calculated.
C = Current
M = First of Month
A = As of Date
F = Flex Calc Date
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.2 BN19.3
PRE-EMP-CONT
Element: Emp Cont		Signed 7.2
If the contribution type is a flat contribution, this field contains the employee contribution amount.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-COMP-CONT
Element: Comp Cont		Signed 11.2
If the contribution type is a flat contribution, this field contains the company contribution.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-FLEX-CONT
Element: Flex Cont		Signed 7.2
If the contribution type is a flat contribution, this field contains the flex credit contribution.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-RATE-TABLE
Element: Rate Table		Alpha 4
Indicates the rate table used to calculate contributions for the plan. This field is used only for flat contributions and for salary or coverage rate table contributions.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-CONTRIB-BASIS
Element: Contrib Basis		Alpha 1
If the contribution type is salary or coverage rate table, this field indicates if the contribution is based on the salary or coverage amount on the benefit.
C = Coverage
S = Salary
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-COST-PER-CVG
Element: Cost Per Cvg		Signed 9.2
If the premium is calculated by a rate per dollars of coverage, this is the amount on which the rate is based.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-ANN-AMT-MIN
Element: Ann Amt Min		Signed 11.2
If the contribution type is a contribution limit, this field contains the minimum annual amount.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-ANN-AMT-MAX
Element: Ann Amt Max		Signed 11.2
If the contribution type is contribution limit, this field contains the maximum annual amount.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-PCT-MINIMUM
Element: Pct Minimum		Signed 5.2
If the contribution type is contribution limit, this field contains the minimum annual percent.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-PCT-MAXIMUM
Element: Pct Maximum		Signed 5.2
If the contribution type is contribution limit, this field contains the maximum annual percent.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-COMP-AMT
Element: Comp Amt		Signed 7.2
If the contribution type is contribution limit, this field contains the company amount contribution.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-COMP-PCT
Element: Comp Pct		Signed 5.2
If the contribution type is contribution limit, this field contains the company percent contribution.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-VAC-MAX-HOURS
Element: Vac Max Hours		Signed 6.3
If the plan type is vacation and the contribution type is contribution limit, this field contains the maximum vacation hours that can be bought or sold.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-VAC-COST
Element: Vac Cost		Signed 5.2
If the plan type is vacation and the contribution type is contribution limit, this field contains the cost of each hour purchased or sold.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-INCREMENT
Element: Increment		Signed 5.2
If the contribution type is match limit schedule or match percent schedule, this field contains the increments an employee must elect.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.3 BN19.4
PRE-EMP-CONT-TYPE
Element: Emp Cont Type		Alpha 1
If the contribution type is match limit schedule or match percent schedule, this field indicates the type of employee contribution.
A = Amount
P = Percent
B = Both
N = No Contribution
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.3 BN19.4
PRE-CONT-TAX-STS
Element: Cont Tax Sts		Alpha 1
Indicates how an employee can contribute.
P = Pre-Tax
A = After-Tax
B = Both
N = No Contribution
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-MATCH-OPTION
Element: Match Option		Alpha 1
If the contribution type is match limit schedule or match percent schedule, this field indicates which contributions are matched.
P = Pre-Tax
A = After-Tax
B = Both
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.3 BN19.4
PRE-MATCH-CALC
Element: Match Calc		Alpha 1
If the contribution type is match percent schedule, this field indicates how the match is determined.
C = Cumulative
F = Fixed
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.4
PRE-END-PCT
Element: End Pct		Numeric 3
If the contribution type is match percent schedule, this field indicates the maximum contribution percent.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.4
PRE-E-COMP-CONT1
Element: E Comp Cont1		Signed 7.2
This field is not used.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-R-COMP-CONT1
Element: R Comp Cont1		Signed 7.2
This field is not used.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-RET-RATE-TBL
Element: Ret Rate Tbl		Alpha 2
This field is not used.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-STATUS
Element: Status		Numeric 1
This field is not used.
0 = New Group New Date
1 = Existing Group New Date
2 = Change Existing Record
3 = Updated
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
PRE-RET-STATUS
Element: Ret Status		Numeric 1
This field is not used.
0 = New Group New Date
1 = Existing Group New Date
2 = Change Existing Record
3 = Updated
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
PRE-EARLY-RT-AGE
Element: Early Rt Age		Numeric 2
This field is not used.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-REG-RT-AGE
Element: Reg Rt Age		Numeric 2
This field is not used.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-FLEX-CONT1
Element: Flex Cont1		Signed 7.2
This field is not used.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-DEFAUL-TAX-TYP
Element: Defaul Tax Typ		Alpha 1
Contains the default contribution tax type for the employee contribution.
P = Pre-Tax
A = After-Tax
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-SALARY-YEAR
Element: Salary Year		Numeric 4
If contributions are based on salary and an "as of" date is used, this field contains the year.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-AGE-YEAR
Element: Age Year		Numeric 4
If contributions are based on age and an "as of" date, this field contains the year.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.2
PRE-SERV-YEAR
Element: Serv Year		Numeric 4
If contributions are based on a service and an "as of" date, this field contains the year.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.3
PRE-PAY-PER-MIN
Element: Pay Per Min		Signed 6.2
If the contribution type is contribution limit, this field contains the pay period minimum contribution amount.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-PAY-PER-MAX
Element: Pay Per Max		Signed 6.2
If the contribution type is contribution limit, this field contains the maximum pay period amount.
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
PRE-COVER-TYPE
Element: Cover Type		Alpha 1
Indicates if the coverage is for employees, retirees, or COBRA participants for each premium record.
E = Employees
R = Retirees
C = COBRA
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRE-COBRA-STATUS
Element: Cobra Status		Numeric 1
If the coverage type is COBRA, this field indicates the status. If the status is New Group New Record, Existing Group New Date, or Change Existing Record, the premium record must be updated before an invoice can be generated.
0 = New Group New Record
1 = Existing Group New Date
2 = Change Existing Record
3 = Updated
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


PREMIUM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRESET1 COMPANY
PLAN-TYPE
PLAN-CODE
COVER-TYPE
START-DATE
GROUP-NAME
...
BN00.1 BN02.1
BN02.2 BN02.3
BN02.4 BN100
BN101 BN102
BN103 BN104
BN105 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 BN230
BN232 BN242
PRESET3 COMPANY
PLAN-TYPE
PLAN-CODE
COVER-TYPE
START-DATE*
GROUP-NAME
...
BN100 BN101
BN102 BN103
BN105 BN145
BN215 BN230
BN232 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN340
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS09.1
BS10.1 BS11.1
BS12.1 BS13.1
BS14.1 BS15.1
PRESET5 COMPANY
CONTRIB-TYPE
PLAN-TYPE
PLAN-CODE
COVER-TYPE
START-DATE
GROUP-NAME
BN18.6
PRESET6 COMPANY
COVER-TYPE
RATE-TABLE
START-DATE
PLAN-TYPE
PLAN-CODE
GROUP-NAME
KeyChange
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5
PRESET7 COMPANY
PLAN-TYPE
PLAN-CODE
COVER-TYPE
GROUP-NAME
START-DATE*
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
PRESET8 COMPANY
CONTRIB-TYPE
PLAN-TYPE
PLAN-CODE
COVER-TYPE
START-DATE*
GROUP-NAME
BN18.1 BN18.2
BN18.3 BN18.4
BN18.5 BN18.6
BN18.7


PREMIUM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Age Rate Table RATETBLHDR Not Required
Valid When RTH-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 PLN-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 RTH-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 RTH-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
NAME		 RELATED 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

File created: Thu Jun 09 11:10:10 2016

Home
Contact Us



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