Report Purpose
Annual NCAA Financial Aid reporting for Division III institutions: UMS02, 06 and 07.
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
To find and run these reports, copy and paste the report name into the search bar located by following the filepath above.
UMS_DTS_NCAA_ALL_UMS06
UMS_DTS_NCAA_ASAT_DIRECTORY
UMS_DTS_NCAA_DIVIII_UMS02
UMS_DTS_NCAA_DIVIII_UMS06
UMS_DTS_NCAA_DIVIII_UMS07
UMS_DTS_NCAA_SPORTS_UMS06
UMS_DTS_NCAA_SPORTS_UMS07
The Sports Tables must be queried separately and joined with the data
in MS Access
UMS_DTS_NCAA_SPORTS_UMS06
UMS_DTS_NCAA_SPORTS_UMS07
Prompts Required
- STRM:
- AID YEAR:
Sports Tables require:
- Eff Date Less Than:
| EMPLID | add SPORT123 | FED_YEAR_COA | PRORATED_EFC | FED_NEED | PELL | SEOG | STATE_GIFT_AID | INSTITUTIONAL_GIFT_AID | PRIVATE_GIFT_AID | OTHER_GIFT_AID | WS | CEP | STUDENT_NAME | ADMIT_TERM | RESIDENCY |
|---|
Data Fields Generated
Sports Tables
| EMPLID | SPORT1 |
|---|
Tables Used
Tables for top set of 6 reports:
UM_STUD_CENS_VW - Student Reporting Extract
STDNT_AWD_PER - Student Award PeriodTable
UM_ITYP_FA_VW - FA view of Item Types
Tables for Sport Tables:
DM-12
-
NCAA Division III Annual Financial Aid Reporting USM, UMF, UMPI
Reopened
REPORT-262
-
Update NCAA Financial Aid for 2016
Closed
New to PeopleSoft Query?
Click on Getting Started and begin with the Query Basics video
Need help running a query?
Click on Running Reports with Query Viewer & Query Manager for a quick how-to guide for navigating to PS Query and running a report.
HELP IS AT HAND!
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.