Search Tags: IPEDS, Financial aid
JIRA Reference:
DM-194
-
IPEDS Scholarships & Waivers-Updated 12.14.16
Client Wait
Report Purpose
This report provides year-to-date expenses, waivers, scholarship allowances, and total aid by IPEDS source category.
Since this report replaces one containing subtotals, the query will be flagged for replacement when a new BI tool is available. In the meantime, please use the subtotal function in Excel. Additional instructions for creating pivot tables is here.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_IPEDS_SCHOL_WAIVERS
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
- Fiscal Year
- Accounting Period
- Business Unit (Leave it blank if you want to see data from all business unit)
Data Fields Generated
| FISCAL_YEAR | ACCOUNTING_PERIOD | BUSINESS_UNIT | IPEDS_SOURCE | FUND_CODE | DEPTID | DEPT_DESCR | PROG_CAT1 | PROGRAM_CODE | PROG_DESCR | PROJECT_ID | SUBSTR(A.PROJECT_ID,7,1) | PROJ_DESCR | PROJ_MAJSRC | YTD_NET_EXPENSE | WAIVERS | SCHOL_ALLOW | TOTAL_AID |
|---|
Tables Used
Criteria Used
- FUND_CODE NOT in ('11', '21', '31', '51', '50')
- ACCOUNT between 40000 and 89999
- ACCOUNT between 41000 and 41700 or ACCOUNT='40901' OR UM_DEPT_EXP2 - 2-Digit Department Expense Cd = 'EX80'
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!
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.