JIRA Reference:
Report Purpose
This report pulls the list of financial aid with setID (institution), aid year, item type and description of the aid.
It is useful when you are looking for a particular item type by name of the aid or get the list of all available aid for the institution by aid year.
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_FINAID_LIST
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
- Set ID (Institution)
- AID_YEAR
- Item Type
- Descr ( Use wildcard "%". For example, enter "%Pell%" when you are searching aids that contain "Pell" on the description. This is case sensitive, so "Pell" and "PELL" are different)
Data Fields Generated
SetID | Item Type | Aid Yr | Eff Date | Status | Descr | Short Desc | Source | Federal ID | Finaid Type | Need Based |
---|
Tables Used (For DARTS users only)
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!
