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

SetIDItem TypeAid YrEff DateStatusDescrShort DescSourceFederal IDFinaid TypeNeed Based

Tables Used (For DARTS users only)

UM_ITYP_FA_VW - FA view of Item Types

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.