Report Generation

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.

There are three types of pension reports:

• Calculation result reports.

  Calculation result reports include the non-detailed calculation worksheet, the calculation worksheet, and the social security worksheet.

• Participant letters.

  Participant letters help you communicate with employees. Several sample letters can be modified to meet organization requirements.

• Data extracts:

  • Actuarial valuation.

    The actuarial valuation extract contains data that your actuary needs to determine plan liabilities. The extract has two parts: the "active" extract, for those whose benefits are still accruing, and the "inactive" extract, for those who are owed benefits, but whose benefits are no longer accruing. Employees appear in one or both of these files, based on their pension status codes and the rules you define for categorizing those codes.

  • Form 5500.

    The Form 5500 Participant Count report tallies participants, based on their pension statuses. It helps you meet the Form 5500 reporting requirements.

  • Trustee extract.

    The trustee extract contains all the retiree payment information for a specific pay run. You give this to the third-party trustee who creates your pension checks.