PR514 - Employee Deduction Master Load

Run PR514 (Employee Deduction Master Load) to load non-benefit, non-tax
employee deduction data from a non-Lawson system into PR14.1 (Employee
Deduction) and PR26.1 (Employee Garnishment) in the Lawson Payroll system.
This program takes fields from a comma-separated value (CSV) file and updates
the associated deduction files as if the deductions were added on PR14.1 or
PR26.1. The program performs all the edits of PR14.1 and PR26.1.

The program also updates declining balances, limit balances, ascending
balances, and additional tax amounts. If the record has errors, an error
message prints on the report.

Use the Add function only for initial deduction creation. Use the Change
function to update existing deduction data.

Planning considerations
Before beginning the conversion process, you must make some basic decisions
concerning the miscellaneous deduction data you will convert.
1. Determine records you want to convert
Examine the miscellaneous deduction records (records that are not created
automatically when the employee is added and enrolled in benefits) and
determine how many records exist. If there are only a few, it may be more
efficient to enter the records manually.

2. Define test samples
Select one deduction for one employee as a sample. We recommend that you
choose a deduction that is taken for a large number of employees.
Make the sample large enough to test most fields but small enough to be
manageable. Perform all steps of the conversion process to verify that you
defined structure and codes properly and that your data converted without
errors.

Before you run PR514:
- Ensure the company is defined in HR00.1 (Company).
- Ensure employees are defined in HR11.1 (Employee).*
- Ensure deduction codes are defined in PR20.4 (Deduction Code).
- Ensure the distribution companies are defined in GL10.1 (Company).
- Ensure the accounting units, account numbers, and sub account numbers are
defined in GL20.1 (Accounting Units-Accounts).

Mapping Considerations
The data in the CSV file should be sorted to improve the efficiency of the
conversion. The sort order should be:
CDL-EDM-COMPANY
CDL-EDM-EMPLOYEE

Employee Deduction Master Conversion (PR514) updates the following files:

Database File Description    Database File Name
-------------------------    ------------------
Employee Deduction Master    EMDEDMASTR
Employee                     EMPLOYEE
HR History*                  HRHISTORY
Employee Garnishment         PREMPGARN
Garnishment Rule             PRGARNRULE
Tax Group                    PRTAXGRP
*updated if changes are logged to history

Workfile name:
DEDLOADCSV

To verify data:
PR214 (Employee Deduction Listing).

Updated Files

    CKPOINT    -

    EMDEDMASTR -

    EMPLOYEE   -

    HRHISTORY  -

    PREMPGARN  -

    PRGARNRULE -

    PRTAXGRP   -


Referenced Files

    APCOMPANY  -

    APCPYVND   -

    APHLDINV   -

    APVENCLASS -

    APVENGROUP -

    APVENMAST  -

    DEDCODE    -

    GLADDRESS  -

    GLCHART    -

    GLINTCO    -

    GLSYSTEM   -

    HRHISTORY  -

    HRSECLEV   -

    ONETMDED   -

    PADICT     -

    PASCRTY    -

    PAYDEDUCTN -

    PLAN       -

    PREMDEDHST -

    PRGARNTYPE -

    PRPAYCODE  -

    PRSYSTEM   -

    PRTAXAUTH  -

    PRTAXGRP   -

    PRTAXLEVY  -

    PRVENDOR   -


INVOKED Programs

    HRFN
    HRLO
    IFAC
    ACAC
    IFCR
    IFSG
    IFCU
    IFAU
    SLSE
    SLSU
    IFOB