Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

BN101


BN101 - Mass Benefit Add

Run BN101 (Mass Benefit Add) to list the employees who are eligible for
plans. When run to Update, BN101 adds eligible employees into default plans.
Run BN101 at any time to enroll many employees into plans.

BN101 enrolls employees into default plans with the applicable default
coverage, default contribution, and default contribution tax type defined for
each plan. BN101 can add the default investment account for employees who are
automatically enrolled in defined contribution plans. If an employee has
dependents, you can run BN101 to create dependent benefit coverage for default
plans that cover dependents.

For a default plan with a service requirement measured in hours, BN101 reads
each employee's pay history to determine when the employee has met the service
requirement. BN101 enrolls employees who have met the service requirement.

For each benefit added for an employee, the report lists the following
applicable items: start date, coverage option, multiple of salary, coverage
amount, the annual employee contribution, whether the contribution is a
percent or an amount, the employee's pre-tax and after-tax contribution, and
the company contribution.

Updated Files

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


    BNCOMMENTS - Comments are deleted from the Benefit Comments file when an
                 employee benefit is deleted.

    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
                 information.

    EMPFLEXREM - The Employee Flex Period Dollars file is updated with flex
                 plans.

    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 deleted.

    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.

    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.


Referenced Files

    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
                 account information.

    BNANNENR   -

    BNCOMPANY  - The Benefit Company Parameters file validates the company.

    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
                 coverage option.

    BNFAMSTS   -

    BNINVEST   - The Investment Distribution file is accessed to determine if
                 employee investments exist.

    BNNEWHIRE  -

    BNPLNENR   -

    BNPOSTCODE - The Benefits Postal Code file is updated with postal codes for
                 the company.

    BNPRMOPT   - The Benefit Premium Options file is accessed to validate
                 contributions.

    BNWAIT     - The Benefit Plan Waiting Period file contains waiting period
                 data.

    CODA       - The Cash Or Deferred Account History file contains employee
                 account balances for defined contribution and defined benefit
                 plans.

    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
                 frequency table.

    DEPTCODE   - The Department file is accessed to retrieve the department
                 name.

    EMDEPEND   - The Employee Dependent file is accessed to verify dependent
                 information.

    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 flex dollar records.

    FLEXPLAN   - The Flex Plan file is accessed to verify that flex plans exist.

    GLINTCO    -

    GLSYSTEM   -

    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.

    PADICT     -

    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.

    PAYMASTR   -

    PERSGROUP  - The Employee Group Header file is accessed to verify that the
                 group exists.

    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
                 group.

    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
                 plan exists.

    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 accessed to
                 retrieve the salary if there is a pay step.

    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.

    PRTAXLOC   -

    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
                 rate.

    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
                 exists.


INVOKED Programs

    HRFN
    HRHI
    HRLO
    IFAC
    ACAC
    ACCL
    IFCU
    IFSG
    IFAU
    SLSE
    SLSU
    IFOB