BNCOVERAGE – Benefit Coverage

System: Benefits (BN)
Prefix: CVR
Primary key: COMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME
Fields: 52
Updated by: 45 programs
Referenced by: 15 programs

BNCOVERAGE is the Benefit Coverage table in Lawson Benefits (prefix CVR). It is indexed by COMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME (CVRSET1); alternate indexes: CVRSET2, CVRSET3 and CVRSET4. It is related 1:1 to PLAN, PERSGROUP, PRSYSTEM and RATETBLHDR. It is updated by BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN100, BN101, BN102 and 37 more and referenced by BN150, BN215, BN220, BN242, BN53.1, BN532, HR13.1, HR13.2 and 7 more. The table has 52 fields, 4 indexes and 9 documented relations.

About BNCOVERAGE

The Benefit Coverage file contains coverage parameters for benefit plans with a coverage type of Coverage Amount.

Fields (52)

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

Field / column	Type	Description & values	Updated by
`CVR-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN17.3
`CVR-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	Contains the plan 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.3
`CVR-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BN17.3
`CVR-GROUP-NAME` PK GROUP_NAME	Alpha 10	Contains the employee group for which the coverage record applies. If the group is blank, the system will use this coverage record for all employees who do not qualify for coverage for a specific group.	BN17.3
`CVR-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	Contains the date the coverage parameters begin.	BN17.3
`CVR-CALC-TYPE` CALC_TYPE	Alpha 1	Defines how the coverage amount will be determined for the plan. `F` Flat Amount `M` Multiple Salary `P` Percent `S` Supplemental `X` Custom Calculation `N` Fixed Multiple of Salary	BN17.3
`CVR-LIFE-ADD-FLG` LIFE_ADD_FLG	Alpha 1	Contains a value that determines who is covered under the plan. Employee is not a valid value for Dependent Life plans. Spouse, Dependent, and Both Spouse and Dependent are not valid values for Employee Life plans. `E` Employee `S` Spouse `D` Dependents `B` Spouse and Deps `P` Domestic Partner `O` Spouse or Partner `R` Partner Deps `C` Partner and Deps `A` Spouse or Partner and Deps	BN17.3
`CVR-STUDENT-AGE` STUDENT_AGE	Numeric 2	Contains the age coverage terminates for dependents who are flagged as students. If the dependent is a student, this age overrides the dependent age.	BN17.3
`CVR-DEP-AGE` DEP_AGE	Numeric 2	If the plan covers dependents or spouses and dependents, this field contains the age dependent coverage terminates for dependents if the dependent is not flagged as a student.	BN17.3
`CVR-FLAT-AMT-1` FLAT_AMT_1	Signed 11.2	For a plan with a calculation type of flat amount, this is the flat amount of coverage. If a plan covers both spouses and dependents, this is the spouse coverage amount.	BN17.3, BN320
`CVR-FLAT-AMT-2` FLAT_AMT_2	Signed 11.2	If the calculation type is flat amount and the plan covers both spouses and dependents, this is the dependent coverage amount.	BN17.3, BN320
`CVR-INCREMENTS` INCREMENTS	Signed 11.4	If the coverage calculation type is supplemental, this field defines the increments of coverage an employee may elect. Coverage under this plan will be a multiple of this amount.	BN17.3
`CVR-MULT-SALARY` MULT_SALARY	Signed 6.3	If the coverage calculation type is a multiple of salary, this field defines the valid multiples the employee may elect. Coverage under this plan will be a multiple of this increment.	BN17.3
`CVR-SALARY-PCT` SALARY_PCT	Signed 5.2	If the coverage calculation type is a percent, this the percent of the employee's salary which will be used to calculate coverage.	BN17.3
`CVR-SALARY-TYPE` SALARY_TYPE	Alpha 2	If the coverage calculation type is a percent of salary, a multiple of salary, or if the coverage limit is a multiple of salary, this field defines which field is used to define the salary to be used in calculations. `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	BN17.3
`CVR-SALARY-DATE` SALARY_DATE	Numeric 4 (mmdd)	If the coverage is based on the employee's salary, and the salary is determined on a specific month and day, this field contains the date the salary is determined.	BN17.3
`CVR-SAL-FIRST-MO` SAL_FIRST_MO	Alpha 1	If coverage is based on salary, and the salary should be the salary in effect on the first of the month for which a benefit is created, the salary will be flagged as first of month. The As Of date is defined in the Salary Date and Salary Year fields. The Flex Calc date is the same as the date on which flex dollars are calculated. `C` Current `M` First of Month `A` As Of Date `F` Flex Calc Date	BN17.3
`CVR-ROUND-METH` ROUND_METH	Alpha 1	If coverage is based on salary, this field defines how the salary amount should be rounded. `H` High `L` Low `N` No Rounding `R` Normal Rounding	BN17.3
`CVR-BEF-AFT-FLAG` BEF_AFT_FLAG	Alpha 1	If the coverage amount is based on salary this field defines whether the salary amount should be rounded before the coverage amount is calculated, or if the coverage amount should be rounded after the calculation is done. `B` Before `A` After	BN17.3
`CVR-ROUND-TO` ROUND_TO	Signed 9.4	If the salary amount is rounded, this defines to what place the amount is rounded.	BN17.3
`CVR-MIN-COVER` MIN_COVER	Signed 11.2	If a plan has a minimum coverage amount, the minimum is contained in this field. If the plan is a multiple of salary or a percent, and the calculated coverage amount is less than the minimum, the minimum will be used. If the plan is a supplemental plan and the elected amount is less than the minimum, the system will generate an error.	BN17.3
`CVR-MAX-COVER` MAX_COVER	Signed 11.2	If the plan has a maximum coverage amount, the maximum is specified in this field. If the plan is a multiple of salary or a percent, and the calculated amount is greater than the maximum, the maximum amount will be used. If the plan is a supplemental plan, and the employee elects more than the maximum, the system will generate an error.	BN17.3
`CVR-MIN-MULTIPLE` MIN_MULTIPLE	Signed 5.2	If the plan is a multiple of salary, or if the plan has a minimum which is specified a multiple of salary, this is the minimum multiple.	BN17.3, BS14.1
`CVR-MAX-MULTIPLE` MAX_MULTIPLE	Signed 5.2	If the plan is a multiple of salary or if there is a limit defined as a multiple of salary, this field defines the maximum multiple.	BN17.3
`CVR-RATE-TABLE` RATE_TABLE	Alpha 4	If the plan specifies a reduction of coverage at specific ages, this is the rate table used to define the coverage reduction parameters. The table is defined in the Rate Table Header file which uses the Coverage Start Date and the Rate Table fields to connect the records.	BN17.3
`CVR-AGE-DATE` AGE_DATE	Numeric 4 (mmdd)	If the plan has a coverage reduction table based on age, and the age is determined on a specific date, the employee or spouse's age on this date is calculated.	BN17.3
`CVR-AGE-FIRST-MO` AGE_FIRST_MO	Alpha 1	If the plan has a coverage reduction at specific ages, and the employee or spouse's age should be calculated for the first of each month, first of month will be yes. `C` Current `M` First of Month `A` As of Date `F` Flex Calc Date	BN17.3
`CVR-COV-ROUND-METH` COV_ROUND_METH	Alpha 1	If the coverage amount is to be rounded, this defines coverage amount should be rounded. `H` High `L` Low `N` No Rounding `R` Normal Rounding	BN17.3
`CVR-COV-ROUND-TO` COV_ROUND_TO	Signed 9.4	If the coverage amounts are to be rounded, this defines to what place the amount is rounded.	BN17.3
`CVR-DEFAULT-COVER` DEFAULT_COVER	Alpha 1	Indicates whether this is default coverage. If this is default coverage, the coverage will default on all benefit entry forms and all updates when a benefit is automatically added. `Y` Yes `N` No	BN17.3
`CVR-DEFAULT-AMT` DEFAULT_AMT	Signed 11.2	Contains the default coverage for employees who do not elect a coverage amount. This is used for supplemental plans only.	BN17.3
`CVR-DEFAULT-MULT` DEFAULT_MULT	Signed 5.2	If the default coverage flag is Yes, and if the plan coverage is a multiple of the salary, this field contains the salary multiple.	BN17.3
`CVR-COVERAGE-CHG` COVERAGE_CHG	Numeric 1	Indicates that the coverage is changed. If the coverage is Non Updated, BN105 (Plan Update) must be run before PR140 (Earnings and Deductions Calculation) is run. `0` Non Updated `1` Updated	BN02.5
`CVR-SALARY-YEAR` SALARY_YEAR	Numeric 4	Contains the year if salary calculations are based on a specific year.	BN17.3
`CVR-AGE-YEAR` AGE_YEAR	Numeric 4	Contains the year if age calculations are based on an age.	BN17.3
`CVR-BENEFIT-PCT` BENEFIT_PCT	Signed 5.2	If coverage is limited to a percent of coverage under another benefit, this is the percent limit.	BN17.3, BN65.1
`CVR-BN-PLAN-TYPE` BN_PLAN_TYPE	Alpha 2	If coverage is limited to a percent of coverage under another benefit, this field contains the plan upon which coverage limits are placed. `DB` Defined Benefit `DC` Defined Contribution `DI` Disability `DL` Dependent Life `DN` Dental `EL` Employee Life `HL` Health `RS` Spending Account `SB` Savings Bond `SP` Stock Purchase `VA` Vacation	BN17.3
`CVR-BN-PLAN-CODE` BN_PLAN_CODE	Alpha 4	If coverage is limited to a percent of coverage under another benefit, this field contains the plan code upon which coverage limits are placed.	BN17.3
`CVR-COVER-TYPE` PK COVER_TYPE	Alpha 1	Indicates the coverage is for employees, retirees, or COBRA participants for each premium record. `E` Employees `R` Retirees `C` COBRA	BN17.3
`CVR-STATUS` STATUS	Numeric 1	Contains the coverage status. When PR180 (Manual Payment Print) is run for a payment date, BN105 must also be run to update employee coverage records if a record of - New Group, New Date; - Existing Group, New Date; or - Change Existing Record exists for any date before or on the payment date. `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, BN17.3
`CVR-RET-STATUS` RET_STATUS	Numeric 1	Indicates the retiree's coverage status. `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, BN17.3
`CVR-COBRA-STATUS` COBRA_STATUS	Numeric 1	Contains the COBRA participant's status. `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, BN17.3
`CVR-COVER-FREQ` COVER_FREQ	Alpha 2	This field is not used. `AN` Annual `MO` Monthly `SM` Semi-monthly `BW` Bi-weekly `WK` Weekly	—
`CVR-PT-STUDENTS` PT_STUDENTS	Alpha 1	— `N` No `Y` Yes	BN17.3
`CVR-MAX-AGE-FLAG` MAX_AGE_FLAG	Alpha 1	—	—
`CVR-TERM-OPT` TERM_OPT	Alpha 1	— `1` Birthdate of Maximum Age `2` Last Day of Month of Max Age	BN17.3
`CVR-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN17.3
`CVR-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN17.3
`CVR-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN17.3
`CVR-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN17.3
`CVR-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN17.3
`CVR-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN17.3

Indexes (4)

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

Index	Keys	Flags	Used in
`CVRSET1`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `COVER-TYPE`, `START-DATE`, `GROUP-NAME`	Primary	BN02.5, BN100, BN101, BN102, BN103, BN105, BN145, BN15.1 +22 more (list truncated in source)
`CVRSET2`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `COVER-TYPE`, `START-DATE*`, `GROUP-NAME`		BN100, BN101, BN102, BN103, BN105, BN145, BN17.3, BN215 +22 more (list truncated in source)
`CVRSET3`	`COMPANY`, `COVER-TYPE`, `RATE-TABLE`, `START-DATE`, `PLAN-TYPE`, `PLAN-CODE`, `GROUP-NAME`	KeyChange	BN02.1, BN02.2, BN02.3, BN02.4, BN02.5
`CVRSET4`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `COVER-TYPE`, `GROUP-NAME`, `START-DATE*`		BN100, BN101, BN102, BN103, BN105, BN17.3, BN31.1, BN31.2 +11 more

Relations

One to one (9) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cov Limit Plan	PLAN	Not Required		`CVR-COMPANY` → `PLN-COMPANY`, `CVR-BN-PLAN-TYPE` → `PLN-PLAN-TYPE`, `CVR-BN-PLAN-CODE` → `PLN-PLAN-CODE`
Coverage 0	PLAN	Required	When PLN-COVERAGE-TYPE = "0"	`CVR-COMPANY` → `PLN-COMPANY`, `CVR-PLAN-TYPE` → `PLN-PLAN-TYPE`, `CVR-PLAN-CODE` → `PLN-PLAN-CODE`
Coverage 1	PLAN	Required	When PLN-COVERAGE-TYPE = "1"	`CVR-COMPANY` → `PLN-COMPANY`, `CVR-PLAN-TYPE` → `PLN-PLAN-TYPE`, `CVR-PLAN-CODE` → `PLN-PLAN-CODE`
Coverage 2	PLAN	Required	When PLN-COVERAGE-TYPE = "2"	`CVR-COMPANY` → `PLN-COMPANY`, `CVR-PLAN-TYPE` → `PLN-PLAN-TYPE`, `CVR-PLAN-CODE` → `PLN-PLAN-CODE`
Coverage User	PLAN	Required	When PLN-COVERAGE-TYPE = "X"	`CVR-COMPANY` → `PLN-COMPANY`, `CVR-PLAN-TYPE` → `PLN-PLAN-TYPE`, `CVR-PLAN-CODE` → `PLN-PLAN-CODE`
Persgroup	PERSGROUP	Not Required		`CVR-COMPANY` → `PRG-COMPANY`, `CVR-GROUP-NAME` → `PRG-GROUP-NAME`
Plan	PLAN	Required		`CVR-COMPANY` → `PLN-COMPANY`, `CVR-PLAN-TYPE` → `PLN-PLAN-TYPE`, `CVR-PLAN-CODE` → `PLN-PLAN-CODE`
Prsystem	PRSYSTEM	Required		`CVR-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Ratetblhdr	RATETBLHDR	Required		`CVR-COMPANY` → `RTH-COMPANY`, `CVR-RATE-TABLE` → `RTH-TABLE-CODE`, `CVR-START-DATE` → `RTH-START-DATE`

Programs

Updated by (45)

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
BN17.3 Coverage Amounts
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 (15)

BN150 Life Insurance Reportable Income
BN215 Plan Parameter Listing
BN220 Benefit Plan Status Report
BN242 One Page Benefits Statement
BN53.1 Benefit Transactions
BN532 Batch Dependent Benefit Enrollment
HR13.1 Dependent
HR13.2 Dependent Benefits
HR13.3 Dependent Benefits
HR13.4 Dependent Benefits
HR513 Dependent Conversion
HR55.1 Employee Group Definition
PA218 Travel Listing
PRBN.1 Payroll Cycle Benefit Edit
ZB599 Update Enrollment Data Structu