PeopleSoft Enterprise Payroll for North America Reports

Appendix: PeopleSoft Enterprise Payroll for North America Reports

This appendix provides an overview of Payroll for North America reports and enables you to:

View summary tables of all reports.
View report details and tables accessed.

Note. For samples of these reports, see the PDF files that are published on CD-ROM with your documentation.

See Also

PeopleTools PeopleBook: PeopleSoft Process Scheduler

PeopleSoft Enterprise Payroll for North America Reports: A to Z

These tables list the Payroll for North America reports, sorted alphanumerically by report ID. The reports listed are all Structured Query Reports (SQRs). If you need more information about a report, refer to the report details at the end of this appendix.

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.

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, Direct Deposit Create File Payroll for North America, Payroll Processing USF, Create Direct Deposits, Create Direct Deposit File, Direct Deposit Create 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, Direct Deposit Create 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 Direct Deposit Advice Print	Prints paycheck and pay stub information onto direct deposit advice forms. Run this report after you perform pay confirmation for a payroll run. The report is intended as a template. See DDP003 - Direct Deposit Advice Print.	Payroll for North America, Payroll Processing USA, Create Direct Deposits, Print Advice Forms, DDP Advice Print Payroll for North America, Payroll Processing USF, Create Direct Deposits, Print Advice Forms, DDP Advice Print	RUNCTL_CHK_ADV1
DDP003CN Direct Deposit Advice Print	Prints Canadian paycheque and pay stub information onto direct deposit advice forms. Run this report after you perform pay confirmation for a payroll run. The report is intended as a template.	Payroll for North America, Payroll Processing CAN, Create Direct Deposits, Print Advice Forms, DDP Advice Print	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, Create Direct Deposits, Advice Register, DDP Advice Register Payroll for North America, Payroll Processing CAN, Create Direct Deposits, Advice Register, DDP Advice Register Payroll for North America, Payroll Processing USF, Create Direct Deposits, Advice Register, DDP 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. See DDP005 - Direct Deposit Prenotification.	Payroll for North America, Payroll Processing USA, Create Direct Deposits, Prenotification Report, DDP Prenotification Payroll for North America, Payroll Processing USF, Create Direct Deposits, Prenotification Report, DDP Prenotification	RUNCTL_PAYINIT2
DDP006 Direct Deposit Prenote Memo	Produces a report that displays employees who have their pay deposited directly into their bank account for the first time on Company stationary, or memo forms. See DDP006 - Direct Deposit Prenote Memo.	Payroll for North America, Payroll Processing USA, Create Direct Deposits, Prenote Memo, DDP Prenote Memo Payroll for North America, Payroll Processing USF, Create Direct Deposits, Prenote Memo, DDP Prenote Memo	RUNCTL_PAYINIT2

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
BUD004 Fiscal Year Budget	Produces a report that displays budget level definition for taxes, deductions, and earnings. Also reports the actuals to-date for the budget level, and the FTE (full-time equivalency) cap and maximum for the department. See Defining Fiscal Year Budgets.	Payroll for North America, Payroll Distribution, Commitment Accounting USA, Fiscal Year Budget Report, Fiscal Year Budget Report Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Fiscal Year Budget Report, Fiscal Year Budget Report	RUNCTL_BUD004
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 Rpt	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, RITS Interface	RUN_FGPY001
FGPY003 Treasury/FRB Bonds (Treasury/Federal Reserve Bank bonds)	Produces a summary report of the treasury interface data	Payroll for North America, Payroll Distribution, Additional Integrations USF, Treasury/FRB Bond Interface, Treasury/FRB 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, ECS Interface	RUN_FGPY004
FGPY011A Bond Purchases	Creates a Bond Purchase file and produces a report that lists all bond purchases since the last process run.	Payroll for North America, Payroll Processing USF, Pay Period Reports, Bond Purchase, Bond Purchase Report	RUNCTL_PAYINIT2
FGPY011B Bond Purchases - Federal Reserve System Format	Creates a Bond Purchase file in Federal Reserve System format for the purchase of bonds, and produces a report that lists all bond purchases since the last process run.	Payroll for North America, Payroll Processing USF, Pay Period Reports, Bond-Federal Reserve, Bond-Federal Reserve File	RUNCTL_PAY016B
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	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, Runctl 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, Runctl 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, Runctl Fgfmla	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, Runctl Fgfmla	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, Runctl Fgfmla	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	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	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	RUNCTL_FGSF1150
GMTEC002 GM Time and 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 Rpt	RC_GM_TE
PAY001 Deduction 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 Check Print	A template for printing paychecks and accompanying check stubs. Run this report after you perform pay confirmation for a payroll run. See PAY003 - Check Print.	Payroll for North America, Payroll Processing USA, Produce Checks, Print Checks, Check Print Payroll for North America, Payroll Processing USF, Produce Checks, Print Checks, Check Print	RUNCTL_CHK_ADV1
PAY003CN Cheque Print	A template for printing paycheques and accompanying cheque stubs. Run this report after you perform pay confirmation for a payroll run.	Payroll for North America, Payroll Processing CAN, Produce Cheques, Print Cheques, Cheque Print	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	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 Center, Cost Center 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, Paysheet Print 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 Rpt Payroll for North America, Periodic Payroll Events USF, Balance Reviews, Employee Earnings Snapshot Rpt, Employee Earnings Snapshot Rpt	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 Rpt	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
PAY016A Bond Purchases	Creates a Bond Purchase file and produces a report that lists all bond purchases since the last process run. See PAY016A - Bond Purchases.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Bond Purchase, Bond Purchase Report	RUNCTL_PAYINIT2
PAY016B Bond Purchases - Federal Reserve System Format	Creates a Bond Purchase file in Federal Reserve System format for the purchase of bonds, and produces a report that lists all bond purchases since the last process run. See PAY016B - Bond Purchases - Federal Reserve System Format.	Payroll for North America, Payroll Processing USA, Pay Period Reports, Bond-Federal Reserve, Bond-Federal Reserve File	RUNCTL_PAY016B
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, Paysheet Earnings Dist Print Payroll for North America, Payroll Processing CAN, Create and Load Paysheets, Print Paysheet Earnings Dist, Paysheet Earnings Dist Print Payroll for North America, Payroll Processing USF, Create and Load Paysheets, Print Paysheet Earnings Dist, Paysheet Earnings Dist Print	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 Rpt Payroll for North America, Payroll Processing USF, Pay Period Reports, Employer Benefit Contributions, Employer Ben Contributions Rpt	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 Rpt	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 Rpt Payroll for North America, Periodic Payroll Events USF, Imputed Income Adjustments, Adjustment Report, Imputed Income Adjustment Rpt	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
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, Allctn 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, 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 Gross 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	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
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, Statistics-Non-Educ Institute, Statistics Canada (Non-Educ)	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, ROE Print	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 Rpt	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, Statistics-Education Institute, Statistics Canada (Educ)	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, ROE Mass Create	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	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 Summary	Creates a retroactive (retro) pay summary from the Retro Pay Request table, which lists employee ID, effective date, process end dates and retro program ID.	Payroll for North America, Retroactive Payroll, Reports, Retroactive Pay Reports, Retro Pay Request Summary, Retro Pay Request Summary Rpt	RUNCTL_RTRORQST
PAY301RT Retro Pay All Calculated	Produces a detailed report of the retroactive pay calculation, sorted by employee and by earnings type. See PAY301RT - Retro Pay All Calculated.	Payroll for North America, Retroactive Payroll, Reports, Retroactive Pay Reports, Retro Pay Calculations, Retro Pay Calculations Report	RUNCTL_RTRODETAIL
PAY302RT Retro Pay Summary	Produces a retro pay summary of each request type, with a grand total of both request types.	Payroll for North America, Retroactive Payroll, Reports, Retroactive Pay Reports, Retro Pay Calc Summary, Retro Pay Calc Summary Rpt	RUNCTL_RTROSUMM
PAY303RT Retro Pay Terms Calculated	Produces a report of terminated employees for whom the system has calculated retro pay. This report lists the same information as PAY301RT.	Payroll for North America, Retroactive Payroll, Reports, Retroactive Pay Reports, Retro PayTerminations, Retro Pay Terminations Report	RUNCTL_RTROTERM
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, Change Status/Review Info, Retro Pay Interest Limit Rpt, Retro Pay Interest Limit Rpt	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. See PAY701 - Bank Table.	Set Up HRMS, Common Definitions, Banking, Bank/Branch Report, Bank/Branch Report	PRCSRUNCNTL
PAY702 Company Table - GL Data (Company table - general ledger 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, Agency GL Acct Rpt USF, Agency GL Account 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
PAY706 Bond Table	Produces a listing of the U.S. Bond table, which contains effective dates and other bond information. See PAY706 - Bond Table.	Set Up HRMS, Product Related, Payroll for North America, Deduction Table Reports, U.S. Savings Bond, U.S. Savings Bond 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	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, which is sorted by state and used in U.S. garnishment processing.	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, which is sorted by province and territory and used in Canadian garnishment processing.	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 Rpt	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	PRCSRUNCNTL
PAYGL01 Payroll General Ledger Interface	For employers using the GL Interface process, this produces accounting lines for PeopleSoft Enterprise General Ledger. This does not produce a report.	Payroll for North America, Payroll Distribution, Prepare GL Information, Non-Commit Accounting Info, Non-Commit Accounting Info	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
PAYXTRCT AP Extract Audit (accounts payable extract audit)	Produce a listing of the AP Extract Audit table, that contains non-tax deductions that are sent to PeopleSoft Enterprise Payables.	Payroll for North America, Payroll Distribution, Accounts Payable Information, AP Extract Audit Report, AP Extract Audit Report	PRCSRUNCNTL

Tax Reports (TAX)

Report ID and Report Name	Description	Navigation	Run Control Page
T002CAHP Quarterly State Employee Wage Listing - California	(E&G) Produces state unemployment wage listings in a general format for quarterly reporting, including page and state totals for California.	Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, California	RUNCTL_TAX002CA
T002MIHP Quarterly State Employee Wage Listing - Michigan	(E&G) Produces state unemployment wage listings in a general format for quarterly reporting, including page and state totals for Michigan.	Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, Michigan	RUNCTL_TAX002MI
T002MNHP Quarterly State Employee Wage Listing - Minnesota	(E&G) Produces state unemployment wage listings in a general format for quarterly reporting, including page and state totals for Minnesota.	Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, Minnesota	RUNCTL_TAX002MN
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
TAX002XX Quarterly State Employee Wage Listing	Produces state employee wage listings in a general format for quarterly reporting, including page and state totals. The XX in the report ID is a two-character state abbreviation.	Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report	RUNCTL_TAX002XX
TAX003CN Tax Submission Summary	Produces a report that summarizes tax submission data, sorted by business number. See (CAN) TAX003CN - Tax Submission Summary.	Payroll for North America, Regulatory Reports CAN, Tax Submission Summary, Tax Submission Summary Rpt	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, disability, FICA, and unemployment taxes at the federal level. Run the report monthly or quarterly.	Payroll for North America, Pay Period Tax Reports USA, Tax Summary-Federal, Tax Summary Report - Federal	RUNCTL_TAX010FD
TAX010ST Tax Summary - State	Produces a summary report of period-to-date income tax withheld, disability, FICA, and unemployment taxes at the state and local levels. Run the report monthly or quarterly.	Payroll for North America, Pay Period Tax Reports USA, Tax Summary-State, Tax Summary Report - State	RUNCTL_TAX010ST
TAX010PA Tax Summary − PA (tax summary − Pennsylvania)	Produces a summary report of period-to-date income tax withheld, disability, FICA, and unemployment taxes at the federal, state, and local levels for Pennsylvania.	Payroll for North America, Pay Period Tax Reports USA, Tax Summary-PA OPT, Tax Summary Report-PA OPT	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 Rpt	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 Rpt	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 Report	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, Employee Pay Data USA, Tax Information, Default Tax Data Report, Default Tax Data Report Payroll for North America, Employee Pay Data USF, Tax Information, 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, Employee Pay Data CAN, Tax Information, 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 Rpt	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 Info Report, Employee Check Info Report Payroll for North America, Payroll Processing CAN, Produce Cheques, Employee Cheque Info Report, Employee Cheque Info Report Payroll for North America, Payroll Processing USF, Produce Checks, Employee Check Info Report, Employee Check Info Report	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 Rpt Payroll for North America, Employee Pay Data CAN, Tax Information, Employee Tax Information Rpt, Employee Tax Information Rpt Payroll for North America, Employee Pay Data USF, Tax Information, Employee Tax Information Rpt, Employee Tax Information Rpt	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 Report	RUNCTL_TAX030
TAX100 Federal Tax Data Status	Produces a listing of all employees whose U.S. Tax Data records indicate that they are exempt from federal income tax withholding. See TAX100 - W-4 Exemptions.	Payroll for North America, Employee Pay Data USA, Tax Information, W-4 Exemptions Report, W-4 Exemptions Report Payroll for North America, Employee Pay Data USF, Tax Information, W-4 Exemptions Report, W-4 Exemptions Report	RUNCTL_TAX100
TAX100CN Exemption	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, or have fewer than 12 months subject to Canada or Quebec Pension Plan contributions. See (CAN) TAX100CN - Exemption.	Payroll for North America, Employee Pay Data CAN, Tax Information, 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 Rpt	RUNCTL_TAX102CN
TAX103 Reset W-4 Exempt Employees	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, Employee Pay Data USA, Tax Information, Reset W-4 Exempt List, Reset W-4 Exempt List Payroll for North America, Employee Pay Data USF, Tax Information, 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 Interface, Update Payroll Information, Update Source Deductions CAN, 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
TAX106 W-4 IRS (W-4 Internal Revenue Service)	Produces a listing of employees who claim either exemption from federal withholding or more than 10 allowances.	Payroll for North America, Employee Pay Data USA, Tax Information, W-4 IRS Report, W-4 IRS Report Payroll for North America, Employee Pay Data USF, Tax Information, W-4 IRS Report, W-4 IRS Report	RUNCTL_TAX106
TAX107 W-4 Audit	Produces a listing of all employees who either created or updated their W-4 information on the web.	Payroll for North America, Employee Pay Data USA, Tax Information, W-4 Audit Report, W-4 Audit Report Payroll for North America, Employee Pay Data USF, Tax Information, W-4 Audit Report, W-4 Audit Report	RUNCTL_TAX107
TAX113 Reset W-5 EIC Employees (reset W-5 Earned Income Credit employees)	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, Employee Pay Data USA, Tax Information, Reset W-5 Exempt List, Reset W-5 Exempt List Payroll for North America, Employee Pay Data USF, Tax Information, Reset W-5 Exempt List, Reset W-5 Exempt List	RUNCTL_TAX103
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 Administrator Table (Voluntary Disability Insurance Administrator table)	Produce a report of the VDI 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 MMREF-1 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 Magnetic Media 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 Magnetic Media ND-SC Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Magnetic Media 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 MMREF-1 format. The XX in the report ID is a two-character state abbreviation. Amounts reported by TAX002XX must match the amounts reported by TAX810XX. There are a few states that have additional requirements when creating the magnetic media. Some ask for diskette information, and others mimic the information requested when running the TAX002XX versions. They are AK, AL, AR, AZ, DC, HI, ID, CA, IA, CO, FL, and CT.	Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Magnetic Media 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 Magnetic Media ND-SC Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Magnetic Media SD-WY	RUNCTL_TAX810XX
TAX811GA Quarterly UI Wage Diskette for Georgia (quarterly unemployment insurance wage diskette for Georgia)	This process works with TAX810GA to create a file for submitting quarterly state wage listings on diskette. It reads the output file from TAX810GA and maps the records to the format that is required for diskettes. Copy the output file to a newly formatted diskette for submission.	Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Georgia Wage Diskette, Run Parameters	RUNCTL_TAX811GA
TAX900 Annual Reporting Error Listing (Annual Wage Data Edit)	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 Rpt	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, FUTA Wage Reconcialition Rpt, FUTA Wage Reconciliation Rpt	PRCSRUNCNTL

PeopleSoft Payroll for North America Selected Reports

This section provides detailed information on individual reports including important fields. The reports are listed alphabetically by report ID.

DDP003 - Direct Deposit Advice Print

This report is intended as a template for printing direct deposit advice forms. Information on the advice form template includes:

Employee name
Delivery address
Department
Location
Date
Advice number
Check amount

The report groups the gross amount into earnings, taxes, deductions, and employer-paid benefits, with both pay period totals and YTD totals.

The stub information identifies:

Company.
Employee.
Deposit amount.
Distribution details of the accounts receiving the funds.

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.

DDP005 - Direct Deposit Prenotification

For each company and pay period, this reports lists employees who you have added to the direct deposit instructions since the last pay period. It includes:

Employee ID.
Priority of the types of deposits.
Code (such as checking or savings) for the type of account designated to receive the deposit.
Bank transit number.
Checking account number.

You must run this report before DDP006 - Direct Deposit Prenote Memo to provide the necessary employee data for producing printed prenotification notices for employees who are affected.

DDP006 - Direct Deposit Prenote Memo

This report prints the memo on your company stationery or memo forms. The text of the memo informs the employee of the direct deposit and lists:

Bank transit number.
Account number.
Account type.
Deposit instructions for verification, as recorded in DDP005 - Direct Deposit Prenotification.

This report contains no data if you do not run DDP005 first.

(USF) FGPY011B - Bond Purchases - Federal Reserve System Format

Report details are the same as FGPY011A - Bond Purchases.

Note. You must use the file name PAYROLL.DK when submitting savings bond purchase data to the Federal Reserve Bank on diskette. In some environments, you might need to rename the PAY016B.SQR output file as PAYROLL.DK when creating the diskette.

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

PAY003 - Check Print

This report is intended as a template for printing paychecks. This report template prints the following information on the check stock:

Employee name.
Address.
Location.
Date.
Check number.
Check amount.

The stub information identifies the company, employee, and check.

The report groups the gross amount into:

Earnings.
Taxes.
Deductions.
Employer-paid benefits.

It includes pay period totals and YTD totals.

Note. Pay Group Table 4, 5, and 6, and the Payroll Data 1 and 2 pages contain extensive options for sorting and sequencing employees’ paychecks.

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.

PAY016A - Bond Purchases

This report selects all Bond Log records with a status of R, prepares the report, and sets the status to D (distributed) for each record selected. The report identifies relevant information about co-owners and beneficiaries. It inserts a page break after each different bond denomination and totals each denomination and all bonds purchased. PAY016A also prepares a Bond Purchase file.

PAY016B - Bond Purchases - Federal Reserve System Format

Report details are the same as PAY016A - Bond Purchases.

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.

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.

PAY301RT - Retro Pay All Calculated

This report lists:

Original hours.
Hourly rate.
Earnings amount.
New hourly rate.
Earnings amount.
Retro pay amount.
Effective, begin, and end dates, if you performed an override.
OK to Pay status, if this is a duplicate request, if you are processing off-cycle, or if there is an exception.
Exception message.

You can use this report as a printed audit report. The same information is available online.

PAY701 - Bank Table

This report lists each bank, sorted by transit number. For each bank, it includes:

Long and short bank name description.
Address.
Deposit medium (tape, diskette, or report).
Waiting period for direct deposits after sending a prenote test.

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.

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.

PAY706 - Bond Table

The report lists all valid bond types, sorted by ID number. Each type has:

Effective date.
Description.
Purchase amount.
Value at maturity.

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
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 Human Resources Management (PeopleSoft HRMS), 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 HRMS, 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

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

TAX810XX and TAX860XX - Quarterly UI Wage Tape

The output is produce in the electronic/magnetic media format. It can be copied to diskette or tape before filing. Some states use the TAX860XX format, which creates the file using the MMREF format. If you need to submit a diskette to Georgia, you must run the TAX810GA, followed by the TAX811GA SQR. .

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.