|
|
BNCOVOPT FILE
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 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
BN531 BN532 BN65.1 BN71.1 BN72.1 BN77.1
BS10.1 BS13.1 BS14.1 BS15.1 BS32.1 HCVO.1
HR13.3 HR13.4 HR13.5 HR170 HR70.1
UPDATED BY
BN15.1 BN17.1 BS04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COP-COMPANY Numeric 4 BN17.1 BS04.1
Company Contains the company number.
COP-PLAN-TYPE Alpha 2 BN17.1 BS04.1
Type Indicates 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
COP-PLAN-CODE Alpha 4 BN17.1 BS04.1
Plan Contains the user-defined code that
represents a benefit plan.
COP-COVERAGE-OPT Numeric 2 BN17.1 BS04.1
Coverage Opt Contains the coverage option used when
benefits are entered.
COP-COV-DESC Alpha 15 (Lower Case) BN17.1
Cov Desc Contains a user-defined description of
the coverage option.
COP-STUDENT-AGE Numeric 2 BN17.1
Student Age 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.
COP-DEP-AGE Numeric 2 BN17.1
Dependent Age If a coverage option provides coverage
for dependents, this field contains the
dependent's age.
COP-COV-DEPENDENTS Alpha 1 BN17.1
Cov Dependents Indicates whether the spouse,
dependents, spouse and dependents, or
neither are covered for this coverage
option.
S = Spouse
D = Dependents
B = Both spouse/dependents
N = None
COP-ACTIVE-FLAG Alpha 1 BN17.1
Status Contains the Active flag of the
coverage option.
A = Active
I = Inactive
COP-NBR-DEPENDENTS Numeric 2 BS04.1
Nbr Dependents
BNCOVOPT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COPSET1 COMPANY BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN15.1
COVERAGE-OPT 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 BN531
BN532 BN65.1
...
BNCOVOPT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|