Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BN531


BN531 - Batch Benefit Enrollment

**Form Purpose
Run Batch Benefit Enrollment (BN531) to import benefits from CSV (Comma
Separated Value) files.

**Processing Effect
BN531 adds benefits the same way benefits are added in BN31.1 (Speed Benefit
Entry). Before you run BN531, make sure all plans have been defined for the
benefits you are loading.

**Troubleshooting
When you run BN531, the application creates an error file called BNBATCHERR.
The BNBATCHERR file contains columns for two specific types of errors:
DftPreCont and AftTaxToSpend.

DftPreCont: The negative values in this column reflect the portion of the
contribution that must be made after tax.

AftTaxToSpend: The value in this column reflects the total contribution cost.

To make corrections, fix the errors indicated in the DftPreCont and
AftTaxToSpend columns. Then delete the columns before you run the BNBATCHERR
file.

**More Information
BN531 creates a report showing which benefits were loaded, the cost of each
benefit, and an error report of benefits not loaded.

For detailed information on loading benefits, see the Human Resources
Conversion Technical Guide.




Updated Files

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


    BNCOMMENTS - The Benefit Comments file is updated with comments.

    BNTRANS    -

    CKPOINT    - The Check Point file is used to allow recovery.

    EMDEDMASTR - The Employee Deduction file is updated.

    EMPFLEXDOL - The Employee Flex Dollars file is updated.

    EMPFLEXREM - The Employee Flex Period Dollars file is updated.

    EMPINVEST  - Employee Benefit Investment Distribution file is updated.

    EMPLOYEE   - The Employee file is updated with the last deduction sequence
                 number. The file also verifies that the employee exists.

    HRDEPBEN   - The Dependent Benefits file is updated.

    HRHISTORY  - The Garnishment Parameters file is accessed to verify that
                 garnishment information exists if the deduction is a
                 garnishment, and verify tax levy information.

    PRREGPARM  -

    STANDTIME  - The Payroll Standard Time Record is updated.


Referenced Files

    BENEFICRY  - The Beneficiary file is used to verify beneficiaries.

    BNACCOUNTS - The Benefit Accounts file validates general ledger override
                 account information.

    BNANNENR   -

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

    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   -

    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 used to verify
                 contribution schedule detail.

    DEDCODE    - The Deduction file is used to verify benefit deductions.

    DEDFREQTBL - The Frequency Table file is used to verify deduction cycles
                 for deductions created.

    EMDEPEND   - The Employee Dependent file is used to access employee
                 dependent files.

    EMTAMASTR  - The Employee Time Accrual Master file is accessed by this
                 program.

    FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records.

    FLEXPLAN   - The Flex Benefit Plan file is used to verify flex plans.

    GLCODES    -

    GLINTCO    -

    GLSYSTEM   -

    HRHISTORY  - The Garnishment Parameters file is accessed to verify that
                 garnishment information exists if the deduction is a
                 garnishment, and verify tax levy information.

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

    JOBCODE    - The Job Code Parameters file is used to verify job code annual
                 hours.

    NAVIGATE   - The Benefit Entry Navigation file contains navigation records.

    OCCURTYPE  -

    ONETMDED   - The Payroll One-time Deduction file is accessed by this
                 program.

    PADICT     -

    PAEMPLOYEE - The Employee PA Information file is used to verify employees.

    PARTBEN    - The COBRA Participant Benefit file is accessed to retrieve the
                 coverage option and benefit coverage information for COBRA
                 participants and retirees.

    PARTICIPNT -

    PASCRTY    - The Data Item Attribute Parameters file is used to determine
                 whether a field should be logged in the logfile.

    PAYDEDUCTN - The Employee Payment Deductions file is accessed to ensure
                 benefits are not deleted if payments exist.

    PAYMASTR   -

    PCODES     -

    PGEMPLOYEE - The Employee Group Employees file is used to verify employees
                 in an employee group.

    PGSELECT   - The Employee Group Selection Criteria file is accessed to
                 retrieve the selection criteria for the employee group.

    PLAN       - The Benefit Plan file is used to verify health plans.

    PREMDEDHST - The Employee Deduction History file is accessed by this
                 program.

    PREMIUM    - The Benefit Plan Premium file is used to verify premium
                 amounts.

    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.

    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 used when payroll
                 run flags are updated for mid-year or mid-cycle flex changes.

    PRTAXAUTH  -

    PRTAXLEVY  - The Payroll Tax Levy file is accessed by this program.

    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 by this program.

    RATETBLHDR - The Rate Table Header file is used to verify rate table codes.

    RESTRANS   - The Spending Account Transactions file is accessed by this
                 program.

    SPHIST     - The Stock Purchase Plan History file is accessed to retrieve
                 the total cost of the stock an employee has.

    TAEEMASTER -


INVOKED Programs

    HRHI
    HRLO
    IFAC
    ACAC
    ACCL
    ACTA
    API4
    IFCU
    IFOB
    IFSG
    IFLU
    IFAU
    SLSE
    SLSU