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
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 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 ZB599 HCVO.1 HR13.1 HR13.2 HR13.3
HR13.4 HR170 HR513 HR70.1 ZH230 PA218


UPDATED BY
BN15.1 BN17.1 BS04.1

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
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
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
Maximum number of dependents allowed in the plan.
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
COP-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN17.1 BS04.1
COP-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
BN17.1 BS04.1
COP-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN17.1 BS04.1
COP-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN17.1 BS04.1
COP-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
BN17.1 BS04.1
COP-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN17.1 BS04.1
COP-MIN-NBR-DEP
Element: Nbr Dependents		Numeric 2
Minimum number of dependents allowed for the plan.
BN17.1 BS04.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 02:09:58 2016

Home
Contact Us



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