BNCOVDFT FILE
Benefit Coverage Defaults
The Benefits Coverage Defaults defines which benefit options are currently
valid for each employee group.
REFERENCED BY
BN100 BN101 BN102 BN103 BN145 BN215
BN220 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN320 BN331 BN45.1 BN531 BN65.1
BN71.1 BN72.1 BS09.1 BS10.1 BS11.1 BS12.1
BS13.1 BS14.1 BS15.1 BS32.1 HR55.1 PRBN.1
UPDATED BY
BN105 BN15.1 BN17.1 BN17.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BCD-COMPANY Numeric 4 BN17.1 BN17.2
Company Contains the company number.
BCD-PLAN-TYPE Alpha 2 BN17.1 BN17.2
Type Indicates the default 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
BCD-PLAN-CODE Alpha 4 BN17.1 BN17.2
Plan Contains the user-defined code that
represents the benefit plan.
BCD-START-DATE Numeric 8 (yyyymmdd) BN17.1 BN17.2
Start Date Contains the start date for the
coverage options.
BCD-GROUP-NAME Alpha 10 BN17.1 BN17.2
Group Name Contains the employee group for which
the coverage option applies.
BCD-COVERAGE-OPT Numeric 2 BN17.1 BN17.2
Coverage Opt Contains the coverage option used at
benefit entry.
BCD-COVERAGE-DFT Alpha 1 BN17.1 BN17.2
Coverage Dft Indicates whether this is default
coverage.
Y = Yes
N = No
BCD-ACTIVE-FLAG Alpha 1 BN17.1 BN17.2
Status Indicates if the coverage option is
active for the group.
A = Active
I = Inactive
BCD-COVER-TYPE Alpha 1 BN17.1 BN17.2
Cover Type Indicates if the coverage is for
employees, retirees, or COBRA
participants for each premium record.
E = Employees
R = Retirees
C = COBRA
BCD-STATUS Numeric 1 BN105 BN17.1
Status Contains the employee status. BN17.2
If a Benefits Coverage Default record
is added and no employee benefits exists
or if BN105 (Plan Update) is updated,
the status is updated.
When PR140 (Earnings and Deductions
Calculation) is run for a payment date,
BN105 must also be run to update
employee benefits 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
BCD-RET-STATUS Numeric 1 BN105 BN17.1
Retiree Cov Default Contains the retiree status. BN17.2
Status
When PR180 (Manual Payment Print) is
run for a payment date, BN105 must also
be run to update employee benefits 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
BCD-COBRA-STATUS Numeric 1 BN105 BN17.1
COBRA Coverage Contains the COBRA status. BN17.2
Default Status
When PR180 (Manual Payment Print) is
run for a payment date, BN105 must also
be run to update employee benefits 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
BNCOVDFT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BCDSET1 COMPANY BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN145
COVER-TYPE BN15.1 BN17.1
START-DATE BN17.2 BN215
GROUP-NAME BN220 BN245
COVERAGE-OPT BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS09.1 BS10.1
BS11.1 BS12.1
BS13.1 BS14.1
...
BCDSET2 COMPANY Subset BN100 BN101
PLAN-TYPE Where (ACTIVE-FLAG = "A" ) BN102 BN103
PLAN-CODE And (COVERAGE-DFT = "Y" ) BN105 BN145
COVER-TYPE BN17.2 BN245
START-DATE* BN31.1 BN31.2
GROUP-NAME BN32.1 BN32.2
COVERAGE-OPT BN32.3 BN320
BN331 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS09.1 BS10.1
BS11.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
BCDSET3 COMPANY BN17.1
PLAN-TYPE
PLAN-CODE
COVERAGE-OPT
COVER-TYPE
START-DATE
GROUP-NAME
BCDSET4 COMPANY BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN145
COVER-TYPE BN245 BN31.1
START-DATE* BN31.2 BN32.1
GROUP-NAME BN32.2 BN32.3
COVERAGE-OPT BN320 BN331
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS09.1
BS10.1 BS11.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1
BCDSET5 COMPANY BN17.1 BN17.2
PLAN-TYPE
PLAN-CODE
COVER-TYPE
GROUP-NAME
START-DATE*
COVERAGE-OPT
BNCOVDFT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bncovopt BNCOVOPT Required
BCD-COMPANY -> COP-COMPANY
BCD-PLAN-TYPE -> COP-PLAN-TYPE
BCD-PLAN-CODE -> COP-PLAN-CODE
BCD-COVERAGE-OPT -> COP-COVERAGE-OPT
Persgroup PERSGROUP Not Required
BCD-COMPANY -> PRG-COMPANY
BCD-GROUP-NAME -> PRG-GROUP-NAME
Plan PLAN Required
BCD-COMPANY -> PLN-COMPANY
BCD-PLAN-TYPE -> PLN-PLAN-TYPE
BCD-PLAN-CODE -> PLN-PLAN-CODE
Prsystem PRSYSTEM Required
BCD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
|