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.

Field / columnTypeDescription & valuesUpdated by
PCV-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN15.1, BN17.1, BN19.1, BN19.2
PCV-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains 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 4Contains the user-defined code that represents a benefit plan.BN15.1, BN17.1, BN19.1, BN19.2
PCV-GROUP-NAME PK
GROUP_NAME		Alpha 10Contains 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 2Contains the coverage option with which the contributions are associated.BN15.1, BN17.1, BN19.1, BN19.2
PCV-EMP-CONT
EMP_CONT		Signed 7.2If 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.2If 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.2If 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 4If 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.2This field is not used.BN15.1, BN17.1, BN19.1, BN19.2
PCV-E-CO-CONT
E_CO_CONT		Signed 7.2This field is not used.BN15.1, BN17.1, BN19.1, BN19.2
PCV-R-RET-CONT
R_RET_CONT		Signed 7.2This field is not used.BN15.1, BN17.1, BN19.1, BN19.2
PCV-R-CO-CONT
R_CO_CONT		Signed 7.2This field is not used.BN15.1, BN17.1, BN19.1, BN19.2
PCV-COBRA-CONT
COBRA_CONT		Signed 7.2This field is not used.BN15.1, BN17.1, BN19.1, BN19.2
PCV-EARLY-RET-AGE
EARLY_RET_AGE		Numeric 2This field is not used.BN15.1, BN17.1, BN19.1, BN19.2
PCV-REG-RET-AGE
REG_RET_AGE		Numeric 2This field is not used.BN15.1, BN17.1, BN19.1, BN19.2
PCV-TERM-AGE
TERM_AGE		Numeric 2This field is not used.BN15.1, BN17.1, BN19.1, BN19.2
PCV-PREMIUM-CHG
PREMIUM_CHG		Numeric 1This field is not used.
  • 0 Not Updated
  • 1 Updated
BN15.1, BN17.1, BN19.1, BN19.2
PCV-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1Indicates 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 1For 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCVSET1COMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME, COVERAGE-OPTPrimaryBN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN100, BN101, BN102 +22 more (list truncated in source)
PCVSET2COMPANY, PLAN-TYPE, PLAN-CODE, COVERAGE-OPT, COVER-TYPE, START-DATE, GROUP-NAMEBN17.1

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
BncovoptBNCOVOPTRequiredPCV-COMPANY → COP-COMPANY, PCV-PLAN-TYPE → COP-PLAN-TYPE, PCV-PLAN-CODE → COP-PLAN-CODE, PCV-COVERAGE-OPT → COP-COVERAGE-OPT
Company NamePRSYSTEMRequiredPCV-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
PersgroupPERSGROUPNot RequiredPCV-COMPANY → PRG-COMPANY, PCV-GROUP-NAME → PRG-GROUP-NAME
PlanPLANRequiredPCV-COMPANY → PLN-COMPANY, PCV-PLAN-TYPE → PLN-PLAN-TYPE, PCV-PLAN-CODE → PLN-PLAN-CODE
PrsystemPRSYSTEMRequiredPCV-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
RatetblhdrRATETBLHDRNot RequiredPCV-COMPANY → RTH-COMPANY, PCV-RATE-TABLE → RTH-TABLE-CODE, PCV-START-DATE → RTH-START-DATE

One to many (2) — child tables

RelationTableRulesConditionField map
PremiumPREMIUMRequiredPCV-COMPANY → PRE-COMPANY, PCV-PLAN-TYPE → PRE-PLAN-TYPE, PCV-PLAN-CODE → PRE-PLAN-CODE, → PRE-COVER-TYPE, → PRE-START-DATE, → PRE-GROUP-NAME
RatetbldtlRATETBLDTLPCV-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)

Referenced by (35)