This appendix provides an overview of PeopleSoft Payroll Interface 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 Portable Document Format (PDF) files that are published with your online documentation.
See Also
PeopleTools: PeopleSoft Process Scheduler PeopleBook
These tables list the PeopleSoft Payroll Interface reports, sorted alphanumerically by report ID. If you need more information about a report, refer to the report details at the end of this appendix.
This section discusses:
Data reports.
Payroll reports.
Interface definition reports.
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
Pay031 |
For each company/pay group, lists the deduction type and calculated deduction amount for each employee. This report can be run only after the Calculate Deductions process is run. |
Payroll Interface, Reports, Benefit Deductions Register, Benefit Deductions Register |
RUNCTL_PAYINIT2 |
PI001 |
Lists detailed information for employees who will be included in the export file, including both old and new values for fields that changed since the last export file was created. |
Payroll Interface, Reports, Export Changes, Export Changes Report |
RUNCTL_PIEXPT |
TAX016 |
(USA) Lists employees with incorrect default data in their Tax records. |
Payroll Interface, Reports, Default Tax Data USA, Default Tax Data Report |
RUNCTL_FRMTHRU_PAY |
TAX016CN |
(CAN) Provides the data that is auto-generated by the system, such as the employee's hire date, default net claim amount from the Canadian Tax Tables, and province. This report also includes the provincial tax credit amounts from the Canadian Income Tax Data record. |
Payroll Interface, Reports, Default Tax Data CAN, Default Tax Data Report |
RUNCTL_FRMTHRU_PAY |
TAX019 |
(USA) Provides an individual listing of the employee's tax withholding information. |
Payroll Interface, Reports, Employee Tax Information USA, Employee Tax Information Report |
RUNCTL_TAX019 |
TAX019 |
(CAN) Provides an individual listing of the employee's tax withholding information. |
Payroll Interface, Reports, Employee Tax Information CAN, Employee Tax Information Report |
RUNCTL_TAX019 |
TAX100 |
(USA) Lists all employees in each company who are exempt from federal income tax withholding. |
Payroll Interface, Reports, W-4 Exemption, W-4 Exemptions Report |
RUNCTL_TAX100 |
TAX100CN |
(CAN) Lists all employees whose Canadian or Quebec Tax Data records indicate that they are exempt from income tax withholding, are exempt from unemployment insurance payments, or have fewer than 12 months subject to Canada or Quebec pension plan contributions. |
Payroll Interface, Reports, Exemption CAN, Exemption Report |
RUNCTL_TAX100CN |
TAX103 |
(USA) Identifies employees who have not yet filed a new Form W-4 by the due date to continue their exemption status, and inserts a new Tax record to reset the employee federal withholding status, marital status, and withholding allowances. The report also updates future-dated records that currently specify exempt status. |
Payroll Interface, Reports, Reset W-4 Exempt List, Reset W-4 Exempt List |
RUNCTL_TAX103 |
TAX107 |
(USA) Lists all employees who either created or updated their W4 information on the web. |
Payroll Interface, Reports, W-4 Audit, W-4 Audit Report |
RUNCTL_TAX107 |
TAX113 |
(USA) Identifies employees who have not yet refiled by the due date to continue their advance payments of EIC, and inserts a new Tax record to reset the employee EIC status to None. The report also updates future-dated records that currently specify EIC status. |
Payroll Interface, Reports, Reset W-5 Exempt List, Reset W-5 Eligibility List |
RUNCTL_TAX103 |
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
PI701 |
Shows each system ID, its description, and its effective date, along with other data on the System Interface Table. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, System Table Listing, System Table Listing |
PRCSRUNCNTL |
PI702 |
Lists PeopleSoft tables and views that you can use in PeopleSoft Payroll Interface. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, PS Record Listing, PS Record Listing |
PRCSRUNCNTL |
PI703 |
Lists each field on the PeopleSoft tables and views that you can use in PeopleSoft Payroll Interface. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, PS Record-Field Listing, PS Record-Field Listing |
PRCSRUNCNTL |
PI704 |
Shows fields that are defined for the third-party payroll system and how PeopleSoft fields are mapped to them for both import and export processing. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Field Listing, Field Listing |
PRCSRUNCNTL |
PI705 |
For each defined system ID, lists the third-party payroll system's fields along with the PeopleSoft source fields. Also lists translate values. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Field-Translation Listing, Field-Translation Listing |
PRCSRUNCNTL |
PI706 |
Displays each instance of a PeopleSoft record to be exported to the third-party payroll system. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Instance Listing, Instance Listing |
PRCSRUNCNTL |
PI707 |
Displays descriptions for each defined COBOL process that filters data before creating the export file. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Process Listing, Process Listing |
PRCSRUNCNTL |
PI708 |
Displays values that are returned from a special COBOL process. These values are used in the field translation process. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Process Values, Process Values |
PRCSRUNCNTL |
PI709 |
Lists each file that is used in PeopleSoft Payroll Interface. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Definition Table-File, Definition Table-File |
PRCSRUNCNTL |
PI710 |
Lists the layout of each record that is used to format import and export files. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Definition Table-Record, Definition Table-Record |
PRCSRUNCNTL |
PI711 |
Lists the layout and content of each field for every record on each file that is used in PeopleSoft Payroll Interface. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Definition Table-Field, Definition Table-Field |
PRCSRUNCNTL |
PI712 |
Displays processing groups, file names, and descriptions that are needed for the third-party payroll system. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Configuration Listing, Configuration Listing |
PRCSRUNCNTL |
PI713 |
Lists group IDs that represent fields to be processed together in the export file. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Group Listing, Group Listing |
PRCSRUNCNTL |
PI714 |
Where they differ, lists each PeopleSoft employee ID along with the third-party payroll system's employee ID. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, Employee Listing |
PRCSRUNCNTL |
PI715 |
Displays each file handle, file name, and description. |
Set Up HRMS, Product Related, Payroll Interface, Interface Definition Reports, File Handle Listing, File Handle Listing |
PRCSRUNCNTL |