PREMIUM – Benefit Plan Premium

System
Benefits (BN)
Prefix
PRE
Primary key
COMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME
Fields
64
Updated by
56 programs
Referenced by
10 programs

PREMIUM is the Benefit Plan Premium table in Lawson Benefits (prefix PRE). It is indexed by COMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME (PRESET1); alternate indexes: PRESET3, PRESET5, PRESET6, PRESET7 and PRESET8. It is related 1:1 to RATETBLHDR, BNCOMPANY, PRSYSTEM, PLAN and PERSGROUP and 1:M to BNPRMOPT, CONTRDETL and RATETBLDTL. It is updated by BN00.1, BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN100, BN101 and 48 more and referenced by BN104, BN17.1, BN180, BN215, BN220, BN230, BN242, HR55.1 and 2 more. The table has 64 fields, 6 indexes and 22 documented relations.

About PREMIUM

The Benefit Plan Premium file contains contributions for a benefit plan. It includes premiums for employees, retirees, and COBRA participants.

Fields (64)

Column = COBOL field name without the PRE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PRE-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more
#PRE-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains 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 +4 more
#PRE-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains 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 +4 more
#PRE-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the start date for the premium record.BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN18.1 +40 more
#PRE-GROUP-NAME PK
GROUP_NAME		Alpha 10Contains 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 +4 more
#PRE-CONTRIB-TYPE SET5 SET8
CONTRIB_TYPE		Alpha 2Contains 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 +4 more
#PRE-CALC-TYPE
CALC_TYPE		Alpha 1Determines 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 +2 more
#PRE-SALARY-TYPE
SALARY_TYPE		Alpha 2If 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 +4 more
#PRE-SALARY-DATE
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 +4 more
#PRE-SAL-FIRST-MO
SAL_FIRST_MO		Alpha 1If 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 +4 more
#PRE-ROUND-METH
ROUND_METH		Alpha 1If 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 +4 more
#PRE-BEF-AFT-FLAG
BEF_AFT_FLAG		Alpha 1If 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 +4 more
#PRE-ROUND-TO
ROUND_TO		Signed 9.4If 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 +4 more
#PRE-AMT-MINIMUM
AMT_MINIMUM		Signed 11.2Indicates if the salary minimum amount is used.BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more
#PRE-AMT-MAXIMUM
AMT_MAXIMUM		Signed 11.2Indicates if the salary maximum amount is used.BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more
#PRE-TABLE-TYPE
TABLE_TYPE		Alpha 2If 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 +2 more
#PRE-EMP-SPS-AGE
EMP_SPS_AGE		Alpha 1If 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 or Domestic Partner
BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +1 more
#PRE-AGE-DATE
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 +1 more
#PRE-AGE-FIRST-MO
AGE_FIRST_MO		Alpha 1If 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 +1 more
#PRE-FROM-DATE
FROM_DATE		Alpha 2If 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 +3 more
#PRE-SERV-DATE
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 +2 more
#PRE-SERV-FIRST-MO
SERV_FIRST_MO		Alpha 1If 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 +2 more
#PRE-EMP-CONT
EMP_CONT		Signed 9.4If 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
COMP_CONT		Signed 13.4If 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
FLEX_CONT		Signed 9.4If 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 SET6
RATE_TABLE		Alpha 4Indicates 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
CONTRIB_BASIS		Alpha 1If 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
COST_PER_CVG		Signed 9.2If 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
ANN_AMT_MIN		Signed 11.2If 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
ANN_AMT_MAX		Signed 11.2If 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
PCT_MINIMUM		Signed 7.4If 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
PCT_MAXIMUM		Signed 7.4If 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
COMP_AMT		Signed 7.2If 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
COMP_PCT		Signed 7.4If 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
VAC_MAX_HOURS		Signed 6.3If 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
VAC_COST		Signed 5.2If 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
INCREMENT		Signed 5.2If 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 +2 more
#PRE-EMP-CONT-TYPE
EMP_CONT_TYPE		Alpha 1If 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 +2 more
#PRE-CONT-TAX-STS
CONT_TAX_STS		Alpha 1Indicates 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 +4 more
#PRE-MATCH-OPTION
MATCH_OPTION		Alpha 1If 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 +2 more
#PRE-MATCH-CALC
MATCH_CALC		Alpha 1If 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 +1 more
#PRE-END-PCT
END_PCT		Numeric 3If 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 +1 more
#PRE-E-COMP-CONT1
E_COMP_CONT1		Signed 7.2This field is not used.BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7
#PRE-R-COMP-CONT1
R_COMP_CONT1		Signed 7.2This field is not used.BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7
#PRE-RET-RATE-TBL
RET_RATE_TBL		Alpha 2This field is not used.BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7
#PRE-STATUS
STATUS		Numeric 1This 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 +10 more
#PRE-RET-STATUS
RET_STATUS		Numeric 1This 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 +10 more
#PRE-EARLY-RT-AGE
EARLY_RT_AGE		Numeric 2This field is not used.BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7
#PRE-REG-RT-AGE
REG_RT_AGE		Numeric 2This field is not used.BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7
#PRE-FLEX-CONT1
FLEX_CONT1		Signed 7.2This field is not used.BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7
#PRE-DEFAUL-TAX-TYP
DEFAUL_TAX_TYP		Alpha 1Contains 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 +4 more
#PRE-SALARY-YEAR
SALARY_YEAR		Numeric 4If 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 +4 more
#PRE-AGE-YEAR
AGE_YEAR		Numeric 4If 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 +1 more
#PRE-SERV-YEAR
SERV_YEAR		Numeric 4If 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 +1 more
#PRE-PAY-PER-MIN
PAY_PER_MIN		Signed 6.2If 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
PAY_PER_MAX		Signed 6.2If 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 PK
COVER_TYPE		Alpha 1Indicates 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 +4 more
#PRE-COBRA-STATUS
COBRA_STATUS		Numeric 1If 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 +10 more
#PRE-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more
#PRE-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more
#PRE-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more
#PRE-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more
#PRE-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more
#PRE-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more

Indexes (6)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PRESET1
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. COVER-TYPE
  5. START-DATE
  6. GROUP-NAME
PrimaryBN00.1, BN02.1, BN02.2, BN02.3, BN02.4, BN100, BN101, BN102 +22 more (list truncated in source)
PRESET3
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. COVER-TYPE
  5. START-DATE ↓
  6. GROUP-NAME
BN100, BN101, BN102, BN103, BN105, BN145, BN215, BN230 +22 more (list truncated in source)
PRESET5
  1. COMPANY
  2. CONTRIB-TYPE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. COVER-TYPE
  6. START-DATE
  7. GROUP-NAME
BN18.6
PRESET6
  1. COMPANY
  2. COVER-TYPE
  3. RATE-TABLE
  4. START-DATE
  5. PLAN-TYPE
  6. PLAN-CODE
  7. GROUP-NAME
KeyChangeBN02.1, BN02.2, BN02.3, BN02.4, BN02.5
PRESET7
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. COVER-TYPE
  5. GROUP-NAME
  6. START-DATE ↓
BN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more
PRESET8
  1. COMPANY
  2. CONTRIB-TYPE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. COVER-TYPE
  6. START-DATE ↓
  7. GROUP-NAME
BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
RATETBLHDRBNCOMPANYPRSYSTEMPLANPERSGROUPBNPRMOPTCONTRDETLRATETBLDTLPREMIUM

One to one (18) — lookups and parents

RelationTableRulesConditionField map
Age Rate TableRATETBLHDRNot RequiredValid When RTH-TABLE-TYPE = "1"
PRE-COMPANY→RTH-COMPANY
PRE-RATE-TABLE→RTH-TABLE-CODE
PRE-START-DATE→RTH-START-DATE
CompanyBNCOMPANYRequired
PRE-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
PRE-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Contrib 0PLANRequiredWhen PLN-CONTRIB-TYPE = "0"
PRE-COMPANY→PLN-COMPANY
PRE-PLAN-TYPE→PLN-PLAN-TYPE
PRE-PLAN-CODE→PLN-PLAN-CODE
Contrib 1PLANRequiredWhen PRE-CONTRIB-TYPE = "1"
PRE-COMPANY→PLN-COMPANY
PRE-PLAN-TYPE→PLN-PLAN-TYPE
PRE-PLAN-CODE→PLN-PLAN-CODE
Contrib 2PLANRequiredWhen PRE-CONTRIB-TYPE = "2"
PRE-COMPANY→PLN-COMPANY
PRE-PLAN-TYPE→PLN-PLAN-TYPE
PRE-PLAN-CODE→PLN-PLAN-CODE
Contrib 3PLANRequiredWhen PRE-CONTRIB-TYPE = "3"
PRE-COMPANY→PLN-COMPANY
PRE-PLAN-TYPE→PLN-PLAN-TYPE
PRE-PLAN-CODE→PLN-PLAN-CODE
Contrib 4PLANRequiredWhen PRE-CONTRIB-TYPE = "4"
PRE-COMPANY→PLN-COMPANY
PRE-PLAN-TYPE→PLN-PLAN-TYPE
PRE-PLAN-CODE→PLN-PLAN-CODE
Contrib 5PLANRequiredWhen PRE-CONTRIB-TYPE = "5"
PRE-COMPANY→PLN-COMPANY
PRE-PLAN-TYPE→PLN-PLAN-TYPE
PRE-PLAN-CODE→PLN-PLAN-CODE
Contrib 6PLANRequiredWhen PRE-CONTRIB-TYPE = "6"
PRE-COMPANY→PLN-COMPANY
PRE-PLAN-TYPE→PLN-PLAN-TYPE
PRE-PLAN-CODE→PLN-PLAN-CODE
Contrib 7PLANRequiredWhen PRE-CONTRIB-TYPE = "7"
PRE-COMPANY→PLN-COMPANY
PRE-PLAN-TYPE→PLN-PLAN-TYPE
PRE-PLAN-CODE→PLN-PLAN-CODE
Contrib UserPLANRequiredWhen PRE-CONTRIB-TYPE = "X"
PRE-COMPANY→PLN-COMPANY
PRE-PLAN-TYPE→PLN-PLAN-TYPE
PRE-PLAN-CODE→PLN-PLAN-CODE
PersgroupPERSGROUPNot Required
PRE-COMPANY→PRG-COMPANY
PRE-GROUP-NAME→PRG-GROUP-NAME
PlanPLANRequired
PRE-COMPANY→PLN-COMPANY
PRE-PLAN-TYPE→PLN-PLAN-TYPE
PRE-PLAN-CODE→PLN-PLAN-CODE
PrsystemPRSYSTEMRequired
PRE-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Rate TableRATETBLHDRNot Required
PRE-COMPANY→RTH-COMPANY
PRE-RATE-TABLE→RTH-TABLE-CODE
PRE-START-DATE→RTH-START-DATE
Sal Rate TableRATETBLHDRNot RequiredValid When RTH-TABLE-TYPE = "2"
PRE-COMPANY→RTH-COMPANY
PRE-RATE-TABLE→RTH-TABLE-CODE
PRE-START-DATE→RTH-START-DATE
Serv Rate TblRATETBLHDRNot RequiredValid When RTH-TABLE-TYPE = "3"
PRE-COMPANY→RTH-COMPANY
PRE-RATE-TABLE→RTH-TABLE-CODE
PRE-START-DATE→RTH-START-DATE

One to many (4) — child tables

RelationTableRulesConditionField map
BnprmoptBNPRMOPTDelete 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
ContrdetlCONTRDETL
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 SchCONTRDETL
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 DtlRATETBLDTLDelete Restricted
PRE-COMPANY→RTD-COMPANY
PRE-RATE-TABLE→RTD-TABLE-CODE
PRE-START-DATE→RTD-START-DATE
—→RTD-BEG-AGE-YR-SAL
—→RTD-SMOKER

Programs

Updated by (56)

Referenced by (10)