Payroll – Lawson PR tables and programs
Payroll (PR) in Lawson S3 v10 MSP6 has 99 tables, 201 online screens and 147 batch programs.
Tables (99)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| BANKACCT | BAC | Bank Account | BNK-ACCT-NBR | 18 |
| BANKFILE | BFL | Bank Code | COMPANY, BANK-CODE | 16 |
| CAVACMSTR | CAV | No description in the Lawson data dictionary | COMPANY, PLAN-NAME, TAX-ID-CODE, BEG-EFF-DATE | 14 |
| DCCLASS | DCL | Deduction Class | COMPANY, DED-CLASS | 4 |
| DEDCODE | DDC | Deduction | COMPANY, DED-CODE | 82 |
| DEDFREQTBL | DFT | Frequency Table | COMPANY, TABLE-CODE | 19 |
| DEDGROUP | DDG | No description in the Lawson data dictionary | COMPANY, COUNTRY-CODE, DED-GROUP, DED-CODE | 5 |
| EMACHDEPST | EAD | Employee ACH Account | COMPANY, EMPLOYEE, ACH-DIST-NBR | 49 |
| EMDEDMASTR | EDM | Employee Deduction | COMPANY, EMPLOYEE, DED-CODE, SEQ-NBR | 109 |
| EMDISTMAST | DIP | Emp Acct Distribution Override | COMPANY, EMPLOYEE, POSITION, PAY-CODE, DED-CODE, SEQ-NBR | 26 |
| EMPACHDIST | ACD | Employee ACH Distribution | COMPANY, EMPLOYEE, CHECK-ID, ACH-DIST-NBR | 26 |
| EMPCOMMENT | ECM | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, CMT-TYPE, DATE, LN-NBR | 9 |
| EMPSUMM | ESM | Employee Year-To-Date Tip Pay | COMPANY, PROCESS-LEVEL, DEPARTMENT, SHIFT, EMPLOYEE, PAYROLL-YEAR, LST-CALC-DATE | 19 |
| ONETMDED | OTD | Payroll One-time Deduction | COMPANY, EMPLOYEE, DED-CODE, EDM-SEQ-NBR, SEQ-NBR | 26 |
| PAYCLASS | PCL | Pay Class | COMPANY, PAY-CLASS | 3 |
| PAYDEDUCTN | PYD | Employee Payment Deductions | COMPANY, EMPLOYEE, CHECK-ID, DED-CODE, EDM-SEQ-NBR, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE | 33 |
| PAYMASTR | PYM | Employee Payment Master | COMPANY, EMPLOYEE, CHECK-ID | 29 |
| PAYSUMGRP | PSG | Pay Summary Groups | COMPANY, PAY-SUM-GRP | 18 |
| PR1099RHST | PHR | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, REPORT-ENTITY, PROCESS-LEVEL, PENS-DIST-CODE, PENS-DST-CODE2, CHECK-ID, PENS-SEQ-NBR | 21 |
| PR1099RSLH | PSL | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, REPORT-ENTITY, PROCESS-LEVEL, PENS-DIST-CODE, PENS-DST-CODE2, CHECK-ID, PENS-SEQ-NBR, DED-CODE | 13 |
| PR941 | PR9 | No description in the Lawson data dictionary | COMPANY, PAYROLL-YEAR, QUARTER, REPORT-ENTITY | 23 |
| PRADIBON | PIB | Employee Bonus Accrual Detail | COMPANY, REC-TYPE, EMPLOYEE, TABLE, EFFECT-DATE, ACCRUAL-DATE | 17 |
| PRATXGROUP | AGF | No description in the Lawson data dictionary | COMPANY, GROUP-CODE, TAX-STATUS | 5 |
| PRAUDIT | PRU | Payroll Payment Audit File | COMPANY, BNK-ACCT-NBR, CHECK-NBR, CHECK-ID, SEQ-NBR | 13 |
| PRBATCH | PRB | Payroll Time Record Batch Head | COMPANY, BATCH-NBR | 16 |
| PRBUSGRP | PBG | No description in the Lawson data dictionary | COMPANY, PROCESS-LEVEL, BUS-NBR-GRP | 7 |
| PRCHECK | PCH | Employee Payment | BNK-ACCT-NBR, PRINT-TYPE, CHECK-NBR, CHECK-ID | 24 |
| PRDEDACCTS | PDG | No description in the Lawson data dictionary | COMPANY, DED-CODE, PROCESS-LEVEL, RECORD-TYPE | 10 |
| PRDEDDTL | PDE | No description in the Lawson data dictionary | PYD-OBJ-ID, TAX-STATUS | 8 |
| PRDISTRIB | PRD | Employee Payment Distribution | COMPANY, EMPLOYEE, CHECK-ID, OBJ-ID | 53 |
| PREMDEDHST | PDH | Employee Deduction History | COMPANY, EMPLOYEE, DED-CODE, SEQ-NBR, YEAR, PERIOD-NBR, REPORT-ENTITY | 48 |
| PREMPBANK | PEB | No description in the Lawson data dictionary | EBANK-ID, CA-INST-NBR, CA-TRANSIT-NBR | 12 |
| PREMPGARN | PEG | Used to store information to identify a particular garnishment per employee per company. | COMPANY, EMPLOYEE, CASE-NUMBER, FILE-NUMBER | 70 |
| PREMPSTATE | PES | Employee State | COMPANY, EMPLOYEE, STATE | 16 |
| PREMPWKPAT | WKE | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, PATT-EFF-FROM | 13 |
| PRFUNDSRC | PFS | No description in the Lawson data dictionary | COMPANY, PROCESS-LEVEL, DEPARTMENT, FUNDING-SOURCE | 14 |
| PRGARNHIST | GRH | Contains the history for a particular garnishment (case number and file number). | COMPANY, EMPLOYEE, CHECK-ID, GARN-OBJ-ID | 24 |
| PRGARNRULE | PGR | The Garnishment Rules files contains garnishment rules by governing tax authority and category for wage formulas… | COMPANY, COUNTRY-CODE, TAX-ID-CODE, GARN-CAT, TYPE | 40 |
| PRGARNRULX | PGX | No description in the Lawson data dictionary | COMPANY, COUNTRY-CODE, TAX-ID-CODE, GARN-CAT, TYPE, SEQ-NBR | 17 |
| PRGARNTYPE | GRT | Contains the type of garnishments and categories to which they are linked. | COUNTRY-CODE, TYPE | 4 |
| PRGRPPAY | PPY | The Group Pay file contains the valid pay codes to be used for Web Time Record Entry. | COMPANY, GROUP-NAME, PAY-CODE | 4 |
| PRHOURS | PHS | Payroll Hours | COMPANY, EMPLOYEE, HOURS-TYPE, PAYROLL-YEAR | 11 |
| PRMINWAGE | PMW | Minimum Wage | TAX-ID-CODE, EFFECT-DATE | 8 |
| PRMONITOR | PMN | No description in the Lawson data dictionary | COMPANY, CYCLE-PROCESS, PROC-GROUP, PROCESS-LEVEL, BANK-CODE | 28 |
| PROGPAY | PGP | This file contains the table name, effective dates, and rules for eligibility. | COMPANY, REC-TYPE, TABLE, EFFECT-DATE | 19 |
| PROGPAYEND | PED | This file contains the eligibility end points for a progressive pay rate table and is linked to the PROGPAY file. | COMPANY, TABLE, EFFECT-DATE, ENDING-DATE | 4 |
| PROGPAYENT | PET | This file contains the eligibility entry points for a progressive pay rate table and is linked to the PROGPAY file. | COMPANY, TABLE, EFFECT-DATE, ENTRY-DATE | 4 |
| PROGRATE | PGA | This file contains the progressive pay rates based on rules. | COMPANY, REC-TYPE, TABLE, EFFECT-DATE, PAY-GROUP-NAME, FROM-UNITS | 18 |
| PRONWAGES | POW | No description in the Lawson data dictionary | COMPANY, DED-CODE, PROCESS-LEVEL, BUS-NBR-GRP, EFFECT-DATE | 7 |
| PROTACCTS | OTA | This file contains expense accounts for premium portions of pay by job codes. | COMPANY, PROCESS-LEVEL, JOB-CODE, PAY-CODE, OT-JOB-CODE | 7 |
| PROTPAYPRD | PRY | Overtime Pay Periods | COMPANY, PLAN-CODE, EFFECT-DATE, PAY-START-DATE | 6 |
| PROTWRKPRD | PRW | Overtime Work Periods | COMPANY, PLAN-CODE, EFFECT-DATE, WRK-START-DATE | 5 |
| PROVERTIME | PRO | Overtime Pay Plan | COMPANY, PLAN-CODE, EFFECT-DATE | 24 |
| PRPAYCODE | PCD | Pay Code | COMPANY, PROCESS-LEVEL, JOB-CODE, PAY-CODE | 55 |
| PRPAYTOTAL | PYT | The Pay Total file contains a record of the total hour for a pay period as entered by an employee using the Web Time… | COMPANY, PAY-PER-START, EMPLOYEE | 6 |
| PRPENDTIME | PPT | Pending Time Record | COMPANY, EMPLOYEE, TIME-SEQ | 45 |
| PRPENFSRC | PNF | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, PENS-SEQ-NBR, FUNDING-SOURCE, RETRO-PAYMENT | 9 |
| PRPENFSRCH | PFH | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, CHECK-ID, PENS-SEQ-NBR, FUNDING-SOURCE | 7 |
| PRPENHIST | PNH | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, CHECK-ID, PENS-SEQ-NBR | 25 |
| PRPENPAY | PNP | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, EFFECT-DATE, PENS-SEQ-NBR | 28 |
| PRPROVINCE | PPV | This file contains province codes and descriptions. | PROVINCE | 2 |
| PRQCENTGRP | PQC | No description in the Lawson data dictionary | COMPANY, PROCESS-LEVEL, QC-ENT-NBR-GRP | 4 |
| PRQUALIFY | PRQ | Required Code Select Criteria | COMPANY, RECORD-KEY, SEQ-NBR | 27 |
| PRRATES | PRR | Alternate Pay Rates | COMPANY, EMPLOYEE, SEQ-NBR | 19 |
| PRREGDICT | RGF | No description in the Lawson data dictionary | COUNTRY-CODE, RECORD-TYPE, TOPIC, FLD-NBR | 13 |
| PRREGPARM | RGP | No description in the Lawson data dictionary | COMPANY, COUNTRY-CODE, PAYROLL-YEAR, RECORD-TYPE, REPORT-ENTITY, TAX-ID-CODE, EMPLOYEE, TOPIC, FLD-NBR, SEQ-NBR | 15 |
| PRSHIFTHDR | PSH | Contains the shift table code definitions. | COMPANY, SHIFT-CODE, EFFECT-DATE | 7 |
| PRSHIFTTBL | PSB | This detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule… | COMPANY, SHIFT-CODE, EFFECT-DATE, OBJ-ID | 14 |
| PRSTATE | PSA | States | STATE | 2 |
| PRTAXAUTH | PRX | Tax Authority | TAX-ID-CODE | 12 |
| PRTAXCAT | PXC | No description in the Lawson data dictionary | COUNTRY-CODE, ADJUST-PAY, TAX-CATEGORY | 4 |
| PRTAXID | PTI | Tax Identification Number | TAX-ID-CODE, COMPANY, PROCESS-LEVEL | 37 |
| PRTAXLEVY | TXL | Payroll Tax Levy | TAX-ID-CODE, LEVY-YEAR, LEVY-FILING-ST, LEVY-EXEMPTS | 6 |
| PRTAXLOC | PXL | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, LOCAT-CODE, DED-CODE | 9 |
| PRTIME | PRT | Employee Pay/Hours History | COMPANY, EMPLOYEE, CHECK-ID, PAY-SUM-GRP, TIME-SEQ | 86 |
| PRTIMEDATE | PTM | Web Time Entry Pay Period Date | COMPANY, PLAN-CODE, EFFECT-DATE, PAY-START-DATE | 9 |
| PRTIMEFORM | TRF | The Web Time Record Form file contains the records that make up a Web Time Entry Form. | COMPANY, FORM-TYPE, GROUP-NAME, FORM-FIELD | 10 |
| PRTRDADJ | PTA | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, ORIG-CHECK-ID, TIME-SEQ | 5 |
| PRVENDOR | PRV | This file contains AP vendors defined for a deduction code and process level. | COMPANY, DED-CODE, PROCESS-LEVEL | 5 |
| PRWEEKS | PWK | Employee Weeks Worked | COMPANY, PAYROLL-YEAR, QUARTER, EMPLOYEE, REPORT-ENTITY, PROCESS-LEVEL, WORK-STATE | 8 |
| PRWKPAT | WKP | No description in the Lawson data dictionary | PATTERN-CODE | 3 |
| PRWKPATDTL | WKD | No description in the Lawson data dictionary | PATTERN-CODE, WEEK-NBR | 9 |
| PSGTAXES | PTX | Pay Summary Group Taxes | COMPANY, PAY-SUM-GRP, TAX-AUTH-TYPE | 7 |
| QUARTDED | QTD | Quarterly Deduction | COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, COUNTRY-CODE, DED-CODE, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSION | 22 |
| QUARTWAGE | QTW | Quarterly Wage | COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, COUNTRY-CODE, PAY-SUM-GRP, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSION | 21 |
| REQCODE | RQC | Required Deduction Code Header | COMPANY, REQ-CODE | 5 |
| STANDTIME | STM | Payroll Standard Time Record | COMPANY, EMPLOYEE, TIME-GROUP, PAY-CODE, SEQ-NBR | 40 |
| TAXGROUP | TXG | Payroll Tax Reporting Group | COMPANY, HEAD-PROC-LEV, PROCESS-LEVEL | 4 |
| TAXIDEXMP | TID | Pay/Deduction Exemption Code | COMPANY, PAY-DED-FLAG, PAY-CODE, DED-CODE | 6 |
| TIMERECORD | TRD | Employee Time Records | COMPANY, EMPLOYEE, TIME-SEQ | 107 |
| TIPPAY | TIP | Employee Tip Pay | COMPANY, EMPLOYEE, RECORD-DATE, TIP-PROC-LEV, TIP-DEPART, SHIFT, PAY-SUM-GRP, CHECK-TYPE, SEQ-NBR | 24 |
| TREXCEPT | TRX | This file contains exception pay codes and offsetting pay codes for deviating employee attendances, such as absences. | COMPANY, GROUP-NAME, COLUMN-NUMBER | 8 |
| TRSGBLCK | TRS | This file contains segment block data for employee time records. | COMPANY, EMPLOYEE, TIME-SEQ | 4 |
| WCCLASS | WCC | Work Comp Class Detail | COMPANY, COUNTRY-CODE, WC-STATE, PROCESS-LEVEL, EFFECT-DATE, WC-CLASS, CA-WC-CLASS | 14 |
| WCCLASSHDR | WCH | Work Comp Class Header | COMPANY, COUNTRY-CODE, WC-STATE, PROCESS-LEVEL, EFFECT-DATE | 18 |
| WCCLASSOVR | WCR | No description in the Lawson data dictionary | COMPANY, COUNTRY-CODE, JOB-CODE, STATE-PROV | 5 |
| WCPOLICY | WCP | Workers Compensation Policy | COMPANY, WC-CODE | 8 |
| ZFNDATION | ZFN | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, CHOICE, EFFECT-DATE, SEQ-NBR | 15 |
| ZUNIONDUES | PPU | No description in the Lawson data dictionary | COMPANY, DED-CODE, SEQ-NBR | 9 |
Online screens (201)
| Screen | Description | Updates | References |
|---|---|---|---|
| HS01.1 | Time Entry Form | 1 | 11 |
| HS02.1 | Time Entry Pay Codes | 1 | 3 |
| HS03.1 | Time Entry Pay Period Dates | 1 | 3 |
| HS04.1 | Time Record Status Update | 2 | 0 |
| HS05.1 | Time Record Exception Setup | 1 | 2 |
| HS06.1 | Direct Deposit Rules | 1 | 1 |
| HS07.1 | Notification Rules | 1 | 1 |
| HS18.1 | Payroll Lock Out Rules | 1 | 4 |
| HS18.2 | Payroll Lock Out Look Up | 0 | 4 |
| HS20.1 | Time Form Inquiry | 0 | 10 |
| HS21.1 | Time Form Inquiry | 0 | 9 |
| HS22.1 | Pending Time Summary | 0 | 11 |
| HS22.2 | Direct Reports Pay Plans | 0 | 5 |
| HS22.3 | Reporting Pay Plans With Dates | 0 | 7 |
| HS23.1 | Pay Rules | 1 | 1 |
| HS34.1 | Prpendtime Edit Program | 0 | 10 |
| HS35.1 | Pending Time Records | 3 | 5 |
| HS36.1 | Pending Time Records | 3 | 20 |
| PDDG.1 | Deduction Class Selection Invoke | 0 | 1 |
| PR00.1 | Payroll Cycle Status | 2 | 1 |
| PR01.1 | Bank Account | 1 | 3 |
| PR01.2 | Bank Code | 3 | 6 |
| PR02.1 | Deduction Class | 2 | 2 |
| PR02.2 | Deduction Group | 1 | 3 |
| PR03.1 | Deduction Required Code | 2 | 10 |
| PR04.1 | Pension Funding Sources | 1 | 5 |
| PR05.1 | Deduction | 34 | 68 |
| PR05.2 | Taxable Wages Table | 1 | 2 |
| PR05.3 | Additional Vendors | 31 | 53 |
| PR05.4 | Employment Health Tax Wages | 1 | 5 |
| PR05.5 | Employment Health Tax Exemptions | 1 | 5 |
| PR05.6 | Process Level Accrual Accounts | 1 | 4 |
| PR05.7 | Process Level Expense Accounts | 1 | 5 |
| PR05.8 | ALLTAX Taxable Wage Table | 1 | 2 |
| PR06.1 | United States Tax Authority | 3 | 2 |
| PR06.2 | United States Additional EIN | 1 | 2 |
| PR06.3 | United States Minimum Wage | 1 | 1 |
| PR06.4 | State Reporting Information | 1 | 2 |
| PR06.5 | State Reporting Information | 1 | 2 |
| PR06.6 | State Reporting Information | 1 | 2 |
| PR06.7 | State Reporting Information | 1 | 2 |
| PR06.8 | State Reporting Information | 2 | 3 |
| PR06.9 | State Reporting Information | 2 | 3 |
| PR07.1 | State Reporting Information | 2 | 2 |
| PR07.2 | State Reporting Information | 2 | 2 |
| PR07.3 | State Reporting Information | 1 | 2 |
| PR07.4 | State Reporting Information | 1 | 2 |
| PR07.5 | State Reporting Information | 1 | 2 |
| PR07.6 | State Reporting Information | 2 | 2 |
| PR07.7 | State Reporting Information | 1 | 3 |
| PR07.8 | State Reporting Information | 1 | 2 |
| PR07.9 | State Reporting Information | 2 | 2 |
| PR08.1 | Canada Tax Authority | 2 | 2 |
| PR08.2 | Canada Minimum Wage | 1 | 1 |
| PR09.1 | Head Process Level | 2 | 2 |
| PR10.1 | United States Tax Levy Table | 1 | 1 |
| PR11.1 | Employee Year-End Parameters | 2 | 5 |
| PR11.2 | USERRA Year-End Parameters | 1 | 5 |
| PR11.3 | Employee HIRE Act Tax Reporting Info | 2 | 11 |
| PR11.4 | Canadian Employee Year-End Parameters | 3 | 6 |
| PR11.5 | Employee Year-End PA TCD Override | 1 | 8 |
| PR12.1 | Direct Deposit Distribution | 3 | 8 |
| PR12.2 | Direct Deposit Totals | 0 | 2 |
| PR12.3 | Automatic Deposit Maintenance | 3 | 8 |
| PR12.4 | Employee Bank Maintenance | 1 | 1 |
| PR12.5 | Original Account Number | 0 | 3 |
| PR12.6 | Employee Automatic Deposit | 52 | 67 |
| PR13.1 | Employee United States Taxes | 52 | 70 |
| PR13.2 | Employee United States Taxes | 6 | 16 |
| PR13.5 | Employee Canada Taxes | 52 | 69 |
| PR13.6 | Employee Canada Taxes | 52 | 67 |
| PR13.7 | US Tax Locations | 1 | 7 |
| PR13.8 | U.S. Tax Deduction Errors | 52 | 67 |
| PR13.9 | Employee Additional Tax Details | 52 | 67 |
| PR14.1 | Employee Deduction | 7 | 20 |
| PR14.2 | Tax Withholding Lock-In | 6 | 16 |
| PR15.1 | Deduction Speed Entry | 6 | 15 |
| PR15.2 | Employee Deduction Speed Entry | 7 | 19 |
| PR16.1 | Step And Grade Schedule | 2 | 3 |
| PR17.1 | Workers Compensation Policy | 1 | 2 |
| PR18.1 | United States Workers Compensation Classification | 2 | 3 |
| PR18.2 | Canada Workers Compensation Classification | 2 | 2 |
| PR20.1 | Pay Class | 2 | 5 |
| PR20.2 | Pay Summary Group | 5 | 6 |
| PR20.3 | Pay Summary Group Relationship | 1 | 3 |
| PR20.4 | Pay Code | 7 | 26 |
| PR20.5 | Tax Exemptions | 1 | 3 |
| PR20.6 | Tax Overrides | 1 | 2 |
| PR20.7 | Overtime Premium Expense Table | 1 | 2 |
| PR20.8 | Pay Summary Group - Pay Class Relationship | 1 | 3 |
| PR22.1 | Pay Plan Schedules | 1 | 2 |
| PR23.1 | Payroll Distribution - Employees | 1 | 9 |
| PR23.2 | Total Percent | 0 | 1 |
| PR23.3 | Payroll Distribution - Positions | 1 | 7 |
| PR24.1 | Shift Table | 2 | 7 |
| PR25.1 | United States Garnishment Types | 1 | 1 |
| PR25.2 | United States Garnishment Rules | 1 | 6 |
| PR26.1 | United States Employee Garnishment | 38 | 69 |
| PR26.2 | United States Employee Garnishment Inquiry | 3 | 17 |
| PR27.1 | Year-End Parameters | 1 | 14 |
| PR27.2 | Tax Authority Year-End Parameters | 1 | 13 |
| PR28.1 | Exception, Offset Time Record Rules | 1 | 3 |
| PR29.1 | Pension Payment Maintenance | 47 | 81 |
| PR29.2 | Roth Initial Contribution Year | 1 | 0 |
| PR30.1 | Standard Time Record | 4 | 22 |
| PR30.2 | Employee Automatic Time Record | 52 | 67 |
| PR32.1 | Employee Daily Time Entry | 40 | 81 |
| PR32.2 | Employee Daily Time Entry | 40 | 84 |
| PR33.1 | Speed Entry Setup | 40 | 79 |
| PR33.2 | Speed Entry by Number | 40 | 83 |
| PR33.3 | Speed Entry by Name | 40 | 83 |
| PR33.4 | Batch Totals | 0 | 1 |
| PR35.1 | Time Entry | 40 | 82 |
| PR35.2 | Detail Time Entry | 40 | 82 |
| PR35.3 | Speed Time Entry | 40 | 81 |
| PR35.4 | Step and Grade, Grade Range Time Entry | 40 | 81 |
| PR35.5 | Attendance Time Entry | 40 | 81 |
| PR35.6 | Activity Time Entry | 40 | 81 |
| PR35.7 | Employee Totals | 0 | 1 |
| PR35.8 | Position Time Entry | 40 | 81 |
| PR35.9 | Reason Code Time Entry | 40 | 81 |
| PR36.1 | Time Record Entry | 47 | 80 |
| PR36.2 | Totals | 0 | 1 |
| PR36.3 | Comments | 0 | 1 |
| PR36.4 | Manual Time Record Maintenance | 47 | 80 |
| PR37.1 | Batch Time Control | 40 | 79 |
| PR38.1 | Time Record Selection | 15 | 16 |
| PR39.1 | One Time Deduction | 10 | 15 |
| PR39.2 | One Time Deduction Speed | 7 | 16 |
| PR39.3 | Select Garnishment | 0 | 2 |
| PR39.4 | One Time Deduction Totals | 0 | 1 |
| PR39.5 | One Time Deduction BN Select | 0 | 3 |
| PR45.1 | Error Processing | 47 | 76 |
| PR46.1 | Canada Garnishment Types | 1 | 1 |
| PR46.2 | Canada Garnishment Rules | 2 | 5 |
| PR47.1 | Canada Employee Garnishment | 38 | 69 |
| PR47.2 | Canada Employee Garnishment Inquiry | 3 | 17 |
| PR50.1 | United States Quarterly Payment Inquiry | 0 | 9 |
| PR50.2 | United States Payment Inquiry | 0 | 8 |
| PR50.3 | Year To Date Totals | 0 | 7 |
| PR50.4 | State and Local Taxable Wages | 0 | 6 |
| PR51.1 | Pay Stub Inquiry | 0 | 9 |
| PR51.2 | Pay Stub Inquiry | 0 | 2 |
| PR52.1 | Payroll History - Year To Date | 0 | 10 |
| PR52.2 | Deduction History Detail | 0 | 1 |
| PR55.1 | Activity Inquiry | 0 | 5 |
| PR56.1 | Tax Group Code Maintenance | 1 | 1 |
| PR67.1 | State Reporting Information | 2 | 3 |
| PR67.2 | State Reporting Information | 2 | 4 |
| PR67.3 | State Reporting Information | 2 | 3 |
| PR67.4 | State Reporting Information | 2 | 2 |
| PR67.5 | State Reporting Information | 1 | 3 |
| PR67.6 | State Reporting Information | 1 | 2 |
| PR67.7 | State Reporting Information | 1 | 2 |
| PR67.8 | State Reporting Information | 1 | 2 |
| PR67.9 | State Reporting Information | 2 | 3 |
| PR68.1 | New Mexico State Report | 2 | 4 |
| PR68.2 | Not Used | 1 | 2 |
| PR68.3 | Florida | 2 | 3 |
| PR68.4 | Missouri | 2 | 3 |
| PR68.5 | Tennessee | 2 | 3 |
| PR68.6 | Nevada | 1 | 2 |
| PR68.7 | Oklahoma | 1 | 3 |
| PR68.8 | Vermont | 2 | 3 |
| PR68.9 | Michigan | 2 | 3 |
| PR69.1 | Additional Information | 1 | 3 |
| PR69.2 | Additional Information | 2 | 2 |
| PR70.1 | Payroll GL Distribution - Currency Errors | 1 | 4 |
| PR80.1 | Manual Check | 59 | 105 |
| PR80.2 | Manual Payment Print | 6 | 35 |
| PR80.3 | Manual Payment One Time Deduction | 7 | 17 |
| PR80.4 | Manual Payment | 59 | 105 |
| PR81.1 | Manual Payment Reservation | 2 | 2 |
| PR82.1 | Adjustment | 60 | 87 |
| PR82.2 | Adjustment Distributions | 1 | 9 |
| PR83.1 | United States Weeks Worked Adjustment | 1 | 3 |
| PR84.1 | Seniority Recalculation Inquiry | 2 | 11 |
| PR85.1 | Bank Account Reconciliation | 40 | 37 |
| PR85.2 | Bank Account Totals | 0 | 3 |
| PR86.1 | Payment Replacement | 3 | 8 |
| PR87.1 | 941 Information | 2 | 1 |
| PR88.1 | Payroll Hours | 1 | 5 |
| PR88.2 | Total Payroll Hours | 0 | 1 |
| PR89.1 | Payment Modeling | 40 | 72 |
| PRAM.1 | ALLTAX Tax Authority Mapping | 0 | 1 |
| PRAN.1 | Get Annual Hours Routine | 0 | 1 |
| PRAT.1 | Alltax connection test | 40 | 70 |
| PRAU.1 | Manual Check Audit Routine | 1 | 0 |
| PRBA.1 | Get Base Rate Routine | 0 | 1 |
| PRBN.1 | Payroll Cycle Benefit Edit | 0 | 7 |
| PREN.1 | Retrieve Period End Dates | 0 | 3 |
| PRSC.1 | Select Control | 0 | 5 |
| UK02.1 | Bonus Pay Table | 2 | 2 |
| UK10.1 | Pay Rate Table | 4 | 4 |
| UK10.2 | Entry Dates | 1 | 0 |
| UK10.3 | End Dates | 1 | 0 |
| UK10.4 | Pay Rate Table | 1 | 3 |
| UK52.1 | Bonus Pay Accrual History | 0 | 4 |
| UK52.2 | Bonus Pay Manual Adjustments | 1 | 0 |
| UK52.3 | Bonus Pay Totals | 0 | 1 |
| ZP10.1 | ZFNDATION Maintenance | 1 | 2 |
Batch programs (147)
| Program | Description | Updates | References |
|---|---|---|---|
| HS535 | Pending Time Record Extract | 3 | 6 |
| HS536 | Pending Time Record Purge | 4 | 6 |
| PR110 | Step And Grade Audit | 56 | 65 |
| PR113 | United States Tax Deduction Update | 53 | 68 |
| PR114 | Create Linked Deduction | 2 | 3 |
| PR115 | Deduction, Garnishment Fee, Pay Summary Grp Update | 6 | 6 |
| PR116 | Step And Grade Schedule Update | 3 | 2 |
| PR120 | Mass Pay Update | 53 | 67 |
| PR125 | Employee Wages for Employment Health Tax | 2 | 6 |
| PR127 | Year-End Parameters Copy/Delete | 4 | 11 |
| PR128 | Offset Time Record Creation | 40 | 83 |
| PR129 | Roth Plan Start Dates | 3 | 11 |
| PR130 | This program has been retired. | 1 | 0 |
| PR131 | Retroactive Pay Calculation | 41 | 85 |
| PR132 | FLSA Overtime Calculation | 41 | 84 |
| PR134 | Automatic Time Records | 41 | 86 |
| PR135 | Time Record Edit | 41 | 83 |
| PR136 | Missing Time Records | 41 | 83 |
| PR137 | Batch Time Record Update | 42 | 78 |
| PR138 | Percent of Earnings Calculation | 2 | 7 |
| PR139 | Arrears Automation | 8 | 42 |
| PR140 | Earnings and Deductions Calculation | 42 | 71 |
| PR141 | Payroll Register | 3 | 31 |
| PR142 | Consolidated Payroll Register | 1 | 10 |
| PR155 | Bank Reconciliation | 2 | 7 |
| PR160 | Payment Print | 15 | 38 |
| PR162 | Payment Register | 1 | 10 |
| PR165 | Bank Reconciliation Tape Processing | 2 | 1 |
| PR170 | Positive Pay File Creation | 2 | 8 |
| PR180 | Manual Payment Print | 12 | 37 |
| PR188 | Payroll Hours Update | 2 | 11 |
| PR189 | Gross Up Calculation | 59 | 103 |
| PR192 | Nonstandard 12th of Month Calculation | 5 | 7 |
| PR195 | Accrual Program | 54 | 83 |
| PR196 | Period Closing | 3 | 5 |
| PR197 | Payroll Close | 50 | 52 |
| PR198 | General Ledger Posting | 13 | 27 |
| PR201 | Bank Listing | 1 | 4 |
| PR204 | Funding Sources Listing | 1 | 3 |
| PR205 | Deduction Listing | 8 | 23 |
| PR206 | Tax Authority Listing | 1 | 7 |
| PR209 | Tax Reporting Groups Listing | 1 | 2 |
| PR210 | Tax Levy Table Listing | 1 | 2 |
| PR212 | Direct Deposit Account Listing | 1 | 11 |
| PR214 | Employee Deduction Listing | 1 | 12 |
| PR216 | Step And Grade Schedule Listing | 1 | 6 |
| PR218 | US Workers Compensation Classification Listing | 1 | 4 |
| PR220 | Pay Code Listing | 1 | 15 |
| PR223 | Payroll Distribution Listing | 1 | 6 |
| PR225 | United States Garnishment Rules Listing | 1 | 5 |
| PR226 | United States Employee Garnishment Listing | 30 | 64 |
| PR227 | Year-End Parameter Report | 2 | 16 |
| PR229 | Pension Participant Listing | 1 | 10 |
| PR230 | Standard Time Record Listing | 1 | 6 |
| PR239 | One Time Deduction Listing | 1 | 7 |
| PR240 | T4-T4A Slips | 2 | 21 |
| PR241 | T4-T4A XML | 2 | 21 |
| PR242 | T4-T4A Reports | 2 | 19 |
| PR243 | Releve Slips | 2 | 17 |
| PR244 | Releve Magnetic Media | 2 | 18 |
| PR245 | Releve Reports | 1 | 18 |
| PR246 | Canada Garnishment Rules Listing | 1 | 6 |
| PR247 | Canada Employee Garnishment Listing | 30 | 63 |
| PR248 | Canada Annual Reports | 1 | 9 |
| PR249 | PIER Audit Report | 1 | 15 |
| PR250 | 1099-R Form Reporting | 3 | 19 |
| PR251 | 1099-R File Creation | 3 | 18 |
| PR252 | United States Territory W-2 Form Printing | 2 | 20 |
| PR253 | 1099-R Reporting | 3 | 18 |
| PR260 | Payment Detail Listing | 1 | 17 |
| PR261 | Payment Detail Listing By Report Entity | 4 | 13 |
| PR262 | Taxable Wage CSV | 4 | 15 |
| PR265 | Year To Date Payment Report | 1 | 5 |
| PR266 | Quarterly Tax Balancing Report | 3 | 8 |
| PR270 | Employee Wage Report | 1 | 11 |
| PR271 | US Affordable Care Act | 1 | 16 |
| PR274 | Statistics Canada | 1 | 20 |
| PR275 | Deduction Report | 1 | 12 |
| PR276 | Employee Deduction Report | 1 | 14 |
| PR277 | Garnishment History Report | 2 | 17 |
| PR278 | United States Workers Compensation Report | 1 | 10 |
| PR279 | Benefit Deduction Audit Report | 1 | 10 |
| PR280 | Deduction Audit Report | 2 | 10 |
| PR281 | Manual Payment Audit Report | 1 | 4 |
| PR282 | Canada Record of Employment | 1 | 25 |
| PR283 | Employees With No Earnings | 3 | 6 |
| PR284 | Seniority Audit Report | 1 | 6 |
| PR285 | Payroll Activity Report | 1 | 6 |
| PR286 | Report on Hirings | 1 | 6 |
| PR287 | Quarterly Federal Tax Return | 5 | 16 |
| PR288 | Canada Workers Compensation Classification Listing | 1 | 4 |
| PR289 | Weeks Worked Calculation | 3 | 10 |
| PR290 | Quarterly Report | 1 | 13 |
| PR291 | Unemployment Continuation Form | 1 | 14 |
| PR292 | Quarterly Unemployment Ins | 5 | 21 |
| PR293 | Enumeration Verification | 1 | 8 |
| PR294 | United States Balancing Report | 2 | 8 |
| PR295 | Distribution History Report | 2 | 12 |
| PR296 | New Hire Reporting | 3 | 16 |
| PR297 | W-2 Forms | 4 | 28 |
| PR298 | W2c EFW2c | 1 | 6 |
| PR299 | EFW2 File Creation | 4 | 27 |
| PR300 | History Purge | 21 | 5 |
| PR313 | United States Tax Locator Deduction Purge | 2 | 3 |
| PR323 | Distribution Purge | 2 | 8 |
| PR418 | Canada Workers Compensation Report | 1 | 13 |
| PR512 | Employee ACH Distribution Interface | 55 | 68 |
| PR514 | Employee Deduction Master Load | 39 | 69 |
| PR529 | Pension Payroll Conversion | 48 | 81 |
| PR530 | Time Record Interface CSV | 43 | 80 |
| PR539 | One Time Deduction Load | 10 | 16 |
| PR560 | Payroll History Load CSV | 57 | 78 |
| PR582 | Mass Adjustment Load | 61 | 89 |
| PR597 | Employee Year-End PA TCD Override Upload | 2 | 5 |
| PR712 | Employee Bank and Bank Account Update | 3 | 1 |
| PR797 | Benefit EMP YTD Contribution Update | 3 | 4 |
| PR906 | ALLTAX Tax Code Update | 2 | 3 |
| PR910 | This program has been retired. | 1 | 0 |
| PR925 | Load Required US Federal Garnishment Rules | 2 | 2 |
| PR927 | PR27 Conversion for 2000 | 2 | 0 |
| PR999 | Payroll Year End Close | 8 | 2 |
| UK102 | Bonus Pay Update | 42 | 83 |
| UK110 | Pay Rate Table Update | 3 | 11 |
| UK141 | This program has been retired. | 1 | 0 |
| UK145 | This program has been retired. | 1 | 0 |
| UK183 | This program has been retired. | 1 | 0 |
| UK184 | This program has been retired. | 1 | 0 |
| UK201 | This program has been retired. | 1 | 0 |
| UK202 | This program has been retired. | 1 | 0 |
| UK210 | Pay Rate Table Listing | 1 | 10 |
| UK277 | This program has been retired. | 1 | 0 |
| UK330 | This program has been retired. | 1 | 0 |
| UK560 | This program has been retired. | 1 | 0 |
| ZP139 | PPH Union Dues Calc | 2 | 8 |
| ZP296 | New Hire Reporting | 2 | 18 |
| ZP529 | Payroll CA state qtr tax | 1 | 4 |
| ZP551 | Triad FSA Export Interface | 1 | 12 |
| ZP552 | Fidelity - BiWeekly | 1 | 6 |
| ZP554 | Union Dues - BiWeekly | 1 | 8 |
| ZP555 | HealthEquity Export Interface | 1 | 9 |
| ZP557 | Foundation - BiWeekly | 1 | 6 |
| ZP559 | Create MetLife Pay Confirm | 1 | 4 |
| ZP560 | PPH Medical-Dental Interfaces | 1 | 7 |
| ZP562 | Sharp Medical Export Interface | 1 | 7 |
| ZP565 | Hyatt - Legal - Monthly | 1 | 3 |
| ZP567 | Vision Enrollment | 1 | 7 |
| ZP580 | Foundation Contributions Iface | 2 | 5 |
Other tables used by Payroll programs (245)
ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ACCOMMIT, ACCOMMITX, ACTRANSEG, ACUOM, ADDRDATA, APACCRCODE, APAPIHIST, APAPPROVAL, APAUDIT, APAUTHOR, APCDISTRIB, APCINVOICE, APCOMMENTS, APCOMPANY, APCONTACT, APCPYVND, APDISCCODE, APDISTHDR, APHLDINV, APHOLDCODE, APINCCODE, APINVOICE, APMONITOR, APPAYMENT, APPJOBHIST, APPLICANT, APPROCGRP, APPROCLEV, APUSRFLDEF, APVENADDR, APVENBAL, APVENCERT, APVENCLASS, APVENGROUP, APVENLOC, APVENMAST, APVENPAY, APVNMXVAL, ARCUSTGRP, ATTENDCODE, ATTENDHIST, BENEFIT, BNACCOUNTS, BNBEN, BNCHANGE, BNCOMPANY, BNCOVDFT, BNCOVERAGE, BNEMPGRNT, BNGRPCHG, BNLIMITS, C6BANKM, C6EMDDMSTR, C6EMPADDRT, C6EMPINV, C6EPAYPARM, C6EXEMPT, C6HOUSERNT, C6INPF, C6INVEST, C6INVSELCT, C6NETWAGE, C6PRDDEF, C6PRDDTL, C6PREVEMP, C6PROJECTN, C6STATE, C6TAXGRP, CBBANKINST, CBCASHCODE, CBCHECK, CBUSER, CBUSRCLASS, CMASSIGN, CMCHANGE, CMCONTRACT, CMCONTRULE, CMEMPTRANS, CMPAYCYC, CODA, COMPHIST, CUCODES, CUCONV, CURELAT, CUSTDESC, CWASSIGN, CWCHANGE, CWCONTRACT, CWCONTRULE, CWDISTRIB, CWEMPTRANS, DEPTCODE, DEPTSEGBLK, EEADVANCE, EEAPPROVAL, EEEXPENSE, EMDEPEND, EMPBOD, EMPCODES, EMPFLEXDOL, EMPLOYEE, EMPPICKLST, EMSTATUS, EMTAMASTR, EMTATRANS, EMTATRNSUM, FBDETAIL, FBFUNDAMT, FBFUNDDTL, FBTRANS, FBYETR, FLEXPLAN, GLADDRESS, GLCHART, GLCHARTDTL, GLCODES, GLCOMMIT, GLCOMMITX, GLHISCOMBL, GLHISCOMX, GLINTCO, GLMASTER, GLNAMES, GLNLOCDTL, GLSYSTEM, GMAUDIT, GMCONTROL, GMEFFORT, GMLABDIST, GMLABDISTX, GMRETDIST, GMTRANEFRT, HISTERR, HRCTRYCODE, HRDEPBEN, HREMPRCVR, HREMPUSF, HRHISTORY, HRLTMRULE, HRSECLEV, HRSUPER, HRUSERFLDS, HRUTILITY, HRWRKSCHD, INEMPLOYEE, INSTCTRYCD, INSTREGN, JOBCODE, LPLINK, LPPENDREQ, MAINVHAND, MAMATCHTBL, MAMSGTOL, MAMTCHRULE, MILITARY, MXCATDEF, MXELEMENT, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXOBJCAT, PAACTREAS, PAASSIGNED, PABUDGET, PACLASS, PACLASSPOS, PACOMMENTS, PADICT, PADICT2, PAEEEORACE, PAEMPAPP, PAEMPAPTST, PAEMPLOYEE, PAEMPPOS, PAENCUMBER, PAERECRUIT, PAINSTRUCT, PAMEDICAL, PAPEPAUDIT, PAPOSCHG, PAPOSITION, PAPOSRULE, PASCRTY, PATHFIND, PATSTSETUP, PCODES, PCODESDTL, PERSACTHST, PERSACTION, PERSACTYPE, PERSGROUP, PGEMPLOYEE, PGSELECT, PLAN, PLANMASTER, POAOCDTL, POITEMVEN, POPOVUF, POVAGRMTHD, POVENDLOC, POVENDOR, PREMIUM, PROCUREGRP, PRPROCGRP, PRRATEHIST, PRSAGDTL, PRSAGHEAD, PRSYSTEM, PSGRELATE, PURCHORDER, PWEMPLY, PWSUPER, SUBCKPOINT, SYSRULES, SYSTEMCODE, TAEEGROUP, TAEEMASTER, TAEMPSERV, TAEMPTRANS, TAENROLL, TAPAYROLL, TAPLAN, TAREASCODE, TASERVCODE, TASERVICE, TASTRUCTUR, TATRANSUM, TERMS, TMLEAVE, TMLEAVEDTL, TPPARAM, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, VESTHOURS, WFBOD, WFSETUP