BNCOVOPT – Benefit Coverage Options

System: Benefits (BN)
Prefix: COP
Primary key: COMPANY, PLAN-TYPE, PLAN-CODE, COVERAGE-OPT
Fields: 20
Updated by: 3 programs
Referenced by: 54 programs

BNCOVOPT is the Benefit Coverage Options table in Lawson Benefits (prefix COP). It is indexed by COMPANY, PLAN-TYPE, PLAN-CODE, COVERAGE-OPT (COPSET1). It is related 1:1 to PLAN and PRSYSTEM. It is updated by BN15.1, BN17.1 and BS04.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN106, BN19.1, BN19.2 and 46 more. The table has 20 fields, 1 index and 2 documented relations.

About BNCOVOPT

The Benefit Coverage Options file defines the coverage options available for a plan; for example, single, family, and so on. The Benefits Coverage Options file is linked to the Benefits Coverage Defaults file, which further defines valid coverage options by date and by employee group. Each coverage option is one record in this file.

Fields (20)

Column = COBOL field name without the COP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`COP-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN17.1, BS04.1
`COP-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	Select the benefits coverage type. `HL` Health `DN` Dental `DI` Disability `EL` Employee Life `DL` Dependent Life `DC` Defined Contribution `DB` Defined Benefit `VA` Vacation `RS` Spending Account `SB` Savings Bond `SP` Stock Purchase	BN17.1, BS04.1
`COP-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BN17.1, BS04.1
`COP-COVERAGE-OPT` PK COVERAGE_OPT	Numeric 2	Contains the coverage option used when benefits are entered.	BN17.1, BS04.1
`COP-COV-DESC` COV_DESC	Alpha 30 (Lower Case)	Contains a user-defined description of the coverage option.	BN17.1
`COP-STUDENT-AGE` STUDENT_AGE	Numeric 2	If a coverage option provides coverage for dependents and if the employee has a dependent who is a student, this field contains the student's age.	BN17.1
`COP-DEP-AGE` DEP_AGE	Numeric 2	If a coverage option provides coverage for dependents, this field contains the dependent's age.	BN17.1
`COP-COV-DEPENDENTS` COV_DEPENDENTS	Alpha 1	Indicates whether the spouse, dependents, spouse and dependents, or neither are covered for this coverage option. `S` Spouse `D` Dependents `B` Spouse and Deps `N` None `P` Domestic Partner `O` Spouse or Partner `R` Partner Deps `C` Partner and Deps `A` Spouse or Partner and Deps	BN17.1
`COP-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	Contains the Active flag of the coverage option. `A` Active `I` Inactive	BN17.1
`COP-NBR-DEPENDENTS` NBR_DEPENDENTS	Numeric 2	Maximum number of dependents allowed in the plan.	BN17.1, BS04.1
`COP-PT-STUDENTS` PT_STUDENTS	Alpha 1	— `N` No `Y` Yes	BN17.1
`COP-MAX-AGE-FLAG` MAX_AGE_FLAG	Alpha 1	—	—
`COP-TERM-OPT` TERM_OPT	Alpha 1	— `1` Birthdate of Maximum Age `2` Last Day of Month of Max Age	BN17.1
`COP-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN17.1, BS04.1
`COP-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN17.1, BS04.1
`COP-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN17.1, BS04.1
`COP-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN17.1, BS04.1
`COP-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN17.1, BS04.1
`COP-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN17.1, BS04.1
`COP-MIN-NBR-DEP` MIN_NBR_DEP	Numeric 2	Minimum number of dependents allowed for the plan.	BN17.1, BS04.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`COPSET1`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `COVERAGE-OPT`	Primary		BN100, BN101, BN102, BN103, BN105, BN106, BN15.1, BN17.1 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Plan	PLAN	Required		`COP-COMPANY` → `PLN-COMPANY`, `COP-PLAN-TYPE` → `PLN-PLAN-TYPE`, `COP-PLAN-CODE` → `PLN-PLAN-CODE`
Prsystem	PRSYSTEM	Required		`COP-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`

Programs

Updated by (3)

BN15.1 Benefit Plan
BN17.1 Coverage Options by Plan
BS04.1 Benefits Number Of Dependents

Referenced by (54)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN106 Benefit Transaction Export
BN19.1 Options Rates
BN19.2 Options Rate Tables
BN215 Plan Parameter Listing
BN230 Plan Participant Report
BN231 Employee Benefit Report
BN232 Benefits Statement
BN233 COBRA and Retiree Benefit Report
BN242 One Page Benefits Statement
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
BN320 Premium Report
BN321 Dependent Benefit Listing
BN331 HIPAA Certification Report
BN51.1 Employee Benefit Summary
BN51.2 Employee Benefit Detail
BN53.1 Benefit Transactions
BN531 Batch Benefit Enrollment
BN532 Batch Dependent Benefit Enrollment
BN65.1 Election Simulation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BN77.1 COBRA and Retiree Benefit Inquiry
BS10.1 Web Enrollment Current Benefit Inquiry
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
HCVO.1 Coverage Option Selection Invoke
HR13.1 Dependent
HR13.2 Dependent Benefits
HR13.3 Dependent Benefits
HR13.4 Dependent Benefits
HR170 Human Resource Writer Report Request
HR513 Dependent Conversion
HR70.1 Human Resource Writer Inquiry
PA218 Travel Listing
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
ZH230 PPH Big Bad Edit