|
UK560 - United Kingdom Payroll History Load CSV
Run UK Payroll History Load CSV (UK560) to create payroll history records
in the 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 -
ADDRDATA -
CKPOINT -
EMACHDEPST -
EMDEDMASTR -
EMPACHDIST -
EMPLOYEE -
GLCOMMIT -
GLCOMMITX -
HRHISTORY -
PAYDEDUCTN -
PAYMASTR -
PR1099RHST -
PR1099RSLH -
PRCHECK -
PREMDEDHST -
PREMPBANK -
PRMONITOR -
PRPENFSRC -
PRPENFSRCH -
PRPENHIST -
PRPENPAY -
PRREGPARM -
PRSYSTEM -
PRTAXLOC -
PRTIME -
QUARTDED -
QUARTWAGE -
STANDTIME -
TAEMPSERV -
TIMERECORD -
TIPPAY -
TMEMPLVDTL -
TRSGBLCK -
UKNITP -
Referenced Files
ACACCTCAT -
ACACTGRP -
ACACTIVITY -
ACCAL -
ACCALX -
ACCATSUMX -
ATCLASS -
ATTENDCODE -
BANKFILE -
DEDCODE -
DEPTCODE -
DEPTSEGBLK -
EMDISTMAST -
EMSTATUS -
GLADDRESS -
GLCHART -
GLCODES -
GLINTCO -
GLNAMES -
GLSYSTEM -
HRHISTORY -
HRSECLEV -
INSTCTRYCD -
JOBCODE -
ONETMDED -
PADICT -
PAEMPLOYEE -
PAEMPPOS -
PAPOSITION -
PAPOSRULE -
PASCRTY -
PAYSUMGRP -
PCODES -
PCODESDTL -
PERSACTION -
PLAN -
PRBUSGRP -
PREMPGARN -
PRFUNDSRC -
PROVERTIME -
PRPAYCODE -
PRPROVINCE -
PRQCENTGRP -
PRRATEHIST -
PRRATES -
PRSAGDTL -
PRSAGHEAD -
PRSHIFTHDR -
PRSHIFTTBL -
PRSTATE -
PRTAXAUTH -
PRTAXLEVY -
PRTAXPRDS -
PRTAXYEAR -
PSGRELATE -
SYSTEMCODE -
TAEEMASTER -
TAENROLL -
TAPAYROLL -
TAPLAN -
TAREASCODE -
TASERVCODE -
TASERVICE -
TASTRUCTUR -
TAXGROUP -
TMLEAVE -
UKNICAT -
WCCLASSOVR -
INVOKED Programs
HRHI
HRLO
HRST
IFAC
ACAC
ACTA
API4
IFCU
IFOB
IFSG
IFLU
IFUP
SLSE
SLSU
IFRS
PREN
SLSS
|