Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BN145


BN145 - Flex Dollars Calculation

**Form Purpose
Run Flex Dollars Calculation (BN145) to calculate flex dollars for employees
in a flex plan for an entire flex plan year. If a flex plan gives flex dollars
based on benefit election, run BN145 to create flex dollar records so that
each eligible employee becomes a participant in the flex plan.

For each employee, the report lists: annual salary, base dollars, number of
flex dollars given before benefit election, pre-tax dollar limits, and the
total flex and pre-tax dollars. Base dollars are the flex dollars given to
every eligible employee in the flex plan. If the flex dollars calculated for
an employee are greater than the plan's maximum or less than the plan's
minimum, the report shows the increase or decrease in flex dollars based on
those parameters.

**Processing Effect
If the flex plan lets employees keep a percentage of their unspent flex
dollars, when the application creates flex dollars, it creates a standard time
record for each employee in PR30.1 (Standard Time Record). You should enroll
employees in their benefits before the first payroll run of the flex plan year
to offset the standard time record. (For information on how the Benefits
Administration application tracks flex dollars, see the Benefits
Administration User Guide.)

If you change flex dollar parameters in BN08.1 (Flex Credits) and re-run
BN145 to Update, it recalculates flex dollars. You can recalculate flex
dollars using BN145 until you enroll employees in benefits. If you change an
employee's flex dollar record in BN45.1 (Employee Flex Dollars) and re-run
BN145, it does not create a new flex dollar record for the employee for the
flex plan year.

BN145 uses parameters from the Salary Calculation and Age Credits subform in
BN08.1 (Flex Credits) to determine an employee's age and salary. You can
override the salary and recalculate flex dollars in BN45.1.




Updated Files

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

                 The Employee Benefit file is used by common routine.

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

    EMDEDMASTR - The Employee Deduction file is used to update employee
                 deductions.

    EMPFLEXDOL - The Employee Flex Dollar file is used to update flex dollars.

    EMPFLEXREM - The Employee Flex Period Dollars file is accessed by this
                 report.

    EMPLOYEE   - The Employee file is used to update the employee file.

    HRHISTORY  - The HR History file is accessed to retrieve the annual salary
                 on an "as of" date, the FTE number, and the annual number of
                 hours for a job.

    PRREGPARM  -

    STANDTIME  - The Payroll Standard Time Record file is accessed by this
                 report.


Referenced Files

    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 is accessed to verify that
                 the coverage default is set up for the employee and date.

    BNCOVERAGE - The Benefit Coverage file is accessed to verify that coverage
                 is set up for an employee and date.

    BNFAMSTS   -

    BNNEWHIRE  -

    BNPLNENR   -

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

    DEDCODE    - The Deduction file is used to access flex deductions.

    DEDFREQTBL - The Frequency Table file is used to access the frequency table
                 linked to the flex plan.

    DEPTCODE   - The Department file is used to access department records.

    EMDEPEND   - The Employee Dependent file is accessed to retrieve the
                 spouse's birthdate and smoker status.

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

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

    GLINTCO    -

    GLSYSTEM   -

    HRHISTORY  - The HR History file is accessed to retrieve the annual salary
                 on an "as of" date, the FTE number, and the annual number of
                 hours for a job.

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

    HRSUPER    - The Supervisors file is accessed by this report.

    JOBCODE    - The Job Code Parameters file is used to access annual hours on
                 the job code.

    ONETMDED   - The Payroll One-Time Deduction file is accessed by this report.

    PADICT     -

    PAEMPLOYEE - The Employee PA Information file is used to access employee
                 data.

    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 validate
                 that the employee is set up for a pay deduction.

    PAYMASTR   -

    PCODES     - The Human Resources Code file is used to verify locations.

    PERSGROUP  - The Employee Group Header file is accessed to validate the
                 group name and to retrieve the group description.

    PGEMPLOYEE - The Employee Group Employees file is accessed to retrieve all
                 the employees in a group.

    PGSELECT   - The Employee Group Selection Criteria file is accessed to
                 determine if a group is part of the selection criteria.

    PLAN       - The Benefit Plan file is used by common routine.

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

    PREMIUM    - The Benefit Plan Premium file is accessed to verify that the
                 premium is set up for an employee.

    PROTPAYPRD - The Overtime Pay Periods file is accessed to determine the
                 start and end date of the work period. This information is
                 needed to determine if the entry point is valid.

    PROTWRKPRD - The Overtime Work Periods file is accessed to determine the
                 start and end of the work period. This information is used to
                 determine if the entry point is valid.

    PROVERTIME - The Overtime Pay Plan is accessed to determine verify that the
                 pay plan exists.

    PRRATEHIST - The Employee Rate History file is accessed to determine the
                 employee's salary on an "as of" date.

    PRSAGDTL   - The Step and Grade Schedule Detail file is used to retrieve
                 employees pay rate if a step and grade employee.

    PRSAGHEAD  -

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

    PRTAXAUTH  -

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

    PRTAXLOC   -

    PRTIME     - The Employee Pay/Hours History file is accessed to add an
                 employee's hours worked to the "from" date to calculate the
                 waiting period date.

    PSGRELATE  - The Pay Class/Pay Sum 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 rate
                 for coverage using age or years of service.

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


INVOKED Programs

    HRHI
    HRLO
    IFAC
    ACAC
    ACCL
    API4
    IFCU
    IFSG
    SLSE
    SLSU
    IFOB