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.

Field / column	Type	Description & values	Updated by
`PRE-COMPANY` PK COMPANY	Numeric 4	Contains 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 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 +4 more
`PRE-PLAN-CODE` PK 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 +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 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 +4 more
`PRE-CONTRIB-TYPE` 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 +4 more
`PRE-CALC-TYPE` 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 +2 more
`PRE-SALARY-TYPE` 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 +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 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 +4 more
`PRE-ROUND-METH` 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 +4 more
`PRE-BEF-AFT-FLAG` 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 +4 more
`PRE-ROUND-TO` 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 +4 more
`PRE-AMT-MINIMUM` 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 +4 more
`PRE-AMT-MAXIMUM` 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 +4 more
`PRE-TABLE-TYPE` 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 +2 more
`PRE-EMP-SPS-AGE` 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 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 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 +1 more
`PRE-FROM-DATE` 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 +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 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 +2 more
`PRE-EMP-CONT` EMP_CONT	Signed 9.4	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` COMP_CONT	Signed 13.4	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` FLEX_CONT	Signed 9.4	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` 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` 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` 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` 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` 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` PCT_MINIMUM	Signed 7.4	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` PCT_MAXIMUM	Signed 7.4	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` 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` COMP_PCT	Signed 7.4	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` 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` 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` 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 +2 more
`PRE-EMP-CONT-TYPE` 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 +2 more
`PRE-CONT-TAX-STS` 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 +4 more
`PRE-MATCH-OPTION` 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 +2 more
`PRE-MATCH-CALC` 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 +1 more
`PRE-END-PCT` 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 +1 more
`PRE-E-COMP-CONT1` 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` 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` 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` 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 +10 more
`PRE-RET-STATUS` 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 +10 more
`PRE-EARLY-RT-AGE` 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` 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` 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` 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 +4 more
`PRE-SALARY-YEAR` 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 +4 more
`PRE-AGE-YEAR` 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 +1 more
`PRE-SERV-YEAR` 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 +1 more
`PRE-PAY-PER-MIN` 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` 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` PK 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 +4 more
`PRE-COBRA-STATUS` 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 +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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`PRESET1`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `COVER-TYPE`, `START-DATE`, `GROUP-NAME`	Primary	BN00.1, BN02.1, BN02.2, BN02.3, BN02.4, BN100, BN101, BN102 +22 more (list truncated in source)
`PRESET3`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `COVER-TYPE`, `START-DATE*`, `GROUP-NAME`		BN100, BN101, BN102, BN103, BN105, BN145, BN215, BN230 +22 more (list truncated in source)
`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 +4 more
`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

Relations

One to one (18) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (4) — child tables

Relation	Table	Rules	Field map
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`

Programs

Updated by (56)

BN00.1 Benefits Company
BN02.1 Age Rate Table
BN02.2 Salary Rate Table
BN02.3 Service Rate Table
BN02.4 Credits Rate Table
BN02.5 Coverage Reduction Table
BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN145 Flex Dollars Calculation
BN15.1 Benefit Plan
BN18.1 Options Amount
BN18.2 Options Amount Range
BN18.3 Flat Contributions
BN18.4 Salary or Coverage Rate Table
BN18.5 Contribution Limits
BN18.6 Match Limit Schedule
BN18.7 Match Percent Schedule
BN19.1 Options Rates
BN19.2 Options Rate Tables
BN19.3 Match Limits
BN19.4 Match Percents
BN232 Benefits Statement
BN245 Benefit Election Form
BN260 Employee Benefit Extract
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN320 Premium Report
BN331 HIPAA Certification Report
BN340 ADP and ACP Tests
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN65.1 Election Simulation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS09.1 Employee Annual Enrollment Rules
BS10.1 Web Enrollment Current Benefit Inquiry
BS11.1 Web Enrollment Employee Flex Dollar Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
ZB01.1 Years Of Service Calculation
ZB10.1 Coverage Options Calculator
ZB10.2 Get Benefit Eligibility Dates
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add

Referenced by (10)

BN104 Frequency Table Update
BN17.1 Coverage Options by Plan
BN180 Invoice Edit
BN215 Plan Parameter Listing
BN220 Benefit Plan Status Report
BN230 Plan Participant Report
BN242 One Page Benefits Statement
HR55.1 Employee Group Definition
PRBN.1 Payroll Cycle Benefit Edit
ZB599 Update Enrollment Data Structu