PR530 – Time Record Interface CSV
- System
- Payroll (PR)
- Type
- Batch program
- Updates
- 43 tables
- References
- 80 tables
PR530 (Time Record Interface CSV) is a Lawson Payroll 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 PR530
Run Time Record Interface CSV (PR530) to create time records in the Payroll system. NOTE The CSV file for this program MUST be pre-sorted by company, batch number, and employee. **Processing Effect The system creates Batch status time records by reading a comma separated value (CSV) file created from a non-Lawson time recordsystem. PR530 can create multiple batches of time records from the same time record interface file and then process them into the Payroll system by aspecific batch or for all batches. PR530 provides an option to either create the records with errors in an error file and not update the actual time record file or to update the actual time record file. The error messages will print on an error report.
Updated files (43)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ADDRDATA | Address Code | IF |
| C6EMDDMSTR | No description in the Lawson data dictionary | C6 |
| C6EMPADDRT | No description in the Lawson data dictionary | C6 |
| CKPOINT | No description in the Lawson data dictionary | — |
| CMASSIGN | No description in the Lawson data dictionary | CW |
| CMPAYCYC | No description in the Lawson data dictionary | CW |
| CWASSIGN | No description in the Lawson data dictionary | CW |
| EMDEDMASTR | Employee Deduction | PR |
| EMPLOYEE | Employee | HR |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| HRHISTORY | HR History | HR |
| LPPENDREQ | No description in the Lawson data dictionary | LP |
| PACOMMENTS | Personnel Comments | PA |
| PAEMPLOYEE | Employee Personnel Information | HR |
| PAEMPPOS | Employee Multiple Pos, Jobs | HR |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PRBATCH | Payroll Time Record Batch Head | PR |
| PRMONITOR | No description in the Lawson data dictionary | PR |
| PRPAYCODE | Pay Code | PR |
| PRRATEHIST | Employee Rate History | HR |
| PRREGPARM | No description in the Lawson data dictionary | PR |
| PRSHIFTHDR | Contains the shift table code definitions. | PR |
| PRSYSTEM | HR Company and Process Levels | HR |
| PRTAXLOC | No description in the Lawson data dictionary | PR |
| PRTIME | Employee Pay/Hours History | PR |
| SUBCKPOINT | Subledger Check Point | IF |
| TAEEMASTER | Employee Absence Plan | LP |
| TAEMPSERV | Employee LP Service Record | LP |
| TAENROLL | No description in the Lawson data dictionary | LP |
| TAPAYROLL | Absence Plan Payroll Rule | LP |
| TASTRUCTUR | Absence Plan Structure | LP |
| TIMERECORD | Employee Time Records | PR |
| TIPPAY | Employee Tip Pay | PR |
| TRSGBLCK | This file contains segment block data for employee time records. | PR |
Referenced files (80)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ATTENDCODE | Attendance Code | TM |
| C6EMPADDRT | No description in the Lawson data dictionary | C6 |
| C6PRDDEF | No description in the Lawson data dictionary | C6 |
| C6PRDDTL | No description in the Lawson data dictionary | C6 |
| CMASSIGN | No description in the Lawson data dictionary | CW |
| CMCONTRACT | No description in the Lawson data dictionary | CW |
| CMCONTRULE | No description in the Lawson data dictionary | CW |
| CMPAYCYC | No description in the Lawson data dictionary | CW |
| CWASSIGN | No description in the Lawson data dictionary | CW |
| CWCONTRACT | Contracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay… | CW |
| CWCONTRULE | No description in the Lawson data dictionary | CW |
| DEDCODE | Deduction | PR |
| DEPTCODE | Department | HR |
| DEPTSEGBLK | Department Segment Block | HR |
| EMDISTMAST | Emp Acct Distribution Override | PR |
| EMSTATUS | Employee/Applicant Status | HR |
| EMTAMASTR | Employee Time Accrual Master | TA |
| FBFUNDDTL | Budget Fund Detail | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| HRHISTORY | HR History | HR |
| HRSECLEV | Employee Security Level | HR |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JOBCODE | Job Code Parameters | HR |
| LPLINK | LP Link Plan Table | LP |
| ONETMDED | Payroll One-time Deduction | PR |
| PADICT | HR Systems Data Dictionary | HR |
| PAEMPPOS | Employee Multiple Pos, Jobs | HR |
| PAPOSITION | Positions | PA |
| PAPOSRULE | Position Rules | PA |
| PASCRTY | Data Item Attribute Parameters | HR |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PAYMASTR | Employee Payment Master | PR |
| PAYSUMGRP | Pay Summary Groups | PR |
| PCODES | Human Resource Code | HR |
| PCODESDTL | Contains contact information detail (address and phone number) for specific types of PCODES. | HR |
| PERSACTION | Personnel Action | PA |
| PERSGROUP | Employee Group Header | HR |
| PLAN | PL Group Detail | BN |
| PLANMASTER | Time Accrual Plan | TA |
| PRBUSGRP | No description in the Lawson data dictionary | PR |
| PRCHECK | Employee Payment | PR |
| PREMDEDHST | Employee Deduction History | PR |
| PROVERTIME | Overtime Pay Plan | PR |
| PRPAYCODE | Pay Code | PR |
| PRPENPAY | No description in the Lawson data dictionary | PR |
| PRPROVINCE | This file contains province codes and descriptions. | PR |
| PRQCENTGRP | No description in the Lawson data dictionary | PR |
| PRRATEHIST | Employee Rate History | HR |
| PRRATES | Alternate Pay Rates | PR |
| PRSAGDTL | Step & Grade Schedule Detail | HR |
| PRSAGHEAD | Step & Grade Schedule Header | HR |
| PRSHIFTHDR | Contains the shift table code definitions. | PR |
| PRSHIFTTBL | This detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule… | PR |
| PRSTATE | States | PR |
| PRTAXAUTH | Tax Authority | PR |
| PRTAXLEVY | Payroll Tax Levy | PR |
| PRTIME | Employee Pay/Hours History | PR |
| PSGRELATE | Pay Class/Pay Sum Grp Relation | HR |
| SYSTEMCODE | System Code | IF |
| TAEEMASTER | Employee Absence Plan | LP |
| TAENROLL | No description in the Lawson data dictionary | LP |
| TAPAYROLL | Absence Plan Payroll Rule | LP |
| TAPLAN | Absence Plan | LP |
| TAREASCODE | Absence Plan Reason Code | LP |
| TASERVCODE | Absence Plan Service Code | LP |
| TASERVICE | Service Class & Code Relations | LP |
| TASTRUCTUR | Absence Plan Structure | LP |
| TAXGROUP | Payroll Tax Reporting Group | PR |
| WCCLASSOVR | No description in the Lawson data dictionary | PR |
Program calls
Invoked programs (17)
ACAC, ACTA, API4, HRHI, HRLO, HRST, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, PREN, SLSE, SLSS, SLSU