JIRA Reference:   DM-549 - FA - Early College Schol by Item Type Closed

Report Purpose

This report is useful when you know Item Type code for a specific scholarship. It shows the offer amount, accept amount, and disbursed amount by student. It only includes students whose disbursed amount is not $0.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Campus Solutions-92-Reporting > PS Query tile > Query Manager or Query Viewer

Note - If your CSRPT Reporting Homepage dashboard does not have a PS Query tile, contact the UMS - Campus Solutions Security Liaisons for your institution.

Report Name

UMS_DTS_SCHOLARSHIP_ITEM_TYPE

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

Data Fields Generated

Institution

Aid YearItem TypeItem DescrEMPLIDNameTermOffer Balance SUMAccept Balance SUMDisbursed Balance SUM

Tables Used

New to PeopleSoft Query?

Click on Getting Started and begin with the Query Basics video

Need help running a report?

Click on Running Reports with Query Viewer & Query Manager or How to Run an SQR for simple how-to guides for running reports. If you've followed the path to an SQR location and cannot see the report, your PeopleSoft settings may need adjustments. Please see Security Questions (PS Query/Discoverer).

HELP IS AT HAND!

Link to compose email for help with website.Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.