Search Tags: Racino scholarships, financial aid, universal
JIRA Reference:
DM-188
-
Racino
Parked
Report Purpose
This report provides summary data for Racino Scholarships by institution.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
- UMS_DTS_FA_RACINO
- UMS_DTS_FA_RACINO_ADULT (For Adult Racino Scholarship)
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 | ACCNT_PERIOD | BUSINESS_UNIT | DEPTID | FUND | ACCOUNT | ACCT_DESCR | PROGRAM | PROG_DESCR | SUM_PTD | CLASS | OPER_UNIT |
|---|
Tables Used
Criteria Used
UMS_DTS_FA_RACINO:
- PROGRAM_CODE in ('19150','29150','39150','49150','59150','69150','79150')
- ACCOUNT = 55100
UMS_DTS_FA_RACINO_ADULT:
- PROGRAM_CODE in ('19152','29152','39152','49152','59152','69152','79152','89152')
- ACCOUNT = 55100
Calculation Used
SUM_PTD =SUM (Case when A.FISCAL_YEAR = :1 and A.UM_PROJECT_TO_DT <> 0 then A.UM_PROJECT_TO_DT else 0 end)
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.