BNCOVDFT

Benefit Coverage Defaults

The Benefits Coverage Defaults defines which benefit options are currently valid for each employee group.

REFERENCED BY
BN145 BN220 BN232 BN320 BN331 BN340
BN45.1 BS09.1 BS10.1 BS11.1 BS12.1


UPDATED BY
BN105 BN15.1 BN17.1 BN17.2 BN100 BN101
BN102 BN103 BN215 BN245 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN531 BN65.1 BN71.1
BN72.1 BN729 BN991 BS13.1 BS14.1 BS15.1
BS32.1 HR55.1 PRBN.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BCD-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
BN17.1 BN17.2
BCD-PLAN-TYPE
Element: Plan Type
Alpha 2
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
BN17.1 BN17.2
BCD-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the user-defined code that represents the benefit plan.
BN17.1 BN17.2
BCD-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Contains the start date for the coverage options.
BN17.1 BN17.2
BCD-GROUP-NAME
Element: Group Name
Alpha 10
Contains the employee group for which the coverage option applies.
BN17.1 BN17.2
BCD-COVERAGE-OPT
Element: Coverage Opt
Numeric 2
Contains the coverage option used at benefit entry.
BN17.1 BN17.2
BCD-COVERAGE-DFT
Element: Coverage Dft
Alpha 1
Indicates whether this is default coverage.
Y = Yes
N = No
BN17.1 BN17.2
BCD-ACTIVE-FLAG
Element: Active Flag
Alpha 1
Indicates if the coverage option is active for the group.
A = Active
I = Inactive
BN17.1 BN17.2
BCD-COVER-TYPE
Element: Cover Type
Alpha 1
Indicates if the coverage is for employees, retirees, or COBRA participants for each premium record.
E = Employees
R = Retirees
C = COBRA
BN17.1 BN17.2
BCD-STATUS
Element: Status
Numeric 1
Contains the employee status. 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
BN105 BN17.1
BN17.2
BCD-RET-STATUS
Retiree Cov Default
Status
Numeric 1
Contains the retiree 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
BN105 BN17.1
BN17.2
BCD-COBRA-STATUS
COBRA Coverage
Default Status
Numeric 1
Contains the COBRA 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
BN105 BN17.1
BN17.2


BNCOVDFT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BCDSET1 COMPANY
PLAN-TYPE
PLAN-CODE
COVER-TYPE
START-DATE
GROUP-NAME
COVERAGE-OPT
...
BN100 BN101
BN102 BN103
BN105 BN145
BN15.1 BN17.1
BN17.2 BN215
BN220 BN232
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BN729 BN991
BS09.1 BS10.1
BCDSET2 COMPANY
PLAN-TYPE
PLAN-CODE
COVER-TYPE
START-DATE*
GROUP-NAME
COVERAGE-OPT
Subset
Where(ACTIVE-FLAG ="A")
And(COVERAGE-DFT ="Y")
...
BN100 BN101
BN102 BN103
BN105 BN145
BN17.2 BN232
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BN729 BN991
BS09.1 BS10.1
BS11.1 BS12.1
BS13.1 BS14.1
BCDSET3 COMPANY
PLAN-TYPE
PLAN-CODE
COVERAGE-OPT
COVER-TYPE
START-DATE
GROUP-NAME
BN17.1
BCDSET4 COMPANY
PLAN-TYPE
PLAN-CODE
COVER-TYPE
START-DATE*
GROUP-NAME
COVERAGE-OPT
...
BN100 BN101
BN102 BN103
BN105 BN145
BN17.1 BN17.2
BN232 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN340
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BN729
BN991 BS09.1
BS10.1 BS11.1
BS12.1 BS13.1
BCDSET5 COMPANY
PLAN-TYPE
PLAN-CODE
COVER-TYPE
GROUP-NAME
START-DATE*
COVERAGE-OPT
BN17.1 BN17.2


BNCOVDFT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:48:05 2016

Home
Contact Us



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