Search Tags: Financial Aid, loan 

JIRA Reference:   DM-197 - JMM Nursing Loan Fund Cash Balance Closed   DM-530 - Perkins Loan Fund Cash Balance Closed

Report Purpose

This report provides the current loan cash balance by institution and system-wide total each month for the fiscal year.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer

Report Name

UMS_DTS_NURS_LOAN_CASH_BAL   (For Nursing Loan)

UMS_DTS_PERKINS_LOAN_CASH_BAL  (For Perkins Loan)

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

Data Fields Generated

FISCAL_YEARACCOUNTING_PERIODUMS01 - UMAUMS02 - UMFUMS03 - UMFKUMS04 - UMMUMS05 - UMUMS06 - USMUMS07 - UMPIUMS08 - UMSTOTAL

Tables Used

UM_GLQ_REPRTING - Ledger Data

Criteria Used

UMS_DTS_NURS_LOAN_CASH_BAL :

UMS_DTS_PERKINS_LOAN_CASH_BAL :


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!

Round, red help button. Click to email DARTS.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.