PeopleSoft Payroll for North America 9.1 PeopleBook

Appendix: PeopleSoft Payroll for North America Reports

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

PeopleSoft Payroll for North America Reports: A to Z

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.

Direct Deposit Reports (DDP)

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.	Payroll for North America, Payroll Processing USA, Create Direct Deposits, Create Direct Deposit File, Create Direct Deposit File Payroll for North America, Payroll Processing USF, Create Direct Deposits, Create Direct Deposit File, Create Direct Deposit File	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.	Payroll for North America, Payroll Processing USA, Create Direct Deposits, Direct Deposit Register, Direct Deposit Register Payroll for North America, Payroll Processing CAN, Create Direct Deposits, Direct Deposit Register, Direct Deposit Register Payroll for North America, Payroll Processing USF, Create Direct Deposits, Direct Deposit Register, Direct Deposit Register	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. See Content of Paychecks and Advices.	Payroll for North America, Payroll Processing USA, Create Direct Deposits, Print Advice Forms, Print Advice Forms Payroll for North America, Payroll Processing USF, Create Direct Deposits, Print Advice Forms, Print Advice Forms	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. See Content of Paychecks and Advices.	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. See DDP004 - Payroll Advice Register.	Payroll for North America, Payroll Processing USA, Create Direct Deposits, Advice Register, Direct Deposit Advice Register Payroll for North America, Payroll Processing CAN, Create Direct Deposits, Advice Register, Direct Deposit Advice Register Payroll for North America, Payroll Processing USF, Create Direct Deposits, Advice Register, Direct Deposit Advice 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.	Payroll for North America, Payroll Processing USA, Create Direct Deposits, Prenotification Report, Direct Deposit Prenotification Payroll for North America, Payroll Processing USF, Create Direct Deposits, Prenotification Report, Direct Deposit Prenotification	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.	Payroll for North America, Payroll Processing USA, Create Direct Deposits, Prenote Memo, Direct Deposit Prenote Memo Payroll for North America, Payroll Processing USF, Create Direct Deposits, Prenote Memo, Direct Deposit Prenote Memo	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. See Content of Paychecks and Advices.	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. See Content of Paychecks and Advices.	Payroll for North America, Payroll Processing USA, Create Direct Deposits, Create Advice PDF Forms, Create Advice PDF Forms Payroll for North America, Payroll Processing USF, Create Direct Deposits, Create Advice PDF Forms, Create Advice PDF Forms	RUNCTL_CHK_ADV1_EP

Payroll Reports (PAY or FG)

Report ID and Report Name	Description	Navigation	Run Control Page
BUD002 Reconciliation	Provides reconciliation details. See Defining Fiscal Year Budgets.	Payroll for North America, Payroll Distribution, Commitment Accounting USA, Reconciliation Report, Reconciliation Report Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Reconciliation Report, Reconciliation Report Payroll for North America, Payroll Distribution, Commitment Accounting USF, Reconciliation Report, Reconciliation Report	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. See (USF) FGPY012 - Military Deposits 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. See PAY001 - Deduction Register.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Deduction Register, Deduction Register Payroll for North America, Payroll Processing USF, Pay Period Reports, Deduction Register, Deduction Register	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. See PAY002 - Payroll Register.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Payroll Register, Payroll Register Payroll for North America, Payroll Processing CAN, Pay Period Reports, Payroll Register, Payroll Register Payroll for North America, Payroll Processing USF, Pay Period Reports, Payroll Register, Payroll Register	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. See Content of Paychecks and Advices.	Payroll for North America, Payroll Processing USA, Produce Checks, Print Pay Checks, Print Pay Checks Payroll for North America, Payroll Processing USF, Produce Checks, Print Pay Checks, Print Pay Checks	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. See Content of Paychecks and Advices.	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. See PAY004 - Check Register.	Payroll for North America, Payroll Processing USA, Produce Checks, Check Register, Check Register Payroll for North America, Payroll Processing CAN, Produce Cheques, Cheque Register, Cheque Register Payroll for North America, Payroll Processing USF, Produce Checks, Check Register, Check Register	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.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Cost Center, Cost Center Report Payroll for North America, Payroll Processing CAN, Pay Period Reports, Cost Centre, Cost Centre Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Cost Center, Cost Center Report	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. See PAY006 - Other Earnings Register.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Other Earnings Register, Other Earnings Register Payroll for North America, Payroll Processing CAN, Pay Period Reports, Other Earnings Register, Other Earnings Register Payroll for North America, Payroll Processing USF, Pay Period Reports, Other Earnings Register, Other Earnings Register	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. See PAY007 - Deductions in Arrears.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Deductions in Arrears, Deductions in Arrears Report Payroll for North America, Payroll Processing CAN, Pay Period Reports, Deductions in Arrears, Deductions in Arrears Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Deductions in Arrears, Deductions in Arrears Report	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. See PAY008 - Deductions Not Taken.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Deductions Not Taken, Deductions Not Taken Report Payroll for North America, Payroll Processing CAN, Pay Period Reports, Deductions Not Taken, Deductions Not Taken Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Deductions Not Taken, Deductions Not Taken Report	RUNCTL_PAYINIT
PAY009 Paysheets	Print the paysheets created in the Create Paysheet process (PSPPYBLD). See PAY009 - Paysheets.	Payroll for North America, Payroll Processing USA, Create and Load Paysheets, Print Paysheets, Print Paysheet Payroll for North America, Payroll Processing CAN, Create and Load Paysheets, Print Paysheets, Paysheets Print Payroll for North America, Payroll Processing USF, Create and Load Paysheets, Print Paysheets, Paysheets Print	RUNCTL_PAYINIT2
PAY010 Employees Not Processed	Produces a report of employee hours and earnings that were not processed for the pay period. See PAY010 - Employees Not Processed.	Payroll for North America, Payroll Processing USA, Produce Payroll, Employees Not Processed Report, Employees Not Processed Report Payroll for North America, Payroll Processing CAN, Produce Payroll, Employees Not Processed Report, Employees Not Processed Report Payroll for North America, Payroll Processing USF, Produce Payroll, Employees Not Processed Report, Employees Not Processed Report	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. See PAY011 - Payroll Error Messages.	Payroll for North America, Payroll Processing USA, Review Processing Messages, Payroll Error Message Report, Payroll Error Message Report Payroll for North America, Payroll Processing CAN, Review Processing Messages, Payroll Error Message Report, Payroll Error Message Report Payroll for North America, Payroll Processing USF, Review Processing Messages, Payroll Error Message Report, Payroll Error Message Report	RUNCTL_RPT_RUNID
PAY013 Employee Earnings Snapshot	Produces a report of detailed information for U.S. employees as of the date that you specify. See PAY013 - Employee Earnings Snapshot.	Payroll for North America, Periodic Payroll Events USA, Balance Reviews, Employee Earnings Snapshot Rpt, Employee Earnings Snapshot Report Payroll for North America, Periodic Payroll Events USF, Balance Reviews, Employee Earnings Snapshot Rpt, Employee Earnings Snapshot Report	RUNCTL_PAY013
PAY013CN Employee Earnings Snapshot	Produces a report of detailed employee information for Canadian employees as of the date you specify. See (CAN) PAY013CN - Employee Earnings Snapshot.	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. See PAY014 - Employee Earnings Record.	Payroll for North America, Periodic Payroll Events USA, Balance Reviews, Employee Earnings Record Rpt, Employee Earnings Record Rpt Payroll for North America, Periodic Payroll Events USF, Balance Reviews, Employee Earnings Record Rpt, Employee Earnings Record Rpt	PRCSRUNCNTRL
PAY014CN Employee Earnings Record	Prints an earnings summary record for each Canadian employee that is selected as of the date specified. See (CAN) PAY014CN - Employee Earnings Record.	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.	Payroll for North America, Periodic Payroll Events USA, Check Reconciliation, Request Reconciliation, Check Reconciliation Payroll for North America, Periodic Payroll Events CAN, Check Reconciliation, Request Reconciliation, Cheque Reconciliation Payroll for North America, Periodic Payroll Events USF, Check Reconciliation, Request Reconciliation, Check Reconciliation	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.	Payroll for North America, Periodic Payroll Events USA, Check Reconciliation, Reconciliation Report, Check Reconciliation Report Payroll for North America, Periodic Payroll Events CAN, Check Reconciliation, Reconciliation Report, Cheque Reconciliation Report Payroll for North America, Periodic Payroll Events USF, Check Reconciliation, Reconciliation Report, Check Reconciliation Report	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.	Payroll for North America, Payroll Processing USA, Create and Load Paysheets, Print Paysheet Earnings Dist, Print Paysheet Earnings Distribution Payroll for North America, Payroll Processing CAN, Create and Load Paysheets, Print Paysheet Earnings Dist, PPrint Paysheet Earnings Distribution Payroll for North America, Payroll Processing USF, Create and Load Paysheets, Print Paysheet Earnings Dist, Print Paysheet Earnings Distribution	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. See PAY018 - Payroll Summary.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Payroll Summary, Payroll Summary Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Payroll Summary, Payroll Summary Report	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.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Employer Benefit Contributions, Employer Ben Contributions Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Employer Benefit Contributions, Employer Ben Contributions Report	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. See PAY025 - Balance Adjustments.	Payroll for North America, Periodic Payroll Events USA, Balance Adjustments, Balance Adjustment Report, Balance Adjustment Report Payroll for North America, Periodic Payroll Events USF, Balance Adjustments, Balance Adjustment Report, Balance Adjustment Report	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).	Payroll for North America, Periodic Payroll Events USA, Imputed Income Adjustments, Adjustment Report, Imputed Income Adjustment Report Payroll for North America, Periodic Payroll Events USF, Imputed Income Adjustments, Adjustment Report, Imputed Income Adjustment Report	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).	Payroll for North America, Payroll Processing USA, Create and Load Paysheets, Presheet Audit Report, Presheet Audit Report Payroll for North America, Payroll Processing CAN, Create and Load Paysheets, Presheet Audit Report, Presheet Audit Report Payroll for North America, Payroll Processing USF, Create and Load Paysheets, Presheet Audit Report, Presheet Audit Report	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.	Payroll for North America, Payroll Processing USA, Produce Payroll, Precalculation Audit Report, Precalculation Audit Report Payroll for North America, Payroll Processing CAN, Produce Payroll, Precalculation Audit Report, Precalculation Audit Report Payroll for North America, Payroll Processing USF, Produce Payroll, Precalculation Audit Report, Precalculation Audit Report	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.	Payroll for North America, Payroll Processing USA, Produce Payroll, Preconfirm Audit Report, Preconfirm Audit Report Payroll for North America, Payroll Processing CAN, Produce Payroll, Preconfirm Audit Report, Preconfirm Audit Report Payroll for North America, Payroll Processing USF, Produce Payroll, Preconfirm Audit Report, Preconfirm Audit Report	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. See PAY039 - HR Accounting Line Report.	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. See PAY050 - Allocation By Establishment.	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. See PAY051 - Allocation By Employee.	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).	Payroll for North America, Payroll Processing USA, Create Final Checks, Final Check Requests Report, Final Check Requests Report Payroll for North America, Payroll Processing CAN, Create Final Cheques, Final Cheque Requests Report, Final Cheque Requests Report Payroll for North America, Payroll Processing USF, Create Final Check, Final Check Requests Report, Final Check Requests Report	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.	Payroll for North America, Payroll Processing USA, Create Final Checks, Final Check Reconcile Report, Final Check Reconcile Report Payroll for North America, Payroll Processing CAN, Create Final Cheques, Final Cheque Reconcile Report, Final Cheque Reconcile Report Payroll for North America, Payroll Processing USF, Create Final Checks, Final Check Reconcile Report, Final Check Reconcile Report	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.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Bond Purchase Suspensions, Bond Purchase Suspensions Payroll for North America, Payroll Processing USF, Pay Period Reports, Bond Purchase Suspensions, Bond Purchase Suspensions	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. See (CAN) PAY101CN - ROE Print.	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. See (CAN) PAY102CN - Workers Compensation.	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. See (CAN) PAY124CN - ROE Mass Create.	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). See (CAN) PAY126CN - ROE Print Exceptions.	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. See (CAN) PAY131CN - Canada Savings Bond Purchase.	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. See Administering Canada Payroll Savings Programs.	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.	Payroll for North America, Payroll Processing USA, Create and Load Paysheets, Paysheet Transactions Report, Paysheet Transactions Report Payroll for North America, Payroll Processing CAN, Create and Load Paysheets, Paysheet Transactions Report, Paysheet Transactions Report Payroll for North America, Payroll Processing USF, Create and Load Paysheets, Paysheet Transactions Report, Paysheet Transactions Report	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. See PAY703 - General Deduction/Deduction Frequency Table.	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. See PAY704 - Deduction/Deduction Frequency Table.	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. See PAY705 - Deduction Classes.	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. See PAY711 - 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. See PAY712 - Earnings Table.	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.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Garnishment Prorations, Garnishment Prorations Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Garnishment Prorations, Garnishment Prorations Report	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. See PAY752 - Company ChartField Mapping.	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. See Content of Paychecks and Advices.	Payroll for North America, Payroll Processing USA, Produce Checks, Create PDF Paychecks, Create PDF Paychecks Payroll for North America, Payroll Processing USF, Produce Checks, Create PDF Paychecks, Create PDF Paychecks	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. See Content of Paychecks and Advices.	Payroll for North America, Payroll Processing CAN, Produce Cheques, Create PDF Paycheques, Create PDF Paycheques	RUNCTL_CHK_ADV_EP

Tax Reports (TAX)

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. See TAX001 - Tax Deposit Summary.	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. See (CAN) TAX003CN - Tax Submission Summary.	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. See TAX004 - Multiple Worksite.	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. See TAX012 - Ohio Local Tax Reconciliation.	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. See TAX015 - Quarterly Tax Balances Audit.	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. See TAX016 - Default Tax Data.	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. See (CAN) TAX016CN - Default Tax Data.	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. See TAX017 - Quarterly State Unemployment Tax Verification.	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.	Payroll for North America, Payroll Processing USA, Produce Checks, Employee Check Information, Employee Check Information Payroll for North America, Payroll Processing CAN, Produce Cheques, Employee Cheque Information, Employee Cheque Information Payroll for North America, Payroll Processing USF, Produce Checks, Employee Check Information, Employee Check Information	RUNCTL_TAX018
TAX019 Employee Tax Information	Produces an individual listing of the employee's tax withholding information. See TAX019 - Employee Tax Information.	Payroll for North America, Employee Pay Data USA, Tax Information, Employee Tax Information Rpt, Employee Tax Information Report Payroll for North America, Employee Pay Data CAN, Tax Information, Employee Tax Information Rpt, Employee Tax Information Report Payroll for North America, Employee Pay Data USF, Tax Information, Employee Tax Information Rpt, Employee Tax Information Report	RUNCTL_TAX019
TAX030 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). See TAX100 - W-4 Exemptions Report.	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. See (CAN) TAX100CN - Exemption.	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. See (CAN) TAX101CN - EI Rebate.	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. See (CAN) TAX102CN - Health Insurance Premium.	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.	Payroll for North America, Payroll Processing USA, Pay Period Reports, W-4 Print - Self Service, W-4 Print - Self Service Payroll for North America, Payroll Processing USF, Pay Period Reports, W-4 Print - Self Service, W-4 Print - Self Service	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.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Employee SSN Verification, Employee SSN Verification Payroll for North America, Payroll Processing USF, Pay Period Reports, Employee SSN 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. See (USA) TAX516AZ - Arizona Tax Percentage Update.	Payroll for North America, Periodic Payroll Events USA, Mass Employee Updates, Update Mass Tax Data, Update Mass Tax Data Payroll for North America, Periodic Payroll Events USF, Mass Employee Updates, Update Mass Tax Data, Update Mass Tax Data	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.	Payroll for North America, Periodic Payroll Events USA, Mass Employee Updates, Update Mass Tax Data, Update Mass Tax Data Payroll for North America, Periodic Payroll Events USF, Mass Employee Updates, Update Mass Tax Data, Update Mass Tax Data	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.	Payroll for North America, Periodic Payroll Events USA, Mass Employee Updates, Update Two-Tier Suppl Data, Update Two-Tier Supplemental Data Payroll for North America, Periodic Payroll Events USF, Mass Employee Updates, Update Two-Tier Suppl Data, Update Two-Tier Supplemental Data	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. See TAX810XX and TAX860XX - Quarterly UI Wage Tape.	Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File AK-ID Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Magnetic Media IL-NC Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File ND-RI Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File SD-WY	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.	Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File AK-ID Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File IL-NC Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File ND-RI Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File SD-WY	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. See (CAN) TAX905CN - NW Territories Payroll Tax.	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

PeopleSoft Payroll for North America Selected Reports

This section provides detailed information on selected individual reports listed alphabetically by report ID.

DDP004 - Payroll Advice Register

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.

(USF) FGPY012 - Military Deposits Closed Accounts

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.

PAY001 - Deduction Register

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.

PAY002 - Payroll Register

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)

PAY004 - Check Register

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.

PAY005 - Cost Center

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.

PAY006 - Other Earnings Register

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.

PAY007 - Deductions in Arrears

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.

PAY008 - Deductions Not Taken

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).

PAY009 - Paysheets

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.

PAY010 - Employees Not Processed

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).

PAY011 - Payroll Error Messages

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.

PAY013 - Employee Earnings Snapshot

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.

(CAN) PAY013CN - Employee Earnings Snapshot

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.

PAY014 - Employee Earnings Record

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.

(CAN) PAY014CN - Employee Earnings Record

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.

PAY015A - Check Reconciliation Process

Use PAY015A and PAY015B to perform check reconciliation.

See Reconciling Checks.

PAY015B - Check Reconciliation

Use PAY015A and PAY015B to perform check reconciliation.

See Reconciling Checks.

PAY018 - Payroll Summary

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

PAY025 - Balance Adjustments

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

PAY039 - HR Accounting Line Report

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.

PAY050 - Allocation By Establishment

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.

PAY051 - Allocation By Employee

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.

(CAN) PAY100CN - Statistics Canada, Non-Educational Institutions

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

(CAN) PAY101CN - ROE Print

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

(CAN) PAY102CN - Workers Compensation

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.

(CAN) PAY104CN - Business Payrolls Survey (BPS) Electronic Data Transmission File

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

Generating the BPS EDR File

(CAN) PAY110CN - Statistics Canada, Educational Institutions

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).

(CAN) PAY124CN - ROE Mass Create

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

(CAN) PAY101CN - ROE Print

(CAN) PAY126CN - ROE Print Exceptions

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

(CAN) PAY101CN - ROE Print

(CAN) PAY131CN - Canada Savings Bond Purchase

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.

(CAN) PAY132CN - Payroll Savings Create File

Details of this report are discussed with the business process.

See Administering Canada Payroll Savings Programs.

PAY703 - General Deduction/Deduction Frequency Table

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.

PAY704 - Deduction/Deduction Frequency Table

This report includes:

Each deduction plan type, its description, and effective date.
Codes that determine how the system handles deductions during payroll processing.

PAY705 - Deduction Classes

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.

PAY708 - Shift Table

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.

PAY711 - Pay Group Table

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.

PAY712 - Earnings Table

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.

PAY752 - Company ChartField Mapping

For every ChartField mapping, this report includes:

Company
HR Business Unit
Mapping Level
Effective Date
ChartFields
Line description

TAX001 - Tax Deposit Summary

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.

(CAN) TAX003CN - Tax Submission Summary

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

TAX004 - Multiple Worksite

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.

TAX012 - Ohio Local Tax Reconciliation

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.

TAX015 - Quarterly Tax Balances Audit

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.

TAX016 - Default Tax Data

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.

(CAN) TAX016CN - Default Tax Data

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.

TAX017 - Quarterly State Unemployment Tax Verification

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.

TAX019 - Employee Tax Information

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.

TAX100 - W-4 Exemptions Report

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.

(CAN) TAX100CN - Exemption

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.

(CAN) TAX101CN - EI Rebate

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.

(CAN) TAX102CN - Health Insurance Premium

This report provides monthly or pay period reporting totals as specified in the report request parameters. It inserts page breaks after each company.

(USA) TAX516AZ - Arizona Tax Percentage Update

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.

(USA) TAX5162T – Two-Tiered Supplemental Adjustment Program

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.

TAX810XX and TAX860XX - Quarterly UI Wage Tape

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.

(CAN) TAX905CN - NW Territories Payroll Tax

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.