BN320 - Monthly Premium Report

Run BN320 (Monthly Premium Report) to review monthly billings.

You can create four kinds of reports with BN320: a premium report, an
exception report, a summary report, and a combination of all three. Each
report groups premiums by benefit plan. Employees, COBRA participants, and
retirees list separately. To calculate monthly premiums, the system divides
the premium or contribution from the employee's benefit record by twelve.

The premium report lists premiums for employees, COBRA participants, and
retirees who have coverage in effect during the report period. For each
person, the list shows: name, date of birth, smoker status, benefit start
date, coverage option, monthly employee premium, monthly company premium, and
total monthly premium.

The exception report lists all plan participants who started and stopped a
benefit during the report period. For each person, the list shows: name, date
of birth, smoker status, benefit start date, coverage option or coverage
amount, monthly employee premium, monthly company premium, and total monthly
premium. Lawson recommends that you run the exception report for the previous
period to show all individuals whose benefits were added or stopped since the
last time this report was run.

The summary report lists the total number of employees, COBRA participants,
and retirees enrolled in benefits during the report period. For each plan, the
list shows: number of plan participants covered, the employee premium, the
company premium, and the total premium. If the plan's contributions are based
on a rate table, the report lists the number of people covered in each age,
salary, and years of service range.

Updated Files

    CKPOINT    -


Referenced Files

    BENEFIT    - The Employee Benefit file contains employee benefit records
                 for all benefit types.

                 The Employee Benefit file contains employee benefit records.

    BNACCOUNTS -

    BNANNENR   -

    BNCOMPANY  - The Benefit Company Parameters file is used to verify company
                 information.

    BNCOVDFT   -

    BNCOVERAGE - The Benefit Coverage file is accessed to retrieve coverage
                 amounts.

    BNCOVOPT   - The Benefit Coverage Options file is accessed to retrieve the
                 coverage description.

    BNFAMSTS   -

    BNNEWHIRE  -

    BNPLNENR   -

    BNWAIT     -

    EMDEPEND   - The Employee Dependent file is accessed to count the number of
                 spouses an employee has an ensure that no more than one is
                 entered.

    EMPFLEXDOL - The Employee Flex Dollars file is accessed to retrieve the
                 annual salary and the salary calculation date when the flex
                 salary is used.

    EMPLOYEE   - The Employee file contains employee data.

    FLEXDOLLAR -

    HRHISTORY  - The HR History file is accessed to retrieve the annual salary
                 on an "as of" date.

    HRSECLEV   - The Employee Security Level file is accessed by this report.

    JOBCODE    - The Job Code file is accessed to retrieve a job's annual hours.

    PAEMPLOYEE - The Employee PA Information file contains employee data.

    PARTBEN    - The COBRA Participant Benefit file contains COBRA participant
                 benefit records.

    PARTICIPNT - The COBRA Participant file contains COBRA participant data.

    PERSGROUP  - The Employee Group Header file is used to verify employee
                 groups.

    PGEMPLOYEE - The Employee Group Employees file contains employees in each
                 employee group.

    PGSELECT   -

    PLAN       - The Benefit Plan file is used to verify plan codes.

    PREMIUM    - The Benefit Plan Premium file contains valid premiums.

    PRRATEHIST - The Employee rate History file is accessed to retrieve the
                 salary for the "as of" date.

    PRSAGDTL   -

    PRSAGHEAD  -

    PRSYSTEM   - The HR Company and Process Levels file is used to verify
                 company information.

    RATETBLDTL - The Rate Table Detail file contains rate table detail.

    RATETBLHDR - The Rate Table Header file contains rate table headers.


INVOKED Programs

    HRFN
    HRHI