BNCOVOPT

Benefit Coverage Options

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.

REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN106
BN230 BN231 BN233 BN242 BN245 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN321 BN331
BN51.1 BN51.2 BN53.1 BN531 BN532 BN65.1
BN71.1 BN72.1 BN77.1 BS10.1 BS13.1 BS14.1
BS15.1 BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1
ZB32.2 ZB32.3 HR13.1 HR13.2 HR13.3 HR13.4
HR170 HR513 HR70.1 ZH230 PA218 BN19.1
BN19.2 HCVO.1


UPDATED BY
BN15.1 BN17.1 BN17.2 BN215 BN232 BN320
BS04.1 ZB599

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COP-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
BN17.1 BS04.1
COP-PLAN-TYPE
Element: 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
Element: Plan Code
Alpha 4
Contains the user-defined code that represents a benefit plan.
BN17.1 BS04.1
COP-COVERAGE-OPT
Element: Coverage Opt
Numeric 2
Contains the coverage option used when benefits are entered.
BN17.1 BS04.1
COP-COV-DESC
Element: Description
Alpha 30 (Lower Case)
Contains a user-defined description of the coverage option.
BN17.1
COP-STUDENT-AGE
Element: 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
Element: Dep Age
Numeric 2
If a coverage option provides coverage for dependents, this field contains the dependent's age.
BN17.1
COP-COV-DEPENDENTS
Element: 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
BN17.1
COP-ACTIVE-FLAG
Element: Active Flag
Alpha 1
Contains the Active flag of the coverage option.
A = Active
I = Inactive
BN17.1
COP-NBR-DEPENDENTS
Element: Nbr Dependents
Numeric 2
BN17.1 BS04.1
COP-PT-STUDENTS
Element: Pt Students
Alpha 1

N = No
Y = Yes
BN17.1
COP-MAX-AGE-FLAG
Element: Max Age Flag
Alpha 1
COP-TERM-OPT
Element: Term Opt
Alpha 1

1 = Birthdate of Maximum Age
2 = Last Day of Month of Max Age
BN17.1


BNCOVOPT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COPSET1 COMPANY
PLAN-TYPE
PLAN-CODE
COVERAGE-OPT
...
BN100 BN101
BN102 BN103
BN105 BN106
BN15.1 BN17.1
BN17.2 BN19.1
BN19.2 BN215
BN230 BN231
BN232 BN233
BN242 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN321 BN331
BN51.1 BN51.2
BN53.1 BN531


BNCOVOPT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:09:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.