|
|
BN320 - Premium Report
**Form Purpose
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.
**Processing Effect
To calculate monthly premiums, the application divides the premium or
contribution from the employee's benefit record by twelve.
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 -
BNCARRIER -
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 -
CUCODES -
DEPTCODE -
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.
HRUTILITY -
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.
PATHFIND -
PCODES -
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
HRHI
IFCU
IFSG
|
