|
|
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 BN106
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 BN532 BN65.1 BN71.1
BN72.1 BN77.1 BS10.1 BS13.1 BS14.1 BS15.1
BS32.1 HCVO.1 HR13.1 HR13.2 HR13.3 HR13.4
HR170 HR513 HR70.1 PA218
UPDATED BY
BN15.1 BN17.1 BS04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COP-COMPANY Numeric 4 BN17.1 BS04.1
Element: Company Hr Contains the company number.
COP-PLAN-TYPE Alpha 2 BN17.1 BS04.1
Element: Plan 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
Element: Plan Code Contains the user-defined code that
represents a benefit plan.
COP-COVERAGE-OPT Numeric 2 BN17.1 BS04.1
Element: Coverage Opt Contains the coverage option used when
benefits are entered.
COP-COV-DESC Alpha 30 (Lower Case) BN17.1
Element: Description Contains a user-defined description of
the coverage option.
COP-STUDENT-AGE Numeric 2 BN17.1
Element: 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
Element: Dep Age If a coverage option provides coverage
for dependents, this field contains the
dependent's age.
COP-COV-DEPENDENTS Alpha 1 BN17.1
Element: Cov DependentsIndicates 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
COP-ACTIVE-FLAG Alpha 1 BN17.1
Element: Active Flag Contains the Active flag of the
coverage option.
A = Active
I = Inactive
COP-NBR-DEPENDENTS Numeric 2 BN17.1 BS04.1
Element: Nbr Dependents
COP-PT-STUDENTS Alpha 1 BN17.1
Element: Pt Students N = No
Y = Yes
COP-MAX-AGE-FLAG Alpha 1
Element: Max Age Flag
COP-TERM-OPT Alpha 1 BN17.1
Element: Term Opt 1 = Birthdate of Maximum Age
2 = Last Day of Month of Max Age
BNCOVOPT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COPSET1 COMPANY BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN106
COVERAGE-OPT 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 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
|
