BN100 - Employee Change Benefit Update
Run Employee Change Benefit Update (BN100) to automatically add, change, and
terminate employee benefits based on changes made by personnel actions. Run
BN100 after implementing actions using PA52.1 (Individual Action) or PA100
(Action Update) before you run the payroll cycle in which the benefit changes
BN100 determines which benefits are updated using the benefit change audit
records from BN35.1 (Benefit Change Audit). Benefit change audit records are
changes made by personnel actions that affect an employee's benefits. BN100
does not process changes that are on hold in BN35.1. A change is on hold if
the Hold field is Yes in BN35.1.
The following is a list of changes that can affect an employee's benefit.
- Adding or removing the employee from an employee group used for benefits.
- Changing the employee's benefit postal code.
- Changing the employee's salary. Changes to all of the following data items
are considered a change to the employee's salary: job code, FTE (Full-Time
Equivalent), rate of pay, step, grade, schedule, salary class, or benefit
salaries 1 through 5.
- Changing the employee's pay frequency.
Some employee changes that appear in BN35.1 are listed as affecting an
employee's eligibility but do not trigger BN100 to update an employee's
benefits. Those changes include changes to an employee's birthdate, age, years
of service or smoker status. In addition, BN100 does not update a benefit if
the salary used for the benefit's coverage calculations is overridden on
benefit entry forms.
BN100 updates benefits in the following sequence:
1. Stop benefits for which an employee is no longer eligible.
2. Change benefits in which an employee is enrolled but now qualifies for
different coverage, contributions, or general ledger overrides. To change a
benefit, BN100 stops and re-adds the benefit.
3. Add the employee into plans for which the employee has become eligible.
BN100 enrolls employees into default plans with the applicable default
coverage, default contribution, and default contribution tax type defined for
each plan. For defined contribution plans with a default investment account,
you can run BN100 to enroll employees with the default investment account. If
an employee has dependents, you can run BN101 to create dependent benefit
coverage for default plans that cover dependents.
Benefit automation rules are used to determine when a personnel action
affects employee benefits. Benefit automation rules are defined in BN16.2 (Add
Rules), BN16.3 (Change Rules), and BN16.4 (Termination Rules). If no
automation rules exist for a personnel action that affects benefits, BN100
lists the affected benefits but does not update the benefits.
BN100 can create a COBRA record for an employee affected by a termination
rule defined as a qualifying COBRA event. A termination rule is a qualifying
COBRA event if the COBRA Occurrence field is Yes for the rule in BN16.4. BN100
will create a COBRA record in BN70.1 (COBRA Participant) if the employee does
not have a COBRA record in effect on the date the employee's benefit is
terminated. The employee's Occurrence Date is the day after the employee's
benefit is terminated.
If a change makes an employee ineligible for a flex plan, BN100 stops the
employee's flex dollar record and all benefits under the flex plan according
to the flex plan's termination rules.
You can see the results of running BN100 without updating employee benefits
by selecting Report Only in the Update field and running BN100.
For each benefit updated for an employee, the report lists the following
applicable items: the update performed, start date, coverage option, multiple
of salary, coverage amount, the annual employee contribution, whether the
contribution is a percent or an amount, employee and company contributions,
and deductions for the contributions.
BENEFIT - The Employee Benefit file contains employee benefit records
for all benefit types.
BNCHANGE - The Benefit Changes file is updated with postal code, salary,
pay frequency, birthdate, service date, and smoker flag
BNCOMMENTS - Comments are deleted from the Benefit Comments file when an
employee benefit is deleted.
BNCOMPANY - The Benefit Company Parameters file validates the company.
BNGRPCHG - The Benefit Group Change file is updated when a group is added
CKPOINT - The Check Point file is used to allow recovery.
EMDEDMASTR - The Employee Deduction Master file is updated when benefits
are added, changed, or deleted.
EMPFLEXDOL - The Employee Flex Plan file is updated with flex plan
EMPFLEXREM - The Employee Flex Period Dollars file is updated with flex
EMPINVEST - The Employee Benefit Investment Distribution is updated with
the stop date when a benefit is stopped on a defined
contribution plan. The file is also updated when benefits are
EMPLOYEE - The Employee file is updated with the last deduction sequence
when a benefit is added. The file also verifies the employee.
HRDEPBEN - The Dependent Benefits file is accessed by this program.
HRHISTORY - The HR History file is accessed to retrieve annual salary for
"as of" dates.
PARTICIPNT - The Participant file is updated with COBRA participant
STANDTIME - The Payroll Standard Time Record file is updated for defined
contribution plans when employee benefits are deleted or when
contributions are changed or added.
BENEFICRY - The Beneficiary file is accessed to ensure disability,
employee life, defined contribution, and defined benefit plans
are not deleted if beneficiaries exist.
BNACCOUNTS - The Benefit Accounts file validates general ledger override
BNCOVDFT - The Benefit Coverage Defaults file verifies whether a coverage
option is needed and that coverage defaults exist.
BNCOVERAGE - The Benefit Coverage file verifies that coverage exists for an
employee and date.
BNCOVOPT - The Benefit Coverage Options file is accessed to validate the
BNINVEST - The Investment Distribution file is accessed to determine if
employee investments exist.
BNPOSTCODE - The Benefits Postal Code file is updated with postal codes for
BNPRMOPT - The Benefit Premium Options file is accessed to validate
BNWAIT - The Benefit Plan Waiting Period file contains waiting period
CODA - The Cash Or Deferred Account History file contains employee
account balances for defined contribution and defined benefit
COMPHIST - The Employee Compensation History file contains employee
compensation history data.
CONTRDETL - The Contribution Schedule Detail file is accessed verify
company match information and to retrieve contribution limits
and company match information.
DEDCODE - The Deduction Code file is accessed to verify deductions.
DEDFREQTBL - The Frequency Table is accessed to verify the deduction
DEPTCODE - The Department file is accessed to retrieve the department
EMDEPEND - The Employee Dependent file is accessed to verify dependent
EMTAMASTR - The Employee Time Accrual Master file is accessed to verify
vacation maximum hours and costs.
FLEXDOLLAR - The Flex Dollars file is used to verify that flex dollar
FLEXPLAN - The Flex Plan file is accessed to verify that flex plans exist.
HRHISTORY - The HR History file is accessed to retrieve annual salary for
"as of" dates.
HRSECLEV - The Employee Security Level file is accessed to verify the
user security for updates.
JOBCODE - The Job Code Parameters file is accessed to retrieve the job's
annual hours for computing the salary.
NAVIGATE - The Benefit Process Order file is accessed to display plan
types in the user-defined order.
ONETMDED - The Payroll One-Time Deduction file is accessed to ensure
benefits are not deleted if a one-time deduction exists.
PAEMPLOYEE - The Employee Personnel Information file is accessed verify
that the employee exists.
PARTBEN - The COBRA Participant Benefit file is accessed to retrieve the
coverage option and benefit coverage information for COBRA
participants and retirees.
PASCRTY - The Data Item Attribute Parameters file is accessed to
determine if a change should be logged.
PAYDEDUCTN - The Employee Payment Deductions file is accessed to ensure
benefits are not deleted if payments exist.
PERSACTHST - The Personnel Action History file is accessed to accessed to
retrieve the personnel action code that finds benefit waiting
period rules for adds and changes.
PERSGROUP - The Employee Group Header file is accessed to verify that the
PGEMPLOYEE - The Employee Group Employees file is accessed to retrieve all
the employees in a group and to verify if an employee is in the
PGSELECT - The Employee Group Selection Criteria file is accessed to
retrieve the selection criteria for the employee group.
PLAN - The Benefits Plan file is used to verify that a plan exists.
PREMDEDHST - The Employee Deduction History file is accessed to ensure a
benefit is not deleted if a deduction was taken.
PREMIUM - The Benefit Plan Premium file is accessed to compare the plan
contribution type with the premium contribution type to be sure
it is the same. The file also verifies that the premium exists.
PROTPAYPRD - The Overtime Pay Periods file is accessed to retrieve the pay
period start and end dates for entry verification.
PROTWRKPRD - The Overtime Work Periods file is accessed to retrieve the
work period start and stop dates for entry verification.
PROVERTIME - The Overtime Pay Plan file is accessed to verify that the pay
PRPROCGRP - The Payroll Process Group file is accessed to verify that the
processing group exists.
PRRATEHIST - The Employee Rate History file is accessed to retrieve the
salary for the "as of" date.
PRSAGDTL - The Step and Grade Schedule Detail file is used to retrieve
the employee salary using step and grade.
PRSAGHEAD - The Step and Pay Schedule Header file is accessed to retrieve
the salary for an employee with a pay step.
PRSYSTEM - The HR Company and Process Levels file is accessed to verify
that the company exists.
PRTAXLEVY - The Payroll Tax Levy file is accessed to verify the IRS levy
table for the effective year.
PRTIME - The Employee Pay/Hours History file is accessed to calculate
the waiting period.
PSGRELATE - The Pay Class/Pay Summary Group Relation file is accessed to
determine if hours should be added or subtracted.
RATETBLDTL - The Rate Table Detail file is accessed to retrieve the current
RATETBLHDR - The Rate Table Header file is used to verify rate table codes.
RESTRANS - The Spending Account Transactions file is accessed to ensure
benefits are not deleted if a spending account plan still