Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

UK560


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