|
|
BNCOVERAGE FILE
Benefit Coverage
The Benefit Coverage file contains coverage parameters for benefit plans with
a coverage type of Coverage Amount.
REFERENCED BY
BN100 BN101 BN102 BN103 BN145 BN150
BN220 BN232 BN242 BN245 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN320 BN331 BN45.1
BN53.1 BN531 BN532 BN65.1 BN71.1 BN72.1
BS09.1 BS10.1 BS11.1 BS12.1 BS13.1 BS14.1
BS15.1 BS32.1 HR13.2 HR13.3 HR13.4 HR55.1
PRBN.1 BN215
UPDATED BY
BN02.1 BN02.2 BN02.3 BN02.4 BN02.5 BN105
BN15.1 BN17.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVR-COMPANY Numeric 4 BN17.3
Element: Company Hr Contains the company number.
CVR-PLAN-TYPE Alpha 2 BN17.3
Element: Type Contains the 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
CVR-PLAN-CODE Alpha 4 BN17.3
Element: Plan Contains the user-defined code that
represents a benefit plan.
CVR-GROUP-NAME Alpha 10 BN17.3
Element: Group Name Contains the employee group for which
the coverage record applies.
If the group is blank, the system will
use this coverage record for all
employees who do not qualify for
coverage for a specific group.
CVR-START-DATE Numeric 8 (yyyymmdd) BN17.3
Element: Start Date Contains the date the coverage
parameters begin.
CVR-CALC-TYPE Alpha 1 BN17.3
Element: Calculation TyDefines how the coverage amount will be
determined for the plan.
F = Flat Amount
M = Multiple Salary
P = Percent
S = Supplemental
X = Custom Calculation
CVR-LIFE-ADD-FLG Alpha 1 BN17.3
Element: Covered IndiviContains a value that determines who is
covered under the plan.
Employee is not a valid value for
Dependent Life plans. Spouse, Dependent,
and Both Spouse and Dependent are not
valid values for Employee Life plans.
E = Employee
S = Spouse
D = Dependent
B = Both Spouse and Dependent
CVR-STUDENT-AGE Numeric 2 BN17.3
Element: Student Age Contains the age coverage terminates
for dependents who are flagged as
students. If the dependent is a student,
this age overrides the dependent age.
CVR-DEP-AGE Numeric 2 BN17.3
Element: Dependent Age If the plan covers dependents or
spouses and dependents, this field
contains the age dependent coverage
terminates for dependents if the
dependent is not flagged as a student.
CVR-FLAT-AMT-1 Signed 11.2 BN17.3 BN320
Element: Flat Amt 1 For a plan with a calculation type of
flat amount, this is the flat amount of
coverage. If a plan covers both spouses
and dependents, this is the spouse
coverage amount.
CVR-FLAT-AMT-2 Signed 11.2 BN17.3 BN320
Element: Flat Amt 2 If the calculation type is flat amount
and the plan covers both spouses and
dependents, this is the dependent
coverage amount.
CVR-INCREMENTS Signed 11.4 BN17.3
Element: Increments If the coverage calculation type is
supplemental, this field defines the
increments of coverage an employee may
elect. Coverage under this plan will be
a multiple of this amount.
CVR-MULT-SALARY Signed 6.3 BN17.3
Element: Multiple of SaIf the coverage calculation type is a
multiple of salary, this field defines
the valid multiples the employee may
elect. Coverage under this plan will be
a multiple of this increment.
CVR-SALARY-PCT Signed 5.2 BN17.3
Element: Percent of SalIf the coverage calculation type is a
percent, this the percent of the
employee's salary which will be used to
calculate coverage.
CVR-SALARY-TYPE Alpha 2 BN17.3
Element: Salary Type If the coverage calculation type is a
percent of salary, a multiple of salary,
or if the coverage limit is a multiple
of salary, this field defines which
field is used to define the salary to be
used in calculations.
EM = HR11 Salary
B1 = Benefit Salary 1
B2 = Benefit Salary 2
B3 = Benefit Salary 3
B4 = Benefit Salary 4
B5 = Benefit Salary 5
E1 = HR11 and Ben Sal 1
E2 = HR11 and Ben Sal 2
E3 = HR11 and Ben Sal 3
E4 = HR11 and Ben Sal 4
E5 = HR11 and Ben Sal 5
ET = Total Emp Salary
T1 = Total Emp and Sal 1
T2 = Total Emp and Sal 2
T3 = Total Emp and Sal 3
T4 = Total Emp and Sal 4
T5 = Total Emp and Sal 5
X = Custom Calculation
CVR-SALARY-DATE Numeric 4 (mmdd) BN17.3
Element: Salary Date If the coverage is based on the
employee's salary, and the salary is
determined on a specific month and day,
this field contains the date the salary
is determined.
CVR-SAL-FIRST-MO Alpha 1 BN17.3
Element: Sal First Mo If coverage is based on salary, and the
salary should be the salary in effect on
the first of the month for which a
benefit is created, the salary will be
flagged as first of month.
The As Of date is defined in the Salary
Date and Salary Year fields. The Flex
Calc date is the same as the date on
which flex dollars are calculated.
C = Current
M = First of Month
A = As Of Date
F = Flex Calc Date
CVR-ROUND-METH Alpha 1 BN17.3
Element: Rounding MethoIf coverage is based on salary, this
field defines how the salary amount
should be rounded.
H = High
L = Low
N = No Rounding
R = Normal Rounding
CVR-BEF-AFT-FLAG Alpha 1 BN17.3
Element: Before/After If the coverage amount is based on
salary this field defines whether the
salary amount should be rounded before
the coverage amount is calculated, or if
the coverage amount should be rounded
after the calculation is done.
B = Before
A = After
CVR-ROUND-TO Signed 9.4 BN17.3
Element: Round To If the salary amount is rounded, this
defines to what place the amount is
rounded.
CVR-MIN-COVER Signed 11.2 BN17.3
Element: Min Cover If a plan has a minimum coverage
amount, the minimum is contained in this
field. If the plan is a multiple of
salary or a percent, and the calculated
coverage amount is less than the
minimum, the minimum will be used. If
the plan is a supplemental plan and the
elected amount is less than the minimum,
the system will generate an error.
CVR-MAX-COVER Signed 11.2 BN17.3
Element: Maximum If the plan has a maximum coverage
amount, the maximum is specified in this
field. If the plan is a multiple of
salary or a percent, and the calculated
amount is greater than the maximum, the
maximum amount will be used. If the
plan is a supplemental plan, and the
employee elects more than the maximum,
the system will generate an error.
CVR-MIN-MULTIPLE Signed 5.2 BN17.3 BS14.1
Element: Min Multiple If the plan is a multiple of salary, or
if the plan has a minimum which is
specified a multiple of salary, this is
the minimum multiple.
CVR-MAX-MULTIPLE Signed 5.2 BN17.3
Element: Max Multiple If the plan is a multiple of salary or
if there is a limit defined as a
multiple of salary, this field defines
the maximum multiple.
CVR-RATE-TABLE Alpha 4 BN17.3
Element: Rate Table If the plan specifies a reduction of
coverage at specific ages, this is the
rate table used to define the coverage
reduction parameters.
The table is defined in the Rate Table
Header file which uses the Coverage
Start Date and the Rate Table fields to
connect the records.
CVR-AGE-DATE Numeric 4 (mmdd) BN17.3
Element: Age Date If the plan has a coverage reduction
table based on age, and the age is
determined on a specific date, the
employee or spouse's age on this date is
calculated.
CVR-AGE-FIRST-MO Alpha 1 BN17.3
Element: Age First Mo If the plan has a coverage reduction at
specific ages, and the employee or
spouse's age should be calculated for
the first of each month, first of month
will be yes.
C = Current
M = First of Month
A = As of Date
F = Flex Calc Date
CVR-COV-ROUND-METH Alpha 1 BN17.3
Element: Cov Round MethIf the coverage amount is to be
rounded, this defines coverage amount
should be rounded.
H = High
L = Low
N = No Rounding
R = Normal Rounding
CVR-COV-ROUND-TO Signed 9.4 BN17.3
Element: Cov Round To If the coverage amounts are to be
rounded, this defines to what place the
amount is rounded.
CVR-DEFAULT-COVER Alpha 1 BN17.3
Element: Default Cover Indicates whether this is default
coverage. If this is default coverage,
the coverage will default on all benefit
entry forms and all updates when a
benefit is automatically added.
Y = Yes
N = No
CVR-DEFAULT-AMT Signed 11.2 BN17.3
Element: Default Amt Contains the default coverage for
employees who do not elect a coverage
amount. This is used for supplemental
plans only.
CVR-DEFAULT-MULT Signed 5.2 BN17.3
Element: Default Mult If the default coverage flag is Yes,
and if the plan coverage is a multiple
of the salary, this field contains the
salary multiple.
CVR-COVERAGE-CHG Numeric 1 BN02.5
Element: Coverage Chg Indicates that the coverage is changed.
If the coverage is Non Updated, BN105
(Plan Update) must be run before PR140
(Earnings and Deductions Calculation) is
run.
0 = Non Updated
1 = Updated
CVR-SALARY-YEAR Numeric 4 BN17.3
Element: Salary Year Contains the year if salary
calculations are based on a specific
year.
CVR-AGE-YEAR Numeric 4 BN17.3
Element: Age Year Contains the year if age calculations
are based on an age.
CVR-BENEFIT-PCT Signed 5.2 BN17.3 BN65.1
Element: Benefit Pct If coverage is limited to a percent of
coverage under another benefit, this is
the percent limit.
CVR-BN-PLAN-TYPE Alpha 2 BN17.3
Element: Bn Plan Type If coverage is limited to a percent of
coverage under another benefit, this
field contains the plan upon which
coverage limits are placed.
DB = Defined Benefit
DC = Defined Contribution
DI = Disability
DL = Dependent Life
DN = Dental
EL = Employee Life
HL = Health
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
VA = Vacation
CVR-BN-PLAN-CODE Alpha 4 BN17.3
Element: Bn Plan Code If coverage is limited to a percent of
coverage under another benefit, this
field contains the plan code upon which
coverage limits are placed.
CVR-COVER-TYPE Alpha 1 BN17.3
Element: Cover Type Indicates the coverage is for
employees, retirees, or COBRA
participants for each premium record.
E = Employees
R = Retirees
C = COBRA
CVR-STATUS Numeric 1 BN02.1 BN02.2
Element: Status Contains the coverage status. BN02.3 BN02.4
BN02.5 BN105
When PR180 (Manual Payment Print) is BN17.3
run for a payment date, BN105 must also
be run to update employee coverage
records 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
CVR-RET-STATUS Numeric 1 BN02.1 BN02.2
Retiree Premium Indicates the retiree's coverage status. BN02.3 BN02.4
Status 0 = New Group New Date BN02.5 BN105
1 = Existing Group New Date BN17.3
2 = Change Existing Record
3 = Updated
CVR-COBRA-STATUS Numeric 1 BN02.1 BN02.2
Element: Cobra Status Contains the COBRA participant's status. BN02.3 BN02.4
0 = New Group New Date BN02.5 BN105
1 = Existing Group New Date BN17.3
2 = Change Existing Record
3 = Updated
CVR-COVER-FREQ Alpha 2
Element: Cover Freq This field is not used.
AN = Annual
MO = Monthly
SM = Semi-monthly
BW = Bi-weekly
WK = Weekly
CVR-PT-STUDENTS Alpha 1
Element: Pt Students N = No
Y = Yes
BNCOVERAGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVRSET1 COMPANY BN02.5 BN100
PLAN-TYPE BN101 BN102
PLAN-CODE BN103 BN105
COVER-TYPE BN145 BN15.1
START-DATE BN150 BN17.3
GROUP-NAME BN220 BN232
BN242 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN45.1
BN53.1 BN531
BN532 BN65.1
BN71.1 BN72.1
BS09.1 BS10.1
...
CVRSET2 COMPANY BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN145
COVER-TYPE BN215 BN232
START-DATE* BN245 BN31.1
GROUP-NAME 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
CVRSET3 COMPANY KeyChange BN02.1 BN02.2
COVER-TYPE BN02.3 BN02.4
RATE-TABLE BN02.5
START-DATE
PLAN-TYPE
PLAN-CODE
GROUP-NAME
CVRSET4 COMPANY BN17.3
PLAN-TYPE
PLAN-CODE
COVER-TYPE
GROUP-NAME
START-DATE*
BNCOVERAGE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cov Limit Plan PLAN Not Required
CVR-COMPANY -> PLN-COMPANY
CVR-BN-PLAN-TYPE -> PLN-PLAN-TYPE
CVR-BN-PLAN-CODE -> PLN-PLAN-CODE
Coverage 0 PLAN Required
When PLN-COVERAGE-TYPE = "0 "
CVR-COMPANY -> PLN-COMPANY
CVR-PLAN-TYPE -> PLN-PLAN-TYPE
CVR-PLAN-CODE -> PLN-PLAN-CODE
Coverage 1 PLAN Required
When PLN-COVERAGE-TYPE = "1 "
CVR-COMPANY -> PLN-COMPANY
CVR-PLAN-TYPE -> PLN-PLAN-TYPE
CVR-PLAN-CODE -> PLN-PLAN-CODE
Coverage 2 PLAN Required
When PLN-COVERAGE-TYPE = "2 "
CVR-COMPANY -> PLN-COMPANY
CVR-PLAN-TYPE -> PLN-PLAN-TYPE
CVR-PLAN-CODE -> PLN-PLAN-CODE
Coverage User PLAN Required
When PLN-COVERAGE-TYPE = "X "
CVR-COMPANY -> PLN-COMPANY
CVR-PLAN-TYPE -> PLN-PLAN-TYPE
CVR-PLAN-CODE -> PLN-PLAN-CODE
Persgroup PERSGROUP Not Required
CVR-COMPANY -> PRG-COMPANY
CVR-GROUP-NAME -> PRG-GROUP-NAME
Plan PLAN Required
CVR-COMPANY -> PLN-COMPANY
CVR-PLAN-TYPE -> PLN-PLAN-TYPE
CVR-PLAN-CODE -> PLN-PLAN-CODE
Prsystem PRSYSTEM Required
CVR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Ratetblhdr RATETBLHDR Required
CVR-COMPANY -> RTH-COMPANY
CVR-RATE-TABLE -> RTH-TABLE-CODE
CVR-START-DATE -> RTH-START-DATE
|
