Running Queries

Owned by Elysia Gallinaro
Apr 17, 2023
2 min read

Overview

 This procedure provides the steps for creating and printing a Schedule of Classes report for a specified term, using the Query Manager in People Soft (SA)

Use the Query Manager is used to create the report file for a specified term, and save it to an Excel spread sheet.

The report file can be sorted and edited in Excel as desired by the Scheduling Office or by the Scheduling Representatives.

Business Process

The Schedule of Classes report is used to review scheduling data that has been recorded for a term. The Scheduling Office and the Scheduling Representatives use this report to assist in cleaning up various types of common coding errors

PeopleSoft Navigation

Reporting Tools → Query → Query Viewer

In the begins with bow enter in the query name

Click the yellow Search button.

 

Select Run to Excel or run to HTML.

In the new panel, fill in and of the prompts that might come up - there should be instructions next to them, to let you know how to fill in the information needed.

Select Save, if you’ve run it to Excel, and save the file in the appropriate folder in the Teams channels. Sort or edit the file in Excel as required.