BNPRMOPT – Benefit Premium Options

System: Benefits (BN)
Prefix: PCV
Primary key: COMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME, COVERAGE-OPT
Fields: 27
Updated by: 11 programs
Referenced by: 35 programs

BNPRMOPT is the Benefit Premium Options table in Lawson Benefits (prefix PCV). It is indexed by COMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME, COVERAGE-OPT (PCVSET1); alternate indexes: PCVSET2. It is related 1:1 to BNCOVOPT, PRSYSTEM, PERSGROUP, PLAN and RATETBLHDR and 1:M to PREMIUM and RATETBLDTL. It is updated by BN15.1, BN17.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6 and 3 more and referenced by BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN100, BN101, BN102 and 27 more. The table has 27 fields, 2 indexes and 8 documented relations.

About BNPRMOPT

No description in the Lawson data dictionary.

Fields (27)

Column = COBOL field name without the PCV- 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 / column	Type	Description & values	Updated by
#`PCV-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	Contains the plan type that identifies the type of benefit. `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, BN17.1, BN19.1, BN19.2
#`PCV-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-GROUP-NAME` PK GROUP_NAME	Alpha 10	Contains the group that uses the contribution record. This field may contain spaces.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	Contains the start date for contribution.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-COVERAGE-OPT` PK COVERAGE_OPT	Numeric 2	Contains the coverage option with which the contributions are associated.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-EMP-CONT` EMP_CONT	Signed 7.2	If the contribution type is the same as the option amount, this is the employee contribution.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-COMP-CONT` COMP_CONT	Signed 11.2	If the contribution type is the same as the option amount, this field contains the company contribution.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-FLEX-CONT` FLEX_CONT	Signed 7.2	If the contribution type is the same as the option amount, this field contains the flex credit contribution.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-RATE-TABLE` RATE_TABLE	Alpha 4	If the contribution type is the same as the options amount range, this field contains the rate table used for the contribution.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-E-RET-CONT` E_RET_CONT	Signed 7.2	This field is not used.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-E-CO-CONT` E_CO_CONT	Signed 7.2	This field is not used.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-R-RET-CONT` R_RET_CONT	Signed 7.2	This field is not used.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-R-CO-CONT` R_CO_CONT	Signed 7.2	This field is not used.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-COBRA-CONT` COBRA_CONT	Signed 7.2	This field is not used.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-EARLY-RET-AGE` EARLY_RET_AGE	Numeric 2	This field is not used.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-REG-RET-AGE` REG_RET_AGE	Numeric 2	This field is not used.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-TERM-AGE` TERM_AGE	Numeric 2	This field is not used.	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-PREMIUM-CHG` PREMIUM_CHG	Numeric 1	This field is not used. `0` Not Updated `1` Updated	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	Indicates if the option contribution is active or inactive. `A` Active `I` Inactive	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-COVER-TYPE` PK COVER_TYPE	Alpha 1	For each record, indicates if the contribution type is for employees, retirees, COBRA participants. `E` Employee `C` COBRA Participant `R` Retiree	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN15.1, BN17.1, BN19.1, BN19.2
#`PCV-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN15.1, BN17.1, BN19.1, BN19.2

Indexes (2)

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.

Index	Keys	Flags	Condition	Used in
`PCVSET1`	`COMPANY` `PLAN-TYPE` `PLAN-CODE` `COVER-TYPE` `START-DATE` `GROUP-NAME` `COVERAGE-OPT`	Primary		BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN100, BN101, BN102 +22 more (list truncated in source)
`PCVSET2`	`COMPANY` `PLAN-TYPE` `PLAN-CODE` `COVERAGE-OPT` `COVER-TYPE` `START-DATE` `GROUP-NAME`			BN17.1

Relations

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

One to one (6) — lookups and parents

Relation Table Rules Condition Field map

Bncovopt

BNCOVOPT

Required

`PCV-COMPANY`	→	`COP-COMPANY`
`PCV-PLAN-TYPE`	→	`COP-PLAN-TYPE`
`PCV-PLAN-CODE`	→	`COP-PLAN-CODE`
`PCV-COVERAGE-OPT`	→	`COP-COVERAGE-OPT`

Company Name

PRSYSTEM

Required

`PCV-COMPANY`	→	`PRS-COMPANY`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Persgroup

PERSGROUP

Not Required

`PCV-COMPANY`	→	`PRG-COMPANY`
`PCV-GROUP-NAME`	→	`PRG-GROUP-NAME`

Plan

PLAN

Required

`PCV-COMPANY`	→	`PLN-COMPANY`
`PCV-PLAN-TYPE`	→	`PLN-PLAN-TYPE`
`PCV-PLAN-CODE`	→	`PLN-PLAN-CODE`

Prsystem

PRSYSTEM

Required

`PCV-COMPANY`	→	`PRS-COMPANY`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Ratetblhdr

RATETBLHDR

Not Required

`PCV-COMPANY`	→	`RTH-COMPANY`
`PCV-RATE-TABLE`	→	`RTH-TABLE-CODE`
`PCV-START-DATE`	→	`RTH-START-DATE`

One to many (2) — child tables

Relation Table Rules Condition Field map

Premium

PREMIUM

Required

`PCV-COMPANY`	→	`PRE-COMPANY`
`PCV-PLAN-TYPE`	→	`PRE-PLAN-TYPE`
`PCV-PLAN-CODE`	→	`PRE-PLAN-CODE`
—	→	`PRE-COVER-TYPE`
—	→	`PRE-START-DATE`
—	→	`PRE-GROUP-NAME`

Ratetbldtl

RATETBLDTL

`PCV-COMPANY`	→	`RTD-COMPANY`
`PCV-RATE-TABLE`	→	`RTD-TABLE-CODE`
`PCV-START-DATE`	→	`RTD-START-DATE`
—	→	`RTD-BEG-AGE-YR-SAL`
—	→	`RTD-SMOKER`

Programs

Updated by (11)

BN15.1 Benefit Plan
BN17.1 Coverage Options by 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

Referenced by (35)

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
BN215 Plan Parameter Listing
BN245 Benefit Election Form
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
BN531 Batch Benefit Enrollment
BN65.1 Election Simulation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS10.1 Web Enrollment Current Benefit 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
HR55.1 Employee Group Definition
ZB10.1 Coverage Options Calculator
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
ZB599 Update Enrollment Data Structu

BNPRMOPT – Benefit Premium Options

About BNPRMOPT

Fields (27) Copy as SQL

Indexes (2)

Relations

One to one (6) — lookups and parents

One to many (2) — child tables

Programs

Updated by (11)

Referenced by (35)

Fields (27)