Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

UK560


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