Reporting Overview

Pension Administration comes with standard reports that support a range of pension administration functions, from a detailed calculation worksheet to Form 5500 participant counts.

Many of the standard reports are Structured Query Reports (SQRs). Because you can use SQRs to extract data from any SQL database, you can use this tool to create a wide variety of reports or to perform global database manipulations and interactive queries. You can use these reports as provided or modify them to meet your specific needs.

Certain delivered SQR extracts provide data you can merge with Microsoft Word for Windows templates to produce form letters. Several sample templates are provided.

You can use the Process Scheduler to streamline reporting. It enables you to run reports locally on a client workstation or remotely on a server, without exiting Pension Administration or using a third-party scheduling program. If you schedule reports to run on a server, you can choose to run them later. This can avoid tying up personnel and printer resources during peak periods.

To perform ad hoc and repeated queries on your PeopleSoft database, you can use PS/Query, a query tool that enables you to create new queries, run existing ones, and generate the results online or in printed reports.