BN320 - Premium Report
Run Premium Report (BN320) to print a report of 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.
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.
In addition, BN320 lets
To calculate monthly premiums, the application divides the premium or
contribution from the employee's benefit record by twelve.
BENEFIT - The Employee Benefit file contains employee benefit records
for all benefit types.
The Employee Benefit file contains employee benefit records.
BNCOMPANY - The Benefit Company Parameters file is used to verify company
BNCOVERAGE - The Benefit Coverage file is accessed to retrieve coverage
BNCOVOPT - The Benefit Coverage Options file is accessed to retrieve the
EMDEPEND - The Employee Dependent file is accessed to count the number of
spouses an employee has an ensure that no more than one is
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.
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
PARTICIPNT - The COBRA Participant file contains COBRA participant data.
PERSGROUP - The Employee Group Header file is used to verify employee
PGEMPLOYEE - The Employee Group Employees file contains employees in each
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.
PRSYSTEM - The HR Company and Process Levels file is used to verify
RATETBLDTL - The Rate Table Detail file contains rate table detail.
RATETBLHDR - The Rate Table Header file contains rate table headers.