Search Tags: Endowment
JIRA Reference:
DM-287
-
UMS06 Endowment Shares, Book Value, Market Value, and Spending Balance.xls
Closed
Report Purpose
This report provides the investment values, gains, market values, income, expenses and spending balances for endowment for the University of Southern Maine.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_UMS06_ENDOW_SPENDING
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| FISCAL_YEAR | ACCOUNTING_PERIOD | BUSINESS_UNIT | FUND_CODE | DEPTID | PROGRAM_CODE | PROG_DESCR | PROG_CAT1_D | PROG_CAT2_D | PROG_CAT3_D | PROG_RESTR_1_D | PROG_RESTR_2_D | SHARES | INITIAL INVESTMENT | REALIZED GAINS | UNREALIZED GAINS | MARKET VALUE | BEGINNING BAL | YTD ENDOWMENT INCOME | YTD INTEREST INCOME | YTD OTHER REVENUE | YTD TOTAL REVENUE | YTD EXPENSE | SPENDING BAL | CR2 | ENDOW | PROG_TI_INC_DST | PROG_ENDOW_DIST | ENDOW INCOME BASE BUDGET |
|---|
Tables Used
Criteria Used
- BUSINESS_UNIT = UMS06
- UM_PROG_CAT1_D - Program Category 1= Endowment
- PROGRAM_CODE <> ' '
- PROGRAM_CODE <> 80073
- SUBSTR(A.UM_DEPT_DESCR,1,5) <> Audit
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.