PR521 – Nonstandard Pay and Work Period CSV Load

System
Human Resources (HR)
Type
Batch program
Updates
43 tables
References
80 tables

PR521 (Nonstandard Pay and Work Period CSV Load) is a Lawson Human Resources batch program. It updates ACCOMMIT, ACCOMMITX, ADDRDATA, C6EMDDMSTR, C6EMPADDRT, CKPOINT, CMASSIGN, CMPAYCYC and 35 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ATTENDCODE, C6EMPADDRT and 72 more.

About PR521

Run Nonstandard Pay and Work Period CSV Load (PR521) to create pay and workperiods for nonstandard semi-monthly pay plans (that is, pay plans with two pay periods per month, ending on dates other than the 15th and end of the month). IMPORTANT The input file, PRDLOADCSV, must be SORTED prior to running PR521.If it is not sorted, results may be unpredictable. PRDLOADCSV must be sorted (ascending order) by: -COMPANY -PLAN-CODE -EFFECT-DATE -PERIOD-TYPE -START-DATE **Processing Effect PR521 reads the contents of a previously created comma separated value (CSV)file (PRDLOADCSV). Each record in this file represents a pay or work period for a specified company, pay plan, and effective date. You can load the entire file or specify one or more pay plans. If you specifypay plans, records for other pay plans in the CSV file will not be processed for that run. The Add processing option adds the records in the CSV file to the database. The Delete;Add processing option deletes records from a specified Delete Fromdate forward, and then adds the records in the CSV file to the database. If employees are tied to the pay plan or the pay plan exists on Pay Plan Schedules (PR22), then the Delete From date must be on or after the current system date. If any one record errors out, NO records are updated for that pay plan andeffective date. The record causing the error is printed on an error report, and any records NOT updated are copied to the PRDERRCSV error file. Once you correct the error, you can reload the records. You can run the CSV load as many times as needed. Select Report Only in the Update Option field to do a test run. Select Update in the Update Option field to update the database.

Updated files (43)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ADDRDATAAddress CodeIF
C6EMDDMSTRNo description in the Lawson data dictionaryC6
C6EMPADDRTNo 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
EMDEDMASTREmployee DeductionPR
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
PRBATCHPayroll Time Record Batch HeadPR
PRMONITORNo description in the Lawson data dictionaryPR
PROTPAYPRDOvertime Pay PeriodsPR
PROTWRKPRDOvertime Work PeriodsPR
PRPAYCODEPay CodePR
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
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 (80)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATSUMXAccount Category Summ DetailAC
ATTENDCODEAttendance CodeTM
C6EMPADDRTNo description in the Lawson data dictionaryC6
C6PRDDEFNo description in the Lawson data dictionaryC6
C6PRDDTLNo 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
PATHFINDEmployee Report Writer PathsHR
PAYDEDUCTNEmployee Payment DeductionsPR
PAYMASTREmployee Payment MasterPR
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
PRCHECKEmployee PaymentPR
PREMDEDHSTEmployee Deduction HistoryPR
PROVERTIMEOvertime Pay PlanPR
PRPAYCODEPay CodePR
PRPENPAYNo description in the Lawson data dictionaryPR
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
PRTIMEEmployee Pay/Hours HistoryPR
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