This appendix discusses:
PeopleSoft Payroll for North America reports: A to Z.
PeopleSoft Payroll for North America selected reports.
Note. For samples of these reports, see the Portable Document Format (PDF) files that are published with your online documentation.
See Also
PeopleTools: PeopleSoft Process Scheduler PeopleBook
These tables list the Payroll for North America reports, sorted alphanumerically by report ID. If you need more information about a report, refer to the report details at the end of this appendix or in the documentation of the related business process in this PeopleBook.
This section discusses:
Direct deposit reports (DDP).
Payroll reports (PAY or FG).
Tax reports (TAX).
Note. The special numerical series in the tax reports are
as follows:
TAX000–099: Related to quarterly and periodic tax reporting.
TAX100-199: Related to tax status, exemption, eligibility.
TAX500–599: Typically run on-time for a specific purpose to update
or create employee tax balances.
TAX700-799: Tax tables.
TAX800-899: Processes to create files for states that must submit quarterly
state wage listings on electronic/magnetic media.
TAX900-999: Related to annual wage reporting processes.
Note. This appendix does not document reports that you run only at year-end. You can find documentation of year-end reports and processes in the Year-End Processing guide provided with Payroll Tax Update documentation at year-end.
See Also
Accessing Year-End Processing Instructions
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
DDP001 Create Direct Deposit Transmit |
Creates an electronic transmittal file to transfer payroll funds directly into a U.S. employee's bank account. |
|
RUNCTL_DDP001 |
DDP001CN Create Direct Deposit Transmit |
Creates an electronic transmittal file to transfer payroll funds directly into a Canadian employee's bank account. |
Payroll for North America, Payroll Processing CAN, Create Direct Deposits, Create Direct Deposit File, Create Direct Deposit File |
RUNCTL_DDP001CN |
DDP002 Direct Deposit Register |
Produce a report that lists all direct deposits for employees in each company in the organization. |
|
RUNCTL_PAYINIT RUNCTL_PAYINIT2 |
DDP003 Payroll Advice Print - US |
A template for printing U.S. paycheck and pay stub information onto direct deposit advice forms using the SQR method. Run this report after you perform pay confirmation for a payroll run. |
|
RUNCTL_CHK_ADV1 |
DDP003CN Payroll Advice Print - Canada |
A template for printing Canadian paycheque and pay stub information onto direct deposit advice forms using the SQR method. Run this report after you perform pay confirmation for a payroll run. |
Payroll for North America, Payroll Processing CAN, Create Direct Deposits, Print Advice Forms, Print Advice Forms |
RUNCTL_CHK_ADV |
DDP004 Payroll Advice Register |
Produce a report of payroll amounts paid directly into the employee's bank account as direct deposits. This report is similar to PAY004 - Payroll Check Register. |
|
RUNCTL_PAYINIT RUNCTL_PAYINIT2 |
DDP005 Direct Deposit Prenotification |
Produces a report that displays employees who will have their pay deposited directly into their bank account for the first time. |
|
RUNCTL_PAYINIT2 |
DDP006 Direct Deposit Prenote Memo |
Produces a memo to each employee who has added a new direct deposit. The memo lists the direct deposit information for verification purposes. |
|
RUNCTL_PAYINIT2 |
PYDDACAN Print Can Direct Deposit Advc |
A template for printing Canadian paycheque and pay stub information onto advice forms in PDF. The report also creates self-service advice forms for display in PDF in the ePay self-service View Paycheck transaction. Run this report after you perform pay confirmation for a payroll run. |
Payroll for North America, Payroll Processing CAN, Create Direct Deposits, Create Advice PDF Forms, Create Advice PDF Forms |
RUNCTL_CHK_ADV_EP |
PYDDAUSA Print US Direct Deposit Advice |
A template for printing U.S. paycheck and pay stub information onto advice forms in PDF. The report also creates self-service advice forms for display in PDF in the ePay self-service View Paycheck transaction. Run this report after you perform pay confirmation for a payroll run. |
|
RUNCTL_CHK_ADV1_EP |
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
BUD002 Reconciliation |
Provides reconciliation details. |
|
RUNCTL_FISCAL_YR |
FG1514 Military Deposit OPM-1514 Service Deposit Worksheet |
Creates an OPM Military Deposit worksheet for service credit payments for post-1956 military service. |
Payroll for North America, Employee Pay Data USF, Military Deposits, Military Deposit OPM-1514 Rpt, Military Deposit OPM-1514 Report |
RUN_FG1514 |
FGPY001 RITS Interface |
Produce a summary report of the output file for The Office of Personnel Management (OPM) that records deduction distributions for retirement Civil Service Retirement System (CSRS), Federal Employee Retirement System (FERS), Federal Employee Health Benefits (FEHB), health insurance, and Federal Employee Group Life Insurance. |
Payroll for North America, Payroll Distribution, Additional Integrations USF, RITS Interface, Reserve Bank Information and Transfer System Interface |
RUN_FGPY001 |
FGPY003 Treasury Interface and Federal Reserve Bond Summary Report |
Produces a summary report of the treasury interface data |
Payroll for North America, Payroll Distribution, Additional Integrations USF, Treasury/FRB Bond Interface, Treasury/Federal Reserve Bank Bond Interface |
RUN_FGPY003 |
FGPY004 ECS Interface (electronic certification system interface) |
Creates a ECS interface file for off cycle disbursements. |
Payroll for North America, Payroll Distribution, Additional Integrations USF, ECS Interface, Electronic Certification System Interface |
RUN_FGPY004 |
FGPY012 Military Deposits Closed Accounts |
Creates an OPM Military Deposit worksheet for service credit payments for post-1956 military service for all closed accounts. |
Payroll for North America, Employee Pay Data USF, Military Deposits, Military Deposit Closed Accts, Military Deposit Closed Accts |
RUN_FGPY012 |
FGPY013 Leave Accruals |
Lists employee accrual detail for each earnings accrual class, including leave accrual, usage, transfer, and adjustment activity. |
Payroll for North America, Payroll Processing USF, Pay Period Reports, Leave Accruals, Leave Accruals Report |
PRCSRUNCNTL |
FGPY021 Semi-Annual Headcount |
Produces a report with details of life insurance and health benefits withholding contribution data for the CSRS and FERS. Additionally, the report provides aggregate base salary amounts for each category of CSRS and FERS coverage. |
Payroll for North America, Payroll Processing USF, Pay Period Reports, Semi-Annual Headcount, Semi-Annual Headcount Report |
GVT_RUN_FGPY021 |
FGPY023 FEFFLA Summary (Federal Employees Family Friendly Leave Act summary) |
Produces a report of FEFFLA hours, both paid and nonpaid, that the employee took during the requested calendar year and during the employee's Family Medical Leave Act (FMLA) year. |
Workforce Administration, Leave Administration USF, Reports, FEFFLA, FEFFLA |
RUNCTL_FEFFLA |
FGPY024 FEFFLA Limit (Federal Employees Family Friendly Leave Act limit) |
Produces a report of employees who have used more than 480 FEFFLA hours of nonpaid entitlement in their FMLA year. |
Workforce Administration, Leave Administration USF, Reports, FEFFLA, FEFFLA |
RUNCTL_FEFFLA |
FGPY025 FMLA History Summary (Family Medical Leave Act history summary) |
Produces a report of FMLA hours that the employee took, both paid and nonpaid, in the requested calendar year and the hours taken in the employee's FMLA year. |
Workforce Administration, Leave Administration USF, Reports, FMLA, FMLA |
RUNCTL_FGFMLA |
FGPY026 FMLA Summary (Family Medical Leave Act summary) |
Produces a report of FMLA hours taken in the requested calendar year and the hours taken in the employee's FMLA year, using the employee's FMLA and FEFFLA accrual class ledger to accumulate paid and nonpaid FMLA hours taken. |
Workforce Administration, Leave Administration USF, Reports, FMLA, FMLA |
RUNCTL_FGFMLA |
FGPY027 FMLA Limit (Family Medical Leave Act limit) |
Produces a report of all employees who have used more than 480 hours of nonpaid entitlement in their FMLA year. |
Workforce Administration, Leave Administration USF, Reports, FMLA, FMLA |
RUNCTL_FGFMLA |
FGPY028 Leave Acceptance Notifications |
Prints leave acceptance notifications for employees whose donor or recipient applications have been approved. See (USF) Managing Leave. |
Workforce Administration, Leave Administration USF, Reports, Leave Acceptance Notifications, Leave Acceptance |
GVT_RUNCTL_LEAVE |
FGPY029 Leave Bank Participants |
Produces a listing of leave bank participants. See (USF) Managing Leave. |
Workforce Administration, Leave Administration USF, Reports, Leave Bank Participants, Leave Bank Participants Report |
GVT_RUNCTL_LEAVE |
FGPY030 Leave Transfer Participants |
Produces a listing of leave transfer participants. See (USF) Managing Leave. |
Workforce Administration, Leave Administration USF, Reports, Leave Transfer Participants, Leave Transfer Participants Report |
GVT_RUNCTL_LEAVE |
FGPY031 Leave Denial Notifications |
Prints leave denial notifications for employees whose donor or recipient applications have been denied. See (USF) Managing Leave. |
Workforce Administration, Leave Administration USF, Reports, Leave Denial Notifications, Leave Denial Notification |
GVT_RUNCTL_LEAVE |
FGSF1150 Leave Audit SF1150 |
Produces a leave audit report, which the system prepares for the employee upon separation or transfer from an agency. Use this information to validate the leave hours that you forward to the gaining agency, or that you pay out to employees if they are leaving the federal government. |
Payroll for North America, Payroll Processing USF, Produce Payroll, Leave Audit SF1150 Report, Leave Audit SF1150 Report |
RUNCTL_FGSF1150 |
GMTEC002 GM Time & Effort Certification |
Produces a report that Higher education institutions use to complete the A–21 Certification requirements for grants. |
Payroll for North America, Payroll Distribution, Additional Integrations, Time/Effort Certification Rpt, Time/Effort Certification Report |
RC_GM_TE |
PAY001 Deductions Register |
Generate the PAY001 register that lists the amount of money deducted from each employee's paycheck for general deductions, garnishments, and benefits, including sales taxes, as of the end of a pay period. |
|
RUNCTL_PAYINIT2 |
PAY001CN Deduction Register |
Generate the PAY001CN register that lists the amount of money deducted from each employee's paycheque for general deductions, garnishments, and benefits, including sales taxes, as of the end of a pay period. |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Deduction Register, Deduction Register |
RUNCTL_PAYINIT |
PAY002 Payroll Register |
Produces a report of paycheck data by name, employee ID, and department ID for all employees who receive a paycheck for a pay run and pay calendar. |
|
RUNCTL_PAYINIT RUNCTL_PAYINIT2 |
PAY003 Pay Check Print - US |
A template for printing U.S. paychecks and accompanying check stubs on check stock using the SQR method. Run this report after you perform pay confirmation for a payroll run. |
|
RUNCTL_CHK_ADV1 |
PAY003CN Pay Cheque Print - Canada |
A template for printing Canadian paycheques and accompanying cheque stubs on cheque stock using the SQR method. Run this report after you perform pay confirmation for a payroll run. |
Payroll for North America, Payroll Processing CAN, Produce Cheques, Print Pay Cheques, Print Pay Cheques |
RUNCTL_CHK_ADV |
PAY004 Check Register |
Produces a report of all checks, in check number order, written in the pay period for each company in the organization. |
|
RUNCTL_PAYINIT RUNCTL_PAYINIT2 |
PAY005 Cost Center Report |
Produces a report of employee hours and earnings, sorted by cost center. Reports information for each company in the organization, sorted by pay period. See PAY005 - Cost Center. |
|
RUNCTL_PAYINIT RUNCTL_PAYINIT2 |
PAY006 Other Earnings Register |
Produces a report of detailed wages other than regular and overtime earnings, such as automobile allowances or expense reimbursements. |
|
RUNCTL_PAYINIT RUNCTL_PAYINIT2 |
PAY007 Deductions in Arrears |
Produces a report of all deductions in arrears that you take from employee paychecks at a date later than the regularly scheduled pay period. |
|
RUNCTL_PAYINIT RUNCTL_PAYINIT2 |
PAY008 Deductions Not Taken |
Produces a report of employee deductions not were not taken for the pay period. Also shows the deductions and amounts that went into arrears. |
|
RUNCTL_PAYINIT |
PAY009 Paysheets |
Print the paysheets created in the Create Paysheet process (PSPPYBLD). See PAY009 - Paysheets. |
|
RUNCTL_PAYINIT2 |
PAY010 Employees Not Processed |
Produces a report of employee hours and earnings that were not processed for the pay period. |
|
RUNCTL_RPT_RUNID |
PAY011 Payroll Error Messages |
Provides a list of the system error messages generated during the COBOL payroll processes — calendar creation, paysheet creation, pay calculation and pay confirmation. |
|
RUNCTL_RPT_RUNID |
PAY013 Employee Earnings Snapshot |
Produces a report of detailed information for U.S. employees as of the date that you specify. |
|
RUNCTL_PAY013 |
PAY013CN Employee Earnings Snapshot |
Produces a report of detailed employee information for Canadian employees as of the date you specify. |
Payroll for North America, Periodic Payroll Events CAN, Balance Reviews, Employee Earnings Snapshot Rpt, Employee Earnings Snapshot Report |
RUNCTL_PAY013CN |
PAY014 Employee Earnings Record |
Prints an earnings summary record for each U.S. employee that is selected as of the date specified. |
|
PRCSRUNCNTRL |
PAY014CN Employee Earnings Record |
Prints an earnings summary record for each Canadian employee that is selected as of the date specified. |
Payroll for North America, Periodic Payroll Events CAN, Balance Reviews, Employee Earnings Record Rpt, Employee Earnings Record Rpt |
PRCSRUNCNTL |
PAY015A Check Reconciliation |
Reconciles the checks cleared at your financial institution and inserts data into a temporary Check Reconciliation file. It also produces an error listing that shows checks with the wrong net amount, checks flagged as already being cashed, and checks flagged as having been reversed. See Reconciling Checks. |
|
RUNCTL_PAYINIT RUNCTL_PAYINIT2 |
PAY015B Check Reconciliation |
Produce a report that lists the outstanding check entries in the temporary Check Reconciliation file. See Reconciling Checks. |
|
PRCSRUNCNTL |
PAY017 Paysheets Distributed Earnings |
Print the paysheets created in the Create Paysheet process (PSPPYBLD) for distributed earnings. PAY017 is similar to PAY009 (Print Paysheets), but it scans employee records for paylines related to distributed earnings. |
|
RUNCTL_PAYINIT2 |
PAY018 Payroll Summary |
Produces a summary of U.S. paycheck detail by Run ID. It includes amounts, earnings, employee deductions, employer contributions, employee and employer taxes. |
|
RUNCTL_PAYINIT4 |
PAY018CN Payroll Summary |
Produces a summary of Canadian paycheque detail by Run ID. It includes amounts, earnings, employee deductions, employer contributions, employee and employer taxes. |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Payroll Summary, Payroll Summary Report |
RUNCTL_PAY018CN |
PAY021 Employer Benefit Contribution |
Produces a report of U.S. employer-paid benefits, sorted by plan type. It includes both taxable and nontaxable amounts for the selected pay period and year-to-date (YTD) month, quarter, and year. |
|
RUNCTL_PAYINIT2 |
PAY021CN Employer Benefit Contribution |
Produces a report of Canadian employer-paid benefits, sorted by plan type. It includes both taxable and nontaxable amounts for the selected pay period and YTD month, quarter, and year. |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Employer Benefit Contributions, Employer Ben Contributions Report |
RUNCTL_PAYINIT |
PAY025 Balance Adjustment |
Produces a listing of balance adjustments that were processed through the Balance Adjustment pages for US employees. |
|
RUNCTL_PAY025 |
PAY025CN Balance Adjustments |
Produces a listing of balance adjustments that were processed through the Balance Adjustment pages for Canadian employees. |
Payroll for North America, Periodic Payroll Events CAN, Balance Adjustments, Balance Adjustment Report, Balance Adjustment Report |
RUNCTL_PAY025CN |
PAY033 Imputed Income Adjustment |
Provides a detailed listing of the imputed income adjustments generated in the Imputed Income process (PSPIMRUN). |
|
RUNCTL_PAYINIT2 |
PAY034 Presheet Audit |
Provides a detailed error listing of set up data (employee, benefit, deductions) that can cause errors in the Create Paysheet process (PSPPYBLD). |
|
RUNCTL_PRESHEET |
PAY035 Paysheet Records Audit Prior to Calc Pay (paysheet records audit prior to calculate pay) |
Provides a detailed error listing (by company, pay group, and pay end date) of information that might cause problems during the Pay Calculation process (PSPPYRUN). It check employment taxes, and identifies orphan records. This report is usually run after the paysheets are created, and before the calculation. Also as a troubleshooting tool, it can be run after calculation to help identify errors. |
|
RUNCTL_AUDIT |
PAY036 Paysheet Records Audit Prior to Confirm |
Provides a detailed listing (by company, calendar year, pay group, month code, pay end date, and employee ID) of information that might cause problems during the Pay Confirmation process. It checks for potential duplicate keys, no active job record found, prior unconfirmed payroll runs, and outstanding off-cycle checks. This reports is usually run before confirm. Also as a troubleshooting tool, it can be run after confirm to help identify errors. |
|
RUNCTL_AUDIT |
PAY039 HR Accounting Line Report (human resources accounting line report) |
Produces a listing of the accounting line entries that are created by running the GL Interface process. |
Payroll for North America, Payroll Distribution, GL Interface Reports, HR Accounting Line, HR Accounting Line Report |
RUN_PAY039 |
PAY040 Child Support – EFT |
Creates an electronic transmittal file to transfer garnishment payments directly to the state disbursement unit. It also produces output in PDF format. |
Payroll for North America, Payroll Processing USA, Create Direct Deposits, Create Child Support EFT, Create Child Support EFT |
RUNCTL_PAY040 |
PAY050 Allocation By Establishment |
Produces a listing of tip allocation information for establishments. |
Payroll for North America, Periodic Payroll Events USA, Tip Allocation, Allctn by Establishment Report, Tip Allocation by Establishment Report |
RUNCTL_TIPS_ALLOC |
PAY051 Allocation By Employee |
Produces a listing of tip employees, sorted by establishment. |
Payroll for North America, Periodic Payroll Events USA, Tip Allocation, Allocation by Employee Report, Tip Allocation by Employee Report |
RUNCTL_TIPS_ALLOC |
PAY052 Allocation Earnings |
Produces a report of directly tipped employees and their YTD and pending allocated tips. This is a point-in-time report of all employees with allocated tips, sorted by company. |
Payroll for North America, Periodic Payroll Events USA, Tip Allocation, Balance Verification Report, Balance Verification Report |
RUNCTL_TIP_PAY |
PAY055 Employee Receipts |
Produces a report of gross receipts for each employee in a selected time period, sorted by input date. Also provides subtotals for each tip establishment and total receipts for the company. |
Payroll for North America, Periodic Payroll Events USA, Tip Allocation, Employee Receipt Report, Employee Receipt Report |
RUNCTL_TIP_PAY055 |
PAY056 Final Check Request |
Produces a report of final check requests for which an employee's final check processing status is either N (not processed) or P (loaded to paysheets). |
|
RUNCTL_PAY056 |
PAY057 Final Check Reconcile Report |
Produces a report of reconciled employees who have final checks processed, based on pay calendar information that you specify with data from their Employment records. A warning message appears in the report when an employee is not really terminated, but had a final check produced. |
|
RUNCTL_PAYINIT |
PAY058 U.S. Savings Bond Suspensions |
List employees who have one or more bond purchases that have been suspended due to reaching the annual bond purchase limit. When the Show Suspension Detail check box is selected, the report lists the complete bond purchase history for employees with one or more suspended bond purchases. When the Show Suspension Detail check box is not selected, the report lists only the specific bond purchases that have been suspended. |
|
RUNCTL_PAY058 |
PAY060 Payroll Accounting Line |
Print details of payroll transactions that interface with PeopleSoft General Ledger or Commitment Control. |
Payroll, Payroll Distribution, GL Interface Reports, Payroll Accounting Line, Payroll Accounting Line Report |
RUN_PAY060 |
PAY100CN Statistics Canada, Non-Educational Institutions |
Prints an accepted report format for the Survey of Employment for Non-Educational Institutions, Payrolls, and Hours, that is required by the Canadian Labour Division of Statistics. It conforms to Canadian wage reporting requirements. See (CAN) PAY100CN - Statistics Canada, Non-Educational Institutions. |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Stats Can Non-Educ Institute, Statistics Canada Non-Educational Institutions Report |
RUNCTL_PAY100CN |
PAY101CN ROE Print (Record of Employment print) |
Prints ROE data onto preprinted forms that are supplied by Human Resources Development Canada (HRSDC). You must use either line printer (LP) or HP format. |
Payroll for North America, Periodic Payroll Events CAN, Record of Employment Forms, Print ROEs, Print ROEs |
RUNCTL_PAY101CN |
PAY102CN Workers Compensation |
Produces a report for Workers Compensation Board (WCB) payroll reporting. It meets Canadian requirements. |
Payroll for North America, Regulatory Reports CAN, Workers Comp Assessments, Workers Comp Assessments Report |
RUNCTL_PAY102CN |
PAY103CN Overtime Bank |
Produces a report that includes the union or nonunion employees for a date range that you specify, sorted by department, and lists the total number of overtime hours for each employee, sorted by employment record number for Canadian employees. |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Overtime Bank, Overtime Bank Report |
RUNCTL_PAY103CN |
PAY104CN Business Payrolls Survey (BPS) |
Creates a BPS electronic data report (EDR) file for transmission to Statistics Canada and a summary report for your reference. The system produces the transmission file in accordance with the format that is provided by Statistics Canada. See (CAN) PAY104CN - Business Payrolls Survey (BPS) Electronic Data Transmission File. |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Business Payrolls Survey File, Business Payrolls Survey File |
RUNCTL_PAY104CN |
PAY110CN Statistics Canada, Educational Institutions |
Prints an. accepted report format for the Survey of Employment for Educational Institutions, Payrolls, and Hours, that is required by the Canadian Labour Division of Statistics. It conforms to Canadian wage reporting requirements. See (CAN) PAY110CN - Statistics Canada, Educational Institutions. |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Stats Can Educ Institute, Statistics Canada Educational Institute Report |
RUNCTL_MO_YR_PAY |
PAY124CN ROE Mass Create (Record of Employment mass create) |
Creates ROE data for a range of dates for Canadian employees. |
Payroll for North America, Periodic Payroll Events CAN, Record of Employment Forms, Create Mass ROE Data, Create Mass ROE Data |
RUNCTL_FRMTHRU_PAY |
PAY125CN ROE Summary (Record of Employment summary) |
Produces a summary report of ROE Data records that have a ROE status of hold, complete, delete, or generate. The system deletes all ROE Data records that have a ROE status of delete. |
Payroll for North America, Periodic Payroll Events CAN, Record of Employment Forms, ROE Summary Report, ROE Summary Report |
RUNCTL_PAY125CN |
PAY126CN ROE Print Exceptions (Record of Employment print exceptions) |
Produces an exception report of ROE errors that are detected during the ROE Print SQR Report process (PAY101CN). |
Payroll for North America, Periodic Payroll Events CAN, Record of Employment Forms, ROE Exceptions Report, ROE Exceptions Report |
RUNCTL_PAY126CN |
PAY131CN Canada Savings Bond Purchase |
Produces a report of employees' Canada Savings Bond purchases through payroll deduction. |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Canada Savings Bond Purchase, Canada Savings Bond Purchase Report |
RUNCTL_PAY131CN |
PAY132CN Payroll Savings Create File |
Creates a Canada Payroll Savings electronic data transmission file and a Transmission Summary report for your reference. The system produces the transmission file in accordance with the format that is provided by the Bank of Canada. |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Canada Payroll Savings File, Canada Payroll Savings File |
RUNCTL_PAY132CN |
PAY300RT Retro Pay Request and Trigger |
Creates a summary of retro requests that includes the request type (job or additional pay), the employee's ID, name, status, and pay group, the retro programs associated with the pay group, and the retro request's status, effective date, and process end date. You can optionally include the trigger details for each retro request. Trigger details include the effective date, the field that changed, and the field's before and after values. |
Payroll for North America, Retroactive Payroll, Retro Pay, Reports, Retro Pay Request and Trigger, Retro Pay Request and Trigger Report |
RUN_PAY300RT |
PAY301RT Retro Pay All Calculated |
Produces a detailed report of the retroactive pay calculation, sorted and subtotaled according to the sort option you select. You can use this report as a printed audit report. The same information is available online. |
Payroll for North America, Retroactive Payroll, Retro Pay, Reports, Retro Pay Calculations, Retro Pay Calculations Report |
RUN_PAY301RT |
PAY302RT Retro Pay Summary |
Produces a retro pay summary broken down by request type, with a grand total for all request types. The summary shows the amounts used in the retro pay determination: the old earnings amount, new earnings amount, any override amount, prior retro paid, and the final retro pay amount. |
Payroll for North America, Retroactive Payroll, Retro Pay, Reports, Retro Pay Summary, Retro Pay Summary |
RUN_PAY302RT |
PAY303RT Retro Pay Terminations Report |
Produces a report of terminated employees for whom the system has calculated retro pay. This report lists the same information as PAY301RT. Note. Before generating this report, you must run the Retroactive Pay Load Paysheets (PSPRPPSH) COBOL SQL Process with Process Terminated Employees selected on the Load Retro Pay to Paysheets page. This is how the system sets the flag used to identify terminated employees. The Retroactive Pay Load Paysheets process sets the terminated employee flag only for employees who were terminated on or before the pay end date. Therefore, employees who terminated after the pay end date do not appear on the report. |
Payroll for North America, Retroactive Payroll, Retro Pay, Reports, Retro Pay Terminations, Retro Pay Terminations Report |
RUN_PAY303RT |
PAY304RT Retro Pay Message Report |
Provides complete message text for the messages produced by retro pay processes, and counts the number of messages. |
Payroll for North America, Retroactive Payroll, Retro Pay, Reports, Retro Pay Messages, Retro Pay Messages Report |
RUN_PAY304RT |
PAY305RT Load Paysheet Trans (load paysheet transactions) |
If run after the Load Paysheets (PYLOAD), the report lists transactions that are loaded from other applications or from rapid entry paysheets. If run before the Load Paysheets process (PSPPYBLD), the report lists transactions that originated in other applications that are being loaded into paysheets. See (USF) Managing Leave. |
|
RUNCTL_PSHUPLD |
PAY306RT Retro Pay Interest |
(USF) Produces a report of Retro Interest Pay by employee name, national ID, and interest earnings for employees who have interest earnings over the limit in the reporting year. |
Payroll for North America, Retroactive Payroll, Retro Pay, Reports, Retro Pay Interest Limit, Retro Pay Interest Limit Report |
RUNCTL_PAY306RT |
PAY701 Bank Table |
Produces a listing of Bank table information, which is an edit table for Federal Reserve transit numbers. It identifies every banking institution where your company has accounts that are established for paychecks and direct deposits. Note. (CAN) For Canadian reports, the three-digit bank ID is reported in the Bank/Transit # (bank/transit number) field and the branch ID is reported in the Branch field. |
Set Up HRMS, Common Definitions, Banking, Bank/Branch Report, Bank/Branch Report |
PRCSRUNCNTL |
PAY702 Company Table - GL Data |
Produces a listing of the GL Data on the Company table, where you establish the individual companies in the corporate structure. This report is a companion to PER707 (the Company Table - General Data report), which lists the payroll-related general ledger information in the Company table. |
Set Up HRMS, Product Related, Payroll for North America, GL Interface, Company GL Data Report, Company Report |
PRCSRUNCNTRL |
PAY703 General Deduction/Deduction Frequency Table |
Produces a listing of the General Deduction/Deduction Frequency table, which contains payroll deductions that do not fit into a category that is covered by a benefit table, such as United Way, union dues, or parking fees. |
Set Up HRMS, Product Related, Payroll for North America, Deduction Table Reports, General Deduction/Frequency, General Ded/Frequency Report |
PRCSRUNCNTL |
PAY704 Deduction/Deduction Frequency Table |
Produces a listing of the Deduction/Deduction Frequency table, which contains deduction priority, tax effect, and frequency of both benefit and non-benefit deductions. |
Set Up HRMS, Product Related, Payroll for North America, Deduction Table Reports, Deduction/Frequency, Deduction/Frequency Report |
PRCSRUNCNTL |
PAY705 Deduction Classes |
Produces a listing of the Deduction table in two parts; you must request each report separately by ID number. 705A contains processing the GL information for deduction classes. PAY705B contains the effect of deduction classes on taxes. |
Set Up HRMS, Product Related, Payroll for North America, Deduction Table Reports, Deduction Class, Deduction Class Report |
PRCSRUNCNTL |
PAY708 Shift Table |
Produces a listing of the Shift table, which contains effective dates, rates and factors. See PAY708 - Shift Table. |
Set Up HRMS, Product Related, Payroll for North America, Comp/Earnings Table Reports, Shift, Shift Report |
PRCSRUNCNTL |
PAY709 Wage Loss Plan Table |
Produces a listing of the Wage Loss Plan table for Canadian employers. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Wage Loss Plan CAN, Wage Loss Plan Report |
PRCSRUNCNTL |
PAY710 ChartField Transaction Report |
Produces a listing of the ChartField transaction Account Code table. IT is used as an edit table for paysheet processing. |
Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Transaction Report, ChartField Transaction Report |
PRCSRUNCNTL |
PAY711 Pay Group Table |
Produces a listing of the Pay Group table, which contains effective dates, and other processing characteristics from the Pay Group table. |
Set Up HRMS, Product Related, Payroll for North America, Comp/Earnings Table Reports, Pay Group, Pay Group Report |
PRCSRUNCNTL |
PAY712 Earnings Table |
Produces a list of the Earnings table, which contains earnings types and their payroll characteristics. This report comes in three parts; you must request each report separately by ID number. 712A and 712B contain information on the USA tax effects related to earnings. 712C contains the Canadian requirements for earnings types. |
Set Up HRMS, Product Related, Payroll for North America, Comp/Earnings Table Reports, Earnings, Earnings Report |
PRCSRUNCNTL |
PAY713 Special Accumulator Table |
Produces a listing of the Special Accumulator table, which is an edit table for payroll processing. It groups together earnings/deduction to be use in the calculation of deduction amounts, such as deductions that are stated as a percent of gross (for example, 401[k]). |
Set Up HRMS, Product Related, Payroll for North America, Comp/Earnings Table Reports, Special Accumulator, Special Accumulator Report |
PRCSRUNCNTL |
PAY714 Pay Calendar Table |
Produces a listing of the Pay Calendar table, which contains the cycles that you create for payroll processing by pay group. Each entry in the table corresponds to a pay period for a pay group. |
Set Up HRMS, Product Related, Payroll for North America, Comp/Earnings Table Reports, Pay Calendar, Pay Calendar Report |
PRCSRUNCNTL |
PAY715 Garnishment Rules Table |
Produces a listing of the Garnishment Rules table, sorted by state. It lists rules in three sections—(1) rule description and exemption variables, (2) formula details, and (3) rule references. |
Set Up HRMS, Product Related, Payroll for North America, Garnishment Table Reports, Garnishment Rules, Garnishment Rules Report |
PRCSRUNCNTL |
PAY715CN Garnishment Rules Table |
Produces a listing of the Garnishment Rules table, sorted by province and territory. |
Set Up HRMS, Product Related, Payroll for North America, Garnishment Table Reports, Garnishment Rules CAN, Garnishment Rules Report |
PRCSRUNCNTL |
PAY716 Disposable Earnings Definition |
Produces a listing of the Disposable Earnings Definition table, where you define disposable earnings that are subject to garnishment and garnishment exemption parameters. |
Set Up HRMS, Product Related, Payroll for North America, Garnishment Table Reports, Disposable Earnings Definition, Disposable Earnings Defn Rpt |
PRCSRUNCNTL |
PAY717 Earnings Program Table |
Produces a list of Earnings Program table, where you specify benefit plan and deductions data. |
Set Up HRMS, Product Related, Payroll for North America, Comp/Earnings Table Reports, Earnings Program, Earnings Program Report |
PRCSRUNCNTL |
PAY718 Tax Location Table |
Produces a listing of tax location data by location from the Tax Location table. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Tax Location, Tax Location Report |
PRCSRUNCNTL |
PAY719 Garnishment Proration Report |
Produces a listing of the Garnishment Proration table, which is sorted by court ID of employees whose garnishment amounts were prorated. |
|
RUNCTL_PAY719 |
PAY720 Garnishment Proration Rule Listing |
Produces a listing of the Garnishment Proration Rule Listing table, which contains proration rules from the Garnishment table. |
Set Up HRMS, Product Related, Payroll for North America, Garnishment Table Reports, Garnishment Proration Rules, Garn Proration Rules Report |
PRCSRUNCNTL |
PAY750 Tip Establishment Table |
Produces a listing of the Tip Establishment table, where it displays data related to allocating tips to tipped employees. |
Set Up HRMS, Product Related, Payroll for North America, Tip Allocation, Tip Establishment Report, Tip Establishment Report |
PRCSRUNCNTL |
PAY751 Final Check Program Table |
Provides a listing of the Final Check Program table, which contains processing rule definitions for earnings, leave accruals, and deductions. |
Set Up HRMS, Product Related, Payroll for North America, Comp/Earnings Table Reports, Final Check Program, Final Check Program Report |
RUNCTL_PAY751 |
PAY752 Company ChartField Mapping |
Produces a listing of the Company Chartfield Mapping table for all of the human resources (HR) ChartKeys and their equivalent general ledger accounts and department IDs. |
Payroll for North America, Payroll Distribution, GL Interface Reports, Company ChartField Mapping, Company ChartField Mapping Report |
RUN_PAY752 |
PAY760 Combination Code |
Produces a listing of the Combination Code table which displays all valid combinations. |
SetUp HRMS, Common Definitions, ChartField Configuration, Combination Code Report, Combination Code Report |
PRCSRUNCNTL |
PAYGL01 Payroll General Ledger Interface |
For employers using the GL Interface process, this produces accounting lines for PeopleSoft General Ledger. This does not produce a report. |
Payroll for North America, Payroll Distribution, Prepare GL Information, Non-Commit Accounting Info, Non Commitment Accounting Information |
RUNCTL_PAYGL01 |
PAYVNDR AP Vendor Listing (accounts payable vendor listing) |
Produces a listings of the AP Vendor Listing table, which displays all vendors, address and other information up to a given date. |
Payroll for North America, Payroll Distribution, Accounts Payable Information, AP Vendor Listing, AP Vendor Listing |
RUNCTL_PAYVNDR |
PYCHKUSA Print US Checks |
A template for printing U.S. paychecks and accompanying check stubs in PDF using BI Publisher. The report also creates self-service paychecks for display in PDF in the ePay self-service View Paycheck transaction. Run this report after you perform pay confirmation for a payroll run. |
|
RUNCTL_CHK_ADV1_EP |
PYCHQCAN Print Canadian Cheques |
A template for printing Canadian paycheques and accompanying cheque stubs in PDF using BI Publisher. The report also creates self-service paycheques for display in PDF in the ePay self-service View Paycheck transaction. Run this report after you perform pay confirmation for a payroll run. |
Payroll for North America, Payroll Processing CAN, Produce Cheques, Create PDF Paycheques, Create PDF Paycheques |
RUNCTL_CHK_ADV_EP |
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
TAX001 Tax Deposit Summary |
Produces pay period details of federal, state, and local taxes that are withheld from employees, and liabilities incurred for employer-paid taxes. |
Payroll for North America, Pay Period Tax Reports USA, Tax Deposit Summary, Tax Deposit Summary Report |
RUNCTL_PAYINIT2 |
TAX002LC Quarterly Local Tax Summary - Employee Detail |
Produce a summary report of employee QTD local wages and withholding. This report lists employees by SSN and name. |
Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, Local Tax Summary, Local Tax Summary |
PRCSRUNCNTRL |
TAX003CN Tax Submission Summary |
Produces a report that summarizes tax submission data, sorted by payroll account number. |
Payroll for North America, Regulatory Reports CAN, Tax Submission Summary, Tax Submission Summary Report |
RUNCTL_PAYINIT |
TAX004 Multiple Worksite |
Produces a listing of each tax location, that is used to calculate the employees work taxes. The tax location is considered a worksite when completing the information on the federally mandated Multiple Worksite report (BLS-3020) or state variations. |
Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, Multiple Worksite, Multiple Worksite Report |
RUNCTL_QTR_YR_PAY |
TAX004ST Employee Count |
Produce a report of employment count totals, sorted by gender, as of the 12th of each month in the quarter for the states of Connecticut, Maine, New Jersey, and Vermont. |
Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, Employee Count, Employee Count Report |
RUNCTL_TAX004ST |
TAX007 Quarterly Federal Tax Summary |
Produce a report by employee, quarter-to-date (QTD), federal withholding, Federal Insurance Contributions Act (FICA), and unemployment taxes. It lists employees by social security number (SSN) and name, and it provides page and company totals. |
Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, Federal Tax Summary, Federal Tax Summary Report |
PRCSRUNCNTRL |
TAX008 Quarterly State Tax Summary |
Produce a summary report of employee QTD state withholding, disability, and unemployment taxes. It lists employees by SSN and name, and it provides page and company totals. |
Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, State Tax Summary, State Tax Summary Report |
PRCSRUNCNTRL |
TAX009 Local Tax Deposit Summary |
Provides a tax summary report of local taxes withheld, and provides more detail than TAX001. This pay period report lists total taxes withheld for residents and nonresidents separately for each locality. It lists the number of employees in each category and counts only once those employees who receive more than one check. |
Payroll for North America, Pay Period Tax Reports USA, Local Tax Deposit, Local Tax Deposit Report |
RUNCTL_PAYINIT2 |
TAX010FD Tax Summary - Federal |
Produces a summary report of period-to-date income tax withheld, FICA, and unemployment taxes at the federal level. Run the report monthly or quarterly. |
Payroll for North America, Pay Period Tax Reports USA, Federal Tax Summary, Federal Tax Summary Report |
RUNCTL_TAX010FD |
TAX010ST Tax Summary - State |
Produces a summary report of period-to-date income tax withheld, disability, and unemployment taxes at the state and local levels. Run the report monthly or quarterly. |
Payroll for North America, Pay Period Tax Reports USA, State Tax Summary, State Tax Summary Report |
RUNCTL_TAX010ST |
TAX010PA PA Local Services Tax Report |
Produces a summary report of period-to-date local services taxes deducted for Pennsylvania. |
Payroll for North America, Pay Period Tax Reports USA, Tax Summary-PA LST, Tax Summary Report-PA LST |
RUNCTL_TAX010PA |
TAX012 Ohio Local Tax Reconciliation |
Provides the information for completing the Ohio Form W-3 and local variations. |
Payroll for North America, Pay Period Tax Reports USA, Reconciliation-Ohio Local, Reconciliation-Ohio Local Report |
RUNCTL_MO_QTR_YR |
TAX014 Federal Liability by State |
Produces a report of federal withholding and liability (ER and EE FICA plus withholding) for each state. Use this report to determine when to deposit state withholding in those states that associate the frequency of state deposits with the employer's schedule for federal tax deposits. Run TAX014 after each pay period. It inserts a grand total and totals for company, pay period, and check date. |
Payroll for North America, Pay Period Tax Reports USA, Federal Liability by State, Federal Liability by State Report |
RUNCTL_PAYINIT2 |
TAX015 Quarterly Tax Balances Audit |
Produces a report that compares the employee QTD tax balance with the sum of Tax Detail records from each payroll run for each tax class and tax jurisdiction, making it possible to verify that system computations are correct for these balances. |
Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, Tax Balance Audit, Tax Balance Audit |
RUNCTL_QTR_YR_PAY |
TAX016 Default Tax Data |
Produces a listing of the auto-generated data created by the system, such as the employee's hire date, federal marital status and allowances, state marital status and allowances, and local allowances and residence locality for U.S. employees. |
Payroll for North America, U.S. Annual Processing, Year-End/New Year Preparation, Default Tax Data Report, Default Tax Data Report |
RUNCTL_FRMTHRU_PAY |
TAX016CN Default Tax Data |
Produces a listing of the auto-generated data by the system, such as the employee's hire date, default net claim amounts from the Canadian tax tables, and provincial tax credit amounts from the Canadian Income Tax Data record. |
Payroll for North America, Year-End Processing CAN, Year-End/New Year Preparation, Default Tax Data Report, Default Tax Data Report |
RUNCTL_FRMTHRU_PAY |
TAX017 Quarterly State Unemployment Tax Verification |
Produce a report to verify that the appropriate employer unemployment tax for the quarter being reported has been calculated and posted to employees' Tax Balance records. |
Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, State Unemployment Tax Report, State Unemployment Tax Report |
RUNCTL_TAX017 |
TAX018 Employee Check Information |
Produce a listing of individual employee pay check information. |
|
RUNCTL_TAX018 |
TAX019 Employee Tax Information |
Produces an individual listing of the employee's tax withholding information. |
|
RUNCTL_TAX019 |
Form 1042-S Tax Liability Data by Pay Period |
Produces tax liability 1042 data for a company and period that you specify. |
Payroll for North America, Pay Period Tax Reports USA, Form 1042 Audit, Form 1042 Audit |
RUNCTL_TAX030 |
TAX100 W-4 Exemptions Report |
Produces a listing of all employees whose U.S. Tax Data records indicate that they are exempt from federal income tax withholding (W-4). |
Payroll for North America, U.S. Annual Processing, Year-End/New Year Preparation, W-4 Exemptions Report, W-4 Exemptions Report |
RUNCTL_TAX100 |
TAX100CN Exemption Report |
Produces a listing of all employees whose Canadian or Quebec Tax Data records indicate that they are exempt from income tax withholding, exempt from unemployment insurance payments, exempt from Quebec Parental Insurance Plan premiums, or have fewer than 12 months subject to Canada or Quebec Pension Plan contributions. |
Payroll for North America, Year-End Processing CAN, Year-End/New Year Preparation, Exemption Report, Exemption Report |
RUNCTL_TAX100CN |
TAX101CN EI Rebate (Employment Insurance rebate) |
Produces a listing of information for employers with private income replacement plans. |
Payroll for North America, Regulatory Reports CAN, EI Rebate, EI Rebate Report |
RUNCTL_TAX101CN |
TAX102CN Health Insurance Premium |
Produces a report of calculated health insurance premiums for provinces with a health insurance tax levied as a percent of payroll: Manitoba, Newfoundland, Ontario, and Quebec. |
Payroll for North America, Regulatory Reports CAN, Health Insurance Premium, Health Insurance Premium Report |
RUNCTL_TAX102CN |
TAX103 Reset W-4 Exempt List |
Produces a listing of employees who have not yet filed a new Form W-4 by the due date to continue their tax exemption status. If the report is run in update mode, it will insert a new tax record to reset the federal withholding status. marital status and withholding allowances. |
Payroll for North America, U.S. Annual Processing, Year-End/New Year Preparation, Reset W-4 Exempt List, Reset W-4 Exempt List |
RUNCTL_TAX103 |
TAX103CN Update Source Deductions |
Produces a listing of employees who have not yet filed a new form. It updates federal, Quebec, and provincial basic source deductions for employees by generating a new Canadian Income Tax Data record for each employee who is active as of the effective date specified. |
Payroll for North America, Year-End Processing CAN, Year-End/New Year Preparation, Update Source Deductions, Update Source Deductions |
RUNCTL_TAX103CN |
TAX105CN Employer Contribution to CNT (employer contribution to Commission des Normes du Travail) |
Produces a report of the calculated annual payment of the contribution to the financing of the CNT by employers with employees working in the province of Quebec. |
Payroll for North America, Regulatory Reports CAN, Employer Contribution to CNT, Employer Contribution to CNT |
PRCSRUNCNTL |
TAX107 W-4 Audit Report |
Produces a listing of all employees who either created or updated their W-4 information through self-service. |
Payroll for North America, U.S. Annual Processing, Year-End/New Year Preparation, W-4 Audit Report, W-4 Audit Report |
RUNCTL_TAX107 |
TAX108 W-4 Print Self-Service |
Produces a printed version of the electronic Form W-4 information submitted by the employee in the PeopleSoft ePay self-service transaction. |
|
RUNCTL_TAX108 |
TAX109 SSN Verification (social security number verification) |
Creates an electronic file that you can use to submit employee name and SSN information to the Social Security Administration for verification. |
|
RUNCTL_TAX109 |
TAX113 Reset W-5 Eligibility List |
Produces a listing of employees who have not refiled EIC eligibility by the due date. If run in update mode, it resets the employee EIC status to none and updates the EIC status on future-dated records. |
Payroll for North America, U.S. Annual Processing, Year-End/New Year Preparation, Reset W-5 Eligibility List, Reset W-5 Eligibility List |
RUNCTL_TAX103 |
TAX516AZ Arizona Tax Percentage Update |
Updates Arizona employees' tax percentages. |
|
RUN_MASS_EE_UPD |
TAX516OK Oklahoma Marital Status Update |
Change Oklahoma state marital status from B to the employee's federal tax marital status value. Note. TAX516OK.SQR was delivered specifically for Oklahoma withholding tax effective January 1, 2006. It has no general purpose. |
|
RUN_MASS_EE_UPD |
TAX5162T 2 Tiered Suppl Adj Pgm (two-tiered supplemental adjustment program) |
Update the special accumulator that tracks taxable wages to calculate taxes when the employee is paid over 1 million USD. See (USA) TAX5162T – Two-Tiered Supplemental Adjustment Program. |
|
RUNCTL_MASS_UPD2 |
TAX702 Federal/State Tax Table |
Produces a report of the State Tax table and the State Other Tax table, which store the most current tax rates and other parameters used in calculating state and federal withholding, disability, and unemployment taxes. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Federal/State Tax, Federal/State Tax Report |
PRCSRUNCNTRL |
TAX703 Local Tax Table |
Produces a report of the Local Tax table, which contains calculations for local income taxes. |
Set Up HRMS, Product Related, Payroll for North America,Tax Table Reports, Local Tax, Local Tax Report |
PRCSRUNCNTRL |
TAX704 Company State Tax Table |
Produces a report of information from the Company State Tax table, which identifies the states in which your company collects and pays taxes. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Company State Tax, Company State Tax Report |
PRCSRUNCNTRL |
TAX705 Company Local Tax Table |
Produces a report of information from the Company Local Tax table, which identifies the localities for which your company collects and pays taxes. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Company Local Tax, Company Local Tax Report |
PRCSRUNCNTRL |
TAX706 Taxable Gross Definition Table |
Produces a report of the Taxable Gross Definition table, which contains definitions that the system uses during payroll calculation to determine state and local taxable grosses and/or income taxes that deviate from the normal federal withholding. It specifies the base for taxable gross and indicates modifications to that base. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Taxable Gross Definition, Taxable Gross Definition Rpt |
PRCSRUNCNTRL |
TAX707 State Tax Rate Table |
Produces a report of the State Tax Rate table, which contains bracket rates that are needed for calculating state and federal taxes. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, State Tax Rate, State Tax Rate Report |
PRCSRUNCNTRL |
TAX708 State Reciprocity Rules Table |
Produces a report of the State Reciprocity Rules table, which contain the rules that determine where to withhold income taxes when an employee works in one state and lives in another. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, State Reciprocity Rules, State Reciprocity Rules Report |
PRCSRUNCNTRL |
TAX709 Local Reciprocity Rules Table |
Produce a report of the Local Reciprocity Rules table, which contain the rules that determine where to withhold income taxes when an employee works in one locality and lives in another. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Local Reciprocity Rules, Local Reciprocity Rules Report |
PRCSRUNCNTRL |
TAX711 Marital Status Codes |
Produces a report of the Marital Codes Status table, which contains all valid marital status codes, sorted by state. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, SWT Marital Status Codes, SWT Marital Status Codes Rpt |
PRCSRUNCNTRL |
TAX713 Work-Work Reciprocity Rules Table |
Produce a report of the Work-Work Reciprocity Rules table, where contain the reciprocal rules that determine local income tax withholding when an employee works in a location that has multiple taxing jurisdictions that share a reciprocal agreement. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Work Locality Reciprocity, Work Locality Reciprocity Rpt |
PRCSRUNCNTL |
TAX715 VDI/FLI Administrator Table (Voluntary Disability Insurance/Family Leave Insurance Administrator) |
Produce a report of the VDI/FLI Administrator table. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, VDI Administrator, VDI Administrator Report |
PRCSRUNCNTL |
TAX720 Tax Treaty Table |
Produce a report of the Tax Treaty table. |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Treaty/Non Resident Alien, Treaty/Non Resident Alien Rpt |
PRCSRUNCNTL |
TAX810XX Quarterly UI Wage Tape (quarterly unemployment insurance wage tape) |
Creates a file for states that must submit quarterly state wage listings on electronic/magnetic media, not using the EFW2 format. The XX in the report ID is a two-character state abbreviation. |
|
RUNCTL_TAX810XX |
TAX860XX Quarterly UI Wage Tape (quarterly unemployment insurance wage tape) |
Creates a file for states that must submit quarterly state wage listings on electronic/magnetic media using the EFW2 format. The XX in the report ID is a two-character state abbreviation. |
|
RUNCTL_TAX810XX |
TAX900 Annual Reporting Error Listing |
Lists employees who have negative tax balances or reportable wage amounts that would cause overflow in fields when the system writes W-2 data to magnetic media. It also checks for other error conditions. Normally, you run this report at year-end, but you can run it at other times to verify SSNs, or to check for negative tax balances and other error conditions. |
Payroll for North America, U.S. Annual Processing, Audit and Error Reports, Error Listing, Error Listing Report |
PRCSRUNCNTRL |
TAX905CN NW Territories Payroll Tax (Northwest Territories payroll tax) |
Produces a report of the Northwest Territories Payroll Taxes table. |
Payroll for North America, Regulatory Reports CAN, NW Territories Payroll Tax, NW Territories Payroll Tax Report |
RUNCTL_TAX905CN |
TAX906CN Nunavut Payroll Tax Annual |
Produces a report of the Nunavut payroll taxes. |
Payroll for North America, Regulatory Reports CAN, Nunavut Payroll Tax, Nunavut Payroll Tax Report |
RUNCTL_TAX906CN |
TAX940 FUTA Wage Reconciliation (Federal Unemployment Tax Act wage reconciliation) |
Produces a report that provides federal unemployment tax wage data that is used to complete the Form 940. You normally run this at year-end, but you can run it at other times to verify data. |
Payroll for North America, U.S. Annual Processing, Year-End/New Year Preparation, FUTA Wage Reconciliation Rpt, FUTA Wage Reconciliation Rpt |
PRCSRUNCNTL |
This section provides detailed information on selected individual reports listed alphabetically by report ID.
This report lists the direct deposit transactions, sorted by advice number. It includes:
Check date for each advice.
Net amount deposited.
Employee name and ID.
Employee department information.
Pay group.
Employee choice for delivery address.
The report totals the advice amounts at the company level and prints a grand total of all companies reported.
Use this report to identify accounts that were closed during RITS interface processing. For the accounts identified, you must:
Process a Personnel Action Request to change the SCD-Retire.
Print the OPM Form 1514.
Generate an IRR.
See Also
Crediting Military Service to Civilian Retirement
The system defines deductions and all nontaxable amounts that are subtracted from employee pay. If the current deduction amount contains adjustments for refunds, amounts paid in arrears, or amounts excluded, the report lists them in separate columns and provides column totals. The report includes:
Totals for month-to-date (MTD), QTD, and YTD deductions, sorted by employee.
Grand total for the pay period.
Goal amounts.
The report lists each deduction type on a separate page and the cumulative totals on the last page.
This report groups the employees by pay group and provides totals, sorted by department ID. It provides totals at the company, pay period, and pay group levels on the last page and a grand total for all paychecks. The report inserts page breaks after each pay group. For each employee listed, the report includes:
Check date and number.
Hours worked.
Earnings.
Gross and net amounts of the check.
Note. The check number appears only if you run the report after confirmation. Before confirmation, you do not see a check number.
The report further groups the number of hours worked and the associated earnings into regular, overtime, and other pay types. It contains a column for the gross amount of the check and the net amount.
There are also columns reducing the gross amount by tax type and each separate deduction. Each net amount is labeled with the type of payment document given to employee:
Check (C)
Direct deposit advice (A)
This report includes the following information about checks:
Date.
Amount.
Name of payee employee.
Employee ID.
Department name and ID.
Location name and ID.
Pay group.
Address option for the employee.
Each company in the organization has its own register page. The report totals the check amounts and number of checks that are written by the company and includes a grand total for all companies included in the report.
This report provides totals at the cost center level. In the cost center, the report lists employee name and ID and the hours and earnings that are represented in the current pay period.
The hours and earnings are further grouped into regular, overtime, and other types, including a total earnings column for each employee line.
This report includes each Other Earnings type on a separate page and totals, sorted by hours and amounts. It groups earnings information by pay periods for each company in the organization, and it groups pay periods by pay groups. Under each earnings type, the report lists the names and ID numbers of employees in employee ID order. It includes amounts and hours for the current pay period and sorted by MTD, QTD, and YTD totals. The report includes a grand total of hours and amounts for the following:
All earnings types for the pay group.
Pay period.
Company.
All companies.
This report includes the type of deduction and the associated benefit plan type for each employee affected. A balance column displays the amount still due in arrears. The report includes totals for the following:
The deduction listed.
All deductions for the company.
All companies in the report.
For each employee, this report lists:
Pay group.
Deduction name and code.
Amount omitted.
If this amount is in arrears, the report displays a Y in the Added to Arrears column and the new total of the arrears amount for that employee.
The report also includes the number and date of the check affected. It provides totals for the following:
All deductions not taken in the pay period.
Each company.
All companies (grand total).
The system creates paysheets in a batch process, during which it scans all employee records and selects the ones that it must pay in the pay period that you specify. For each set of applicable employee records that it finds, it creates a payline displaying payroll information.
You can view the results of this process online or print them (usually on a preprinted form). You might want to modify this report for your organization's unique needs. Specify the paysheet contents on Pay Group Table pages 4−6 and Payroll Data pages 1−2. Each payline consists of information, such as:
Amount or hours of regular pay.
Job data such as department, location, and job code.
Additional pay.
Tax information.
For each page, the system creates a paysheet balance, which counts total number of paylines, total number of regular hours, and total amount of regular pay.
For each employee listed, this report sorts the unprocessed hours and earnings by regular, overtime, and other earnings. It provides totals for the following:
Pay group.
Pay period.
Each company.
All companies (grand total).
If the system encounters errors during processing, it creates a message describing the condition causing the error. The system displays Check Messages!!! and stores the message for viewing online or in a printed report. The report includes the messages, sorted by company, for all pay groups in a pay period. It includes the following information in employee ID order:
Employee name and ID.
Department ID.
Page and line.
Separate check indicator.
Message ID number and its text.
The system prompts you for the employee name. You can specify any number of employees. This report includes the following information for each employee:
Employee name and ID.
Date hired.
Date rehired.
Service date.
Termination date.
Leave return date.
Status.
Regular or temporary.
Full-time or part-time.
Fair Labor Standards Act status.
Employee type.
If the job action dates do not apply to the selected employee, the column remains blank. The report includes the following job information:
Job code and title.
Department name and ID.
Earnings information includes:
Pay group.
Pay rate.
Monthly rate.
Annual rate.
Earnings code.
Earnings for the current month, QTD, and YTD.
The report lists earnings codes separately and as total amounts.
This report includes the following job information:
Job code and title.
Department name and ID.
Business unit.
Earnings information includes:
Pay group.
Pay rate.
Monthly rate.
Annual rate.
Earnings code.
Earnings for the current month, QTD, and YTD.
The earnings display balances across all wage loss plans and provinces. The report lists earnings codes separately and as total amounts.
Each employee appears on a separate page and includes the following information:
Pay period end date.
Department ID.
Check and advice numbers written in the quarter.
Hours and earnings for regular, overtime, and other earnings.
Gross pay amounts.
Federal and provincial tax types and amounts.
Deduction amounts and their codes.
Net pay for the quarter.
A new page starts for each different employee, but an employee might have multiple pages, depending on the volume of data.
Report details are the same as PAY014 - Employee Earnings Record report.
Note. Use the Calendar Year and Quarter fields on the Tax Reporting Parameters page to determine the period of data to include.
Use PAY015A and PAY015B to perform check reconciliation.
See Reconciling Checks.
Use PAY015A and PAY015B to perform check reconciliation.
See Reconciling Checks.
This report summarizes, on separate pages, information about:
Paycheck amounts.
Regular earnings amounts.
Special accumulator amounts.
Employee deduction amounts.
Employer contribution amounts.
Employee and employer tax amounts.
Other earnings amounts.
See Also
Generating a Payroll Summary Report
Adjusted balance information is reported on separate pages in the following order:
Checks.
Earnings and special accumulators.
Deductions.
Garnishments.
Taxes.
(CAN) ROE insurable earnings and hours.
7. Arrears
This report includes the following accounting line information:
Line description.
General ledger account and department ID.
Check number.
Payroll check date and foreign amount.
General ledger monetary amount.
Payroll and general ledger currency codes.
Conversion rate multiplier and divisor.
You must first run the PAYGL01 process.
See Also
Preparing and Transferring Payroll Data to General Ledger
This report includes the following information for each tip establishment:
To-date totals for gross receipts (if tip allocation method is gross receipts).
Direct tips.
Indirect tips.
Allocation base.
Direct tipped allocation base.
Total shortfall.
Total allocation.
Tip hours (if tip allocation method is hours).
Employee count.
For each employee, this report includes:
Hours or receipts and the reported tips used to calculate the allocated tips.
YTD allocated tips.
Previously allocated tips.
Current allocated tips.
The report includes subtotals for each establishment and a grand total for the company.
This report is similar to PAY110CN, except that it groups employees by hourly, salaried, and other pay types. For each type, it totals:
Employees in the group and their regular gross pay.
Overtime pay.
Hours paid.
Overtime hours paid.
The first part of this report applies to the last pay period of the month. In the second part, it includes information for the complete month at the bottom of the page and includes details about irregular payments, total payroll, and employees absent without pay. It further sorts the irregular payments and employees absent without pay by payment type and employee category, respectively.
See Also
The ROE reports an employee's interruption of earnings to HRSDC.
The ROE Print process extracts data from the ROE Data pages and the EI Insurable Earnings Balance records. The output conforms to the prescribed format, and you must print it on multi-part, tractor-feed forms that are supplied by HRSDC. The system assigns the ROE number during the final ROE Print process.
See Also
(CAN) PAY124CN - ROE Mass Create
Based on the date range or pay run ID that you enter when requesting the report, this report includes the following information, sorted by province:
Number of employees.
Employees' total unlimited assessable earnings.
Total assessed earnings.
Assessment rate.
Assessment amount.
Any limits that apply.
If there are employees who exceed the limit, the report includes the total number with the total amount of their excess earnings.
In accordance with WCB requirements, this report excludes certain employees, based on the status of their officer code in the Job record. For the Northwest Territories, Nunavut, Ontario, and Prince Edward Island, employees whose officer code is other than N (none) are excluded. For Alberta, Manitoba, and Quebec, employees with an officer code of D (director) and C (chairman) are excluded.
This program creates the BPS EDR file for transmission to Statistics Canada, as well as the BPS Summary report for your reference.
Create this file for each reference month only after the corresponding Pay Confirmation process is complete for all pay periods that are associated with that reference month.
See Also
PAY110CN is similar to PAY100CN, with the exception that PAY110CN groups employees into teaching staff, nonteaching staff, and supply or substitute teachers (rather than hourly, salaried, and other employees).
The Create Record of Employment SQR Report process (PAY124CN) creates ROE data for all employees who had, during the specified date range, a change in employee job status requiring an ROE. It generates entries in the ROE Data 1 and 2 pages for your review and makes updates as applicable.
This process does not produce a printed report unless the system generates an exception message, in which case the system produces an exception report.
See Also
This program produces an exception report of potential errors detected during the ROE Print process. The errors will not prevent the corresponding ROE forms from being processed. However, it is your responsibility to review the exceptions after each run of the ROE Print program, to ensure that all errors have been resolved prior to printing the ROE forms in Final Print mode.
See Also
The report includes the following information for each participating employee:
Employee ID and name.
Principal registrant and social insurance number (SIN).
Number of bonds, sorted by denomination.
Bond value.
Carrying charge.
Goal amount.
Employee deduction.
Bond cancel date.
The report also includes the total value of bonds, sorted by denomination, for all employees of the Canada Savings Bond series code.
Details of this report are discussed with the business process.
See Administering Canada Payroll Savings Programs.
This report lists valid general deduction codes and their effective dates. It includes:
Calculation type code for each deduction.
Flat rate or percentage.
Special accumulator code.
Employee pay frequency.
Additional flat deduction amount.
This report includes:
Each deduction plan type, its description, and effective date.
Codes that determine how the system handles deductions during payroll processing.
This report comes in two parts; you must request each report separately by ID number. PAY705A contains processing and GL information for deduction classes. PAY705B contains the effect of deduction classes on taxes.
This report lists the shifts for each Earnings table ID. It includes:
Date on which the shift became effective.
Flag indicating whether you must specify the rate and factor at the employee level.
Shift rate and factor.
Shift time in hours and minutes.
Lists information from the Pay Group table.
Note. (CAN) For Canadian reports, the three-digit bank ID is reported in the Bank Transit # field and the branch ID is reported in the Bank Branch field.
This report comes in three parts:
PAY712A: Lists selected tax effects related to earnings.
PAY712B: Lists selected tax effects related to earnings.
PAY712C: Contains the Canadian requirements for earnings types.
For every ChartField mapping, this report includes:
Company
HR Business Unit
Mapping Level
Effective Date
ChartFields
Line description
The primary page break for this report is check date, because it usually determines when you must deposit the taxes. For each check date, the report includes taxable gross amounts and taxes, sorted by taxing jurisdiction. Federal taxes are first, followed by states and localities. There are separate sections for withholding, FICA and disability, and unemployment amounts on this report. It lists employee contributions to unemployment insurance separately, with a tax type of UI-EE. The report lists special employer unemployment taxes—such as the medical Security Tax in Massachusetts and Louisiana's special assessment—separately under the Unemployment columns of the report, with a tax type of UI-SP.
This report includes:
Income tax
Payroll tax
Canada Pension Plan (CPP)
Quebec Pension Plan (QPP)
EI deductions
Quebec Parental Insurance Plan premiums (QPIP)
Total remittance amounts
This report includes:
Company name and address.
Location name and address.
Count of employees working at each worksite.
Total wages paid at each worksite.
Employee and wage totals are for the quarter. The report extracts employee information that is related to the tax location code.
For each taxing locality, this report lists:
Employee counts.
Taxable gross amount.
Tax withheld.
It lists separately employees paying resident and nonresident taxes, providing a total for each.
The report also includes taxes withheld for residents working in other taxing jurisdictions. Ohio taxing authorities apply credit for work tax paid to the residence tax liability (up to the rate of the residence tax). The report lists these work credits by locality name and includes the work tax rate. The report displays an asterisk next to the work tax rate if it exceeds the residence locality rate. In this case, the system calculates the credit based on the residence rate.
A summary line includes:
Total taxable gross for the locality.
Calculated tax based on the residence tax rate.
Actual tax withheld.
Total credit amount.
Sum of actual tax withheld and credits.
The calculated tax should be within pennies of the withheld tax and credits.
This is an exception report; that is, it lists only employees whose balances are not equal to the sum of the detail records. The report includes:
Tax class.
Balance type.
Payline detail sum.
QTD balance.
Discrepancy between the balance and the detail sum.
Normally, you should have no employees listed on this report. If they appear, investigate the source of the discrepancy immediately. TAX015, which you can run for any quarter of any year, is a more comprehensive report, because it is not restricted to a pay run ID or pay calendar, but runs across all companies.
When you hire an employee using PeopleSoft HCM, the system automatically sets up the following Tax records for the employee:
Federal
State
Local
The system uses information, such as the employees' home address and job location from their Personal Data and Job Data records, as the default in their Tax Data records, with a marital status of single and withholding allowances of zero. As a safeguard against incorrect default data slipping through unchecked, you can run SQR TAX016 - Default Tax Data. This report identifies which employees have such default data in their Tax records. The report reviews records from a date range that you specify.
When you hire someone using PeopleSoft HCM, the system automatically sets up Income Tax Data records for that employee. Run TAX016CN as a safeguard against incorrect default data slipping through unchecked.
In the case of an employee who, for reasons such as termination, stops being paid during a quarter in which a tax rate change later occurs, you might need to adjust the tax in the Balance record, because the quarterly tax should have been based on the later rate. Employees who continue to be paid throughout the quarter are self-adjusting.
The report lists, for employees whose balances are not what they should be:
Current YTD, QTD, and latest MTD employer unemployment tax balances.
Amounts of the adjustments.
Adjusted balance amounts.
If you run the SQR in R (report only) mode, the system performs the verification only, without actually updating system balances. To update the balances, run the report in U (update and report) mode.
This report includes:
Company.
Effective date.
State.
Local.
Resident.
Special status.
Additional amount and annual exempt.
Additional percent.
Marital status.
Allowances.
Additional allowances.
State unemployment tax exempt.
FICA status.
EIC status.
State disability insurance status.
For Canada, it includes:
Wage loss plan.
CPP and QPP subject months.
EI calculation status.
Special status.
Net claim amount.
TD1 adjustment.
Prescribed area.
Special letters.
Additional amounts.
Payroll tax exempt.
Registered Pension Plan and Registered Retirement Savings Plan limit.
Commission amounts.
Other tax credits.
For each employee listed, the report includes:
Employee ID.
Name.
Effective date of the exemption.
Department information.
Social security number.
Federal taxable gross YTD earnings.
Number of allowances.
Special federal withholding tax status.
Election of additional federal withholding.
Lists all employees whose Canadian or Quebec Tax Data records indicate that they are exempt from income tax withholding, exempt from unemployment insurance payments, exempt from Quebec Parental Insurance Plan premiums, or have fewer than 12 months subject to Canada or Quebec Pension Plan contributions.
Canadian employers use this annual report with private income replacement plans. These employers pay EI premiums at a reduced rate and, by law, must pass at least 5/12 of the premium reduction along to employees, either as cash or in the form of increased benefits.
For each employer wage loss plan for which the premium rate differs from the standard employer rate, rebates the system calculates rebates as follows:
employee's YTD EI premium × (standard rate − employer rate) × 5/12
For each employee, the report includes:
Employee rate and premium.
Employer rate and premium.
Calculated employee rebate amount.
This report provides monthly or pay period reporting totals as specified in the report request parameters. It inserts page breaks after each company.
The Arizona Tax Percentage Update SQR process (TAX516AZ) is a special process that assists in implementing Arizona state income tax withholding rate changes. It inserts new effective-dated employee tax data records with the required new Arizona withholding percentages for employees subject to Arizona withholding tax.
The process updates employee tax data records for employees who meet all of the following conditions:
Are currently subject to Arizona state withholding tax.
Are not terminated (PS_JOB.ACTION = TER) prior to the TAX516AZ.SQR run date.
Have an Arizona withholding percentage rate that was valid prior to the Arizona withholding percentage rate changes.
You can run TAX516AZ in audit mode or update mode. The process creates a TAX516AZ.LIS audit or update report. The report lists the employee ID, company, name, the effective-date of the new employee tax data record (if updated), prior , new percent of taxable gross, and any error conditions. The rows newly inserted into State_Tax_Data reflect the process run date.
There are three possible entries in the Errors column:
Error: FED and ST tax row EFFDT not equal - No Update. This message indicates that the process could not find FEDERAL_TAX_DATA and STATE_TAX_DATA record with corresponding effective dates.
This error condition occurs in cases where the files are out of sync and should be investigated.
Error: Existing AZ Tax Percent Invalid - No Update.
The process could not determine the appropriate percentage to change.
Informational Message: Found tax row dated => Eff Date. Updated.
The process has encountered a future-dated AZ row. If the data passes the above edits, it will be updated with the new percentages.
TAX5162T was provided to implement the new two-tiered federal supplemental tax rates in tax year 2005. You can also use it if you did not specify the supplemental payment special accumulator for all supplemental earnings codes and must correct the balances.
Note. As a prerequisite to running this report, you must create a special accumulator code to store each employee's taxable gross for supplemental payments. Enter this special accumulator on the Earnings Table - Special Process page with T selected in the Effect on Special Balance field for each earnings code identified as using the supplemental tax method.
TAX5162T relies on the special accumulator for supplemental payments to determine the taxable gross (as opposed to the total gross) amounts from confirmed payments of supplemental wages. It populates the to-date balances of the special accumulator by overriding existing period-to-date balance amounts with the cumulative period-to-date taxable gross portions of supplemental wage payments.
Note. The TAX5162T process cannot determine the taxable gross if supplemental payments were issued as part of the employee's regular paycheck. In this case, it updates the special accumulator with the total gross rather than the taxable gross.
TAX5162T produces a report to document the override to the special accumulator. From the run control page, run theprocess in either audit or update mode.
Audit mode creates a preliminary report that you can review for accuracy.
Audit mode does not update the database.
Update mode updates the special accumulator balances in the database.
Run the program only once in update mode. If previously calculated but unconfirmed payrolls exist, rerun the Pay Calculation process with the calculation option Recalculate All Checks selected so that the new special accumulator balances are accessed.
The output is produced in the electronic/magnetic media format. It can be copied to diskette, tape, or cartridge before filing, and some states allow the file to be submitted electronically. Some states use the TAX860XX format, which creates the file using the EFW2 format.
The state-specific versions of this report have self-explanatory prompts. You can specify the calendar year and quarter on the Define Tax Reporting Parameters page, found under the Quarterly Processing menu.
Where applicable, choose between the TAX810XX and TAX860XX formats from the choices displayed in the process list that appears after you click the Run button on the run control page.
This report prints the following information for employees who reside in the specified area:
Employee name.
SIN.
Total remuneration.
Taxable remuneration.
Tax withheld.
Total remuneration in the report is set to True T4 Total Gross YTD. A company total appears at the end of the report.
Employees who are exempted from payroll tax at the end of the report year do not appear in the report, even if their Tax Balance records indicate nonzero YTD tax or YTD taxable gross. An employee is exempted from payroll tax if the Payroll Tax Exempt check box in the employee's Canadian Income Tax Data record is selected.
You normally run this report at year-end, but you can run it at other times for data verification purposes.