PR560 - Payroll History Load CSV
Run PR560 (Payroll History Load) to create payroll history records in the
LAWSON INSIGHT Payroll system. PR560 reads the contents of a previously
created comma separated value (CSV) file (HSTLOADCSV). Any history record that
does not pass cleanly through edits is written to a CSV file called HSTOUTCSV
and does not create a record in the database. Errors are printed on an edit
report so you can make corrections. History records that are created are also
listed on the report unless "Bypass report" is entered as "Yes".
Select No in the Update field, to run the program for edit purposes.
Select Yes in the Update field to update the database.
* * * IMPORTANT * * *
The input file, HSTLOADCSV, must be SORTED prior to running PR560. If it is
not sorted, unpredictable results and data corruption are possible.
HSTLOADCSV must be sorted by:
HL-COMPANY
HL-EMPLOYEE
HL-PROCESS-LEVEL
HL-DEPARTMENT
HL-CHECK-ID
A re-run option is also available. When you re-run the program against the
original input, history for each employee included in the input file is
deleted and reconstructed. Select No in the Rerun field so that existing data
is not purged and the contents of the HSTLOADCSV file is added to the existing
data.
Each record in this file represents a deduction or pay record for an employee
for a specified year, quarter, payment ID, tax state, process level, and
department, if applicable.
PR560 jobs may be run concurrently, each having it's own input and output
files. For best results, all records for a specific employee must be run in
the same job.
The HL-CHECK-ID (payment ID) field is required and the HL-CHECK-NBR (payment
number) field is optional but will default from the HL-CHECK-ID.
Updated Files
CKPOINT -
EMDEDMASTR -
EMPACHDIST -
PAYDEDUCTN -
PAYMASTR -
PR1099RHST -
PR1099RSLH -
PRCHECK -
PREMDEDHST -
PRPENFSRCH -
PRPENHIST -
PRSYSTEM -
PRTIME -
QUARTDED -
QUARTWAGE -
Referenced Files
BANKFILE -
DEDCODE -
DEPTCODE -
EMACHDEPST -
EMPLOYEE -
PAYSUMGRP -
PRBUSGRP -
PREMPGARN -
PRFUNDSRC -
PRPAYCODE -
PRPENPAY -
PRPROVINCE -
PRQCENTGRP -
PRSTATE -
PSGRELATE -
TAXGROUP -
INVOKED Programs
HRFN
IFOB
PREN
|
