|
|
UK560 - UK Payroll History Load CSV
**Form Purpose
Run UK Payroll History Load CSV (UK560) to create payroll history records in
the LAWSON INSIGHT Payroll system.
Important The input file, HSTLOADCSV, must be SORTED prior to running UK560.
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
**Processing Effect
UK560 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.
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.
UK560 jobs may be run concurrently, each having its 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
ACCOMMIT -
ACCOMMITX -
CKPOINT -
EMACHDEPST -
EMDEDMASTR -
EMPACHDIST -
EMPLOYEE -
GLCOMMIT -
GLCOMMITX -
HRHISTORY -
PAYDEDUCTN -
PAYMASTR -
PBTIMEREC -
PR1099RHST -
PR1099RSLH -
PRCHECK -
PREMDEDHST -
PREMPBANK -
PRMONITOR -
PRPENFSRC -
PRPENFSRCH -
PRPENHIST -
PRPENPAY -
PRREGPARM -
PRSYSTEM -
PRTAXLOC -
PRTIME -
QUARTDED -
QUARTWAGE -
STANDTIME -
TIMERECORD -
TIPPAY -
TMEMPLVDTL -
TRSGBLCK -
UKNITP -
Referenced Files
ACACCTCAT -
ACACTGRP -
ACACTIVITY -
ATCLASS -
ATTENDCODE -
BANKFILE -
DEDCODE -
DEPTCODE -
DEPTSEGBLK -
EMDISTMAST -
EMSTATUS -
GLADDRESS -
GLCHART -
GLINTCO -
GLNAMES -
GLSYSTEM -
HRHISTORY -
HRSECLEV -
HRUTILITY -
INSTCTRYCD -
JOBCODE -
ONETMDED -
PADICT -
PAEMPLOYEE -
PAEMPPOS -
PAPOSITION -
PAPOSRULE -
PASCRTY -
PAYSUMGRP -
PBCLIENT -
PCODES -
PCODESDTL -
PERSACTION -
PLAN -
PRBUSGRP -
PREMPGARN -
PRFUNDSRC -
PRMONITOR -
PROVERTIME -
PRPAYCODE -
PRPROVINCE -
PRQCENTGRP -
PRRATEHIST -
PRRATES -
PRSAGDTL -
PRSAGHEAD -
PRSHIFTHDR -
PRSHIFTTBL -
PRSTATE -
PRTAXAUTH -
PRTAXLEVY -
PRTAXPRDS -
PRTAXYEAR -
PSGRELATE -
SYSTEMCODE -
TAXGROUP -
TMLEAVE -
UKNICAT -
INVOKED Programs
ACCL
HRHI
HRLO
HRST
IFAC
ACAC
API4
IFCU
IFSG
SLSE
SLSU
IFOB
IFRS
PREN
SLSS
|
