PR560 – Payroll History Load CSV

System
Payroll (PR)
Type
Batch program
Updates
57 tables
References
78 tables

PR560 (Payroll History Load CSV) is a Lawson Payroll batch program. It updates ACCOMMIT, ACCOMMITX, ADDRDATA, C6EMDDMSTR, C6EMPADDRT, C6PRDDTL, CKPOINT, CMASSIGN and 49 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ATTENDCODE, BANKFILE and 70 more.

About PR560

Run Payroll History Load CSV (PR560) to create payroll history records in the Payroll system. 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-CHECK-ID HL-PROCESS-LEVEL HL-DEPARTMENT **Processing Effect 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 makecorrections. 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. PR560 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 (57)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ADDRDATAAddress CodeIF
C6EMDDMSTRNo description in the Lawson data dictionaryC6
C6EMPADDRTNo description in the Lawson data dictionaryC6
C6PRDDTLNo description in the Lawson data dictionaryC6
CKPOINTNo description in the Lawson data dictionary
CMASSIGNNo description in the Lawson data dictionaryCW
CMPAYCYCNo description in the Lawson data dictionaryCW
CWASSIGNNo description in the Lawson data dictionaryCW
EMACHDEPSTEmployee ACH AccountPR
EMDEDMASTREmployee DeductionPR
EMPACHDISTEmployee ACH DistributionPR
EMPLOYEEEmployeeHR
FBDETAILBudget DetailGL
FBFUNDAMTBudget Fund BalanceGL
FBTRANSBudget TransactionsGL
FBYETRNo description in the Lawson data dictionaryGL
GLCOMMITGL CommitmentsGL
GLCOMMITXGL commitment DetailGL
GLHISCOMBLNo description in the Lawson data dictionaryGL
GLHISCOMXNo description in the Lawson data dictionaryGL
HRHISTORYHR HistoryHR
LPPENDREQNo description in the Lawson data dictionaryLP
PAEMPPOSEmployee Multiple Pos, JobsHR
PAYDEDUCTNEmployee Payment DeductionsPR
PAYMASTREmployee Payment MasterPR
PR1099RHSTNo description in the Lawson data dictionaryPR
PR1099RSLHNo description in the Lawson data dictionaryPR
PRBATCHPayroll Time Record Batch HeadPR
PRCHECKEmployee PaymentPR
PREMDEDHSTEmployee Deduction HistoryPR
PREMPBANKNo description in the Lawson data dictionaryPR
PRMONITORNo description in the Lawson data dictionaryPR
PRPAYCODEPay CodePR
PRPENFSRCNo description in the Lawson data dictionaryPR
PRPENFSRCHNo description in the Lawson data dictionaryPR
PRPENHISTNo description in the Lawson data dictionaryPR
PRPENPAYNo description in the Lawson data dictionaryPR
PRRATEHISTEmployee Rate HistoryHR
PRREGPARMNo description in the Lawson data dictionaryPR
PRSHIFTHDRContains the shift table code definitions.PR
PRSYSTEMHR Company and Process LevelsHR
PRTAXLOCNo description in the Lawson data dictionaryPR
PRTIMEEmployee Pay/Hours HistoryPR
QUARTDEDQuarterly DeductionPR
QUARTWAGEQuarterly WagePR
STANDTIMEPayroll Standard Time RecordPR
SUBCKPOINTSubledger Check PointIF
TAEEMASTEREmployee Absence PlanLP
TAEMPSERVEmployee LP Service RecordLP
TAENROLLNo description in the Lawson data dictionaryLP
TAPAYROLLAbsence Plan Payroll RuleLP
TASTRUCTURAbsence Plan StructureLP
TIMERECORDEmployee Time RecordsPR
TIPPAYEmployee Tip PayPR
TRSGBLCKThis file contains segment block data for employee time records.PR

Referenced files (78)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATSUMXAccount Category Summ DetailAC
ATTENDCODEAttendance CodeTM
BANKFILEBank CodePR
C6BANKMNo description in the Lawson data dictionaryC6
C6EMPADDRTNo description in the Lawson data dictionaryC6
C6PRDDEFNo description in the Lawson data dictionaryC6
C6PRDDTLNo description in the Lawson data dictionaryC6
C6STATENo description in the Lawson data dictionaryC6
C6TAXGRPNo description in the Lawson data dictionaryC6
CMASSIGNNo description in the Lawson data dictionaryCW
CMCONTRACTNo description in the Lawson data dictionaryCW
CMCONTRULENo description in the Lawson data dictionaryCW
CMPAYCYCNo description in the Lawson data dictionaryCW
CWASSIGNNo description in the Lawson data dictionaryCW
CWCONTRACTContracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay…CW
CWCONTRULENo description in the Lawson data dictionaryCW
DEDCODEDeductionPR
DEPTCODEDepartmentHR
DEPTSEGBLKDepartment Segment BlockHR
EMDISTMASTEmp Acct Distribution OverridePR
EMSTATUSEmployee/Applicant StatusHR
FBFUNDDTLBudget Fund DetailGL
GLADDRESSGeneral Ledger Company AddressIF
GLCHARTGeneral Ledger ChartIF
GLCODESGeneral Ledger CodesIF
GLINTCOGeneral Ledger IntercompanyIF
GLNAMESGeneral Ledger NamesIF
GLSYSTEMGeneral Ledger CompanyIF
HRHISTORYHR HistoryHR
HRSECLEVEmployee Security LevelHR
INSTCTRYCDIntrastat Country CodesTX
JOBCODEJob Code ParametersHR
LPLINKLP Link Plan TableLP
ONETMDEDPayroll One-time DeductionPR
PADICTHR Systems Data DictionaryHR
PAEMPLOYEEEmployee Personnel InformationHR
PAEMPPOSEmployee Multiple Pos, JobsHR
PAPOSITIONPositionsPA
PAPOSRULEPosition RulesPA
PASCRTYData Item Attribute ParametersHR
PAYSUMGRPPay Summary GroupsPR
PCODESHuman Resource CodeHR
PCODESDTLContains contact information detail (address and phone number) for specific types of PCODES.HR
PERSACTIONPersonnel ActionPA
PERSGROUPEmployee Group HeaderHR
PLANPL Group DetailBN
PRBUSGRPNo description in the Lawson data dictionaryPR
PREMPGARNUsed to store information to identify a particular garnishment per employee per company.PR
PRFUNDSRCNo description in the Lawson data dictionaryPR
PROVERTIMEOvertime Pay PlanPR
PRPROVINCEThis file contains province codes and descriptions.PR
PRQCENTGRPNo description in the Lawson data dictionaryPR
PRRATEHISTEmployee Rate HistoryHR
PRRATESAlternate Pay RatesPR
PRSAGDTLStep & Grade Schedule DetailHR
PRSAGHEADStep & Grade Schedule HeaderHR
PRSHIFTHDRContains the shift table code definitions.PR
PRSHIFTTBLThis detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule…PR
PRSTATEStatesPR
PRTAXAUTHTax AuthorityPR
PRTAXLEVYPayroll Tax LevyPR
PSGRELATEPay Class/Pay Sum Grp RelationHR
SYSTEMCODESystem CodeIF
TAEEMASTEREmployee Absence PlanLP
TAENROLLNo description in the Lawson data dictionaryLP
TAPAYROLLAbsence Plan Payroll RuleLP
TAPLANAbsence PlanLP
TAREASCODEAbsence Plan Reason CodeLP
TASERVCODEAbsence Plan Service CodeLP
TASERVICEService Class & Code RelationsLP
TASTRUCTURAbsence Plan StructureLP
TAXGROUPPayroll Tax Reporting GroupPR
WCCLASSOVRNo description in the Lawson data dictionaryPR

Program calls

Invoked programs (17)

ACAC, ACTA, API4, HRHI, HRLO, HRST, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, PREN, SLSE, SLSS, SLSU