TA570 - CSV Load Balances

Run TA570 (CSV Load Balances) to load manual adjustments for accrual and/or
eligibility using a CSV (comma-separated value) file. These manual adjustments
can be for initial plan loading, special adjustments, or for dumping and
reloading plans.

TA570 performs TA transaction edits similar to TA70.1 (Plan Adjustments).

For dumping and reloading, RNGDBDUMP -c could be used to create a CSV file,
which could then be edited, for example using Excel.

TA570 has the Drill Around feature. For more information, see Getting Started
with the Desktop Client.

Planning considerations
Before beginning the conversion process, plan which balances you will convert.
Decide if you will convert accrued balances, eligible balances, or both.

Before you run TA570:
- Ensure employees are defined in HR11.1.
- Ensure time accrual plans are defined.
Before converting balances, make sure that you have defined all the time
accrual plans for which you are converting balances on TA70.1 (Time Accrual
Plan).
- Verify each employee for whom you are converting balances has been enrolled
in the Time Accrual Plan for which you are converting the balances.
When employees are enrolled into Time Accrual Plans, an Employee Plan is
created for them. To verify employee plans, use  TA60.1 (Employee Plan
Inquiry).
- Verify that the Employee Plan Entry date precedes the date the balances are
loaded (Transaction Date). Check the Entry Date on the TA60.1 (Employee Plan
Inquiry) comes before the date you enter in the Transaction Date field in the
conversion input file.

Conversion Program Parameters
Plan - If you leave this field blank, all plans are processed.

Override Transaction Date - If you leave this field blank, the program uses
the date on the CSV file.  If you enter a date, it overrides the date on the
CSV file.

Create CSV Error File - If you enter Yes, records that
- fail numeric edits,
- contain invalid accrual plans (PLANMASTER),
- contain invalid employees, fail security edits, or
- fail edits against the employee accrual master (EMTAMASTR) are written to
the error file for user reprocessing.

Update - If you enter No, transaction records are not written to the accrual
transaction file (EMTATRANS). The reports are still created and the Error CSV
file is still created. The report shows transactions created as well as the
total transactions processed. If you enter Yes, transactions are loaded to the
EMTATRANS file in an Open status. You must run TA170 (Time Accrual Update) or
TA199 (Time Accrual Close) process these transactions.

Note: To close transactions with an Open status, you can run a separate TA
cycle or wait until you run the next TA cycle.

TA570 updates the following files:

Database File Description             Database File Name
-------------------------             ------------------
Employee Time Accrual Master          EMTAMASTR
Employee Time Accrual Transactions    EMTATRANS

Workfile name:
TABALCSV

To verify data:
Run TA270 (Open Manual Transactions).

Updated Files

    CKPOINT    -

    EMTAMASTR  -

    EMTATRANS  -


Referenced Files

    EMPLOYEE   -

    HRSECLEV   -

    PLANMASTER -

    PRSYSTEM   -


INVOKED Programs

    HRFN