PR539 – One Time Deduction Load

System
Payroll (PR)
Type
Batch program
Updates
10 tables
References
16 tables

PR539 (One Time Deduction Load) is a Lawson Payroll batch program. It updates C6EMDDMSTR, CKPOINT, EMDEDMASTR, EMPLOYEE, HRHISTORY, ONETMDED, PAYDEDUCTN, PRREGPARM and 2 more and references BENEFIT, DEDCODE, EMSTATUS, GLINTCO, GLSYSTEM, HRHISTORY, HRSECLEV, PADICT and 8 more.

About PR539

Run One Time Deduction Load (PR539) to load new one-time deduction records and modify or delete existing one-time deduction records. The input CSV file must be presorted by Company (if more than one would be provided in the CSV), Employee, Ded-Code. Note that only one company would be loaded based on PRM-Company so it is recommended to only include thatcompany in the CSV file. Required fields are noted below. To change or delete an existing one-time deduction, the sequence number (OTD-Seq-Nbr and OTD-EDM-Seq-Nbr) are required in the CSV file. One TimeDeduction Listing (PR239) can be run to create a CSV file for existing one-timededuction records which will include the OTD-Seq-Nbr and OTD-EDM-Seq-Nbr. This file can be modified and used as the input CSV file for PR539 to modify or delete these existing records. To add a benefit one-time deduction when more than one EDM record exists for a deduction code, either the EDM-Seq-Nbr should be provided in the CSV load to locate the correct EDM record, or if not provided, the program will find the most recent EDM record based on the OTD-Effective-Date. To add a garnishment one-time deduction when more than one EDM record exists for a deduction code, either the Edm-Seq-Nbr should be provided in the CSV load to locate the correct EDM record, or the PR26 Case Number and File Number may be provided to locate the EDM record tied to that PR26 record. If neither are provided, the OTD record will not be loaded and an error will be produced.

Updated files (10)

TableDescriptionSystem
C6EMDDMSTRNo description in the Lawson data dictionaryC6
CKPOINTNo description in the Lawson data dictionary
EMDEDMASTREmployee DeductionPR
EMPLOYEEEmployeeHR
HRHISTORYHR HistoryHR
ONETMDEDPayroll One-time DeductionPR
PAYDEDUCTNEmployee Payment DeductionsPR
PRREGPARMNo description in the Lawson data dictionaryPR
PRSYSTEMHR Company and Process LevelsHR
TIMERECORDEmployee Time RecordsPR

Referenced files (16)

TableDescriptionSystem
BENEFITEmployee BenefitBN
DEDCODEDeductionPR
EMSTATUSEmployee/Applicant StatusHR
GLINTCOGeneral Ledger IntercompanyIF
GLSYSTEMGeneral Ledger CompanyIF
HRHISTORYHR HistoryHR
HRSECLEVEmployee Security LevelHR
PADICTHR Systems Data DictionaryHR
PASCRTYData Item Attribute ParametersHR
PAYDEDUCTNEmployee Payment DeductionsPR
PLANPL Group DetailBN
PREMDEDHSTEmployee Deduction HistoryPR
PREMPGARNUsed to store information to identify a particular garnishment per employee per company.PR
PRTAXAUTHTax AuthorityPR
PRTAXLEVYPayroll Tax LevyPR
PRTAXLOCNo description in the Lawson data dictionaryPR

Program calls

Invoked programs (12)

ACAC, ACTA, API4, HRLO, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU