PS Query for Scholarship Application Based On Audit Trail Details

This function allows and provide details of the process that will be used to generate a list of applicants along with the changes in their application.

Roles Involved: MOE - Scholarship Officer

1. Navigate to Main Menu > Reporting Tools > Query > Query Viewer.

2. In the parameters, enter the MOE_SB_SCHOLARSHIP_AUDITSTATS in the Begins with field.

3. Click on the Search button to search for the query.

4. Optionally, in the Query section, click on the Favourite link then the system will populate the query into the My Favorite Queries section. This can be done to allow faster access to this query the next time you open Query Viewer.

5. Click on the ‘HTML’ link to continue and you will be directed to the MOE_SB_SCHOLARSHIP_AUDITSTATS page.

6. In the Parameters, enter the values in the Academic Institution, Level, Application Year, Appl Status, Scholarship Type and *Shortlisted As Of fields.

7. Click on the View Results button and the system will generate lists of query information for Scholarship Application Details.

8. Click on the Excel SpreadSheet link to View or Save the report.

Note: Here is how the report should look like: