Search Tags: yearend, umsaccouting, deficits, umbudget
DM-105Report Purpose
This report provides PTD revenue budget, revenue balance, BOY fund equity, PTD revenue, PTD expense, and deficits by program for gifts or endowments.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
- UMS_DTS_YE_DEFICITS_GIFTS
- UMS_DTS_YE_DEFICITS_GIFTS_1000 (Gifts deficits more than $1000 only. Some fields are different.)
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 blank to see data from all business units)
Data Fields Generated
For UMS_DTS_YE_DEFICITS_GIFTS:
| FISCAL_YEAR | ACCOUNTING_PERIOD | BUSINESS_UNIT | PROGRAM_CODE | DEPTID | FUND_CODE | PROG_DESCR | OPERATING_UNIT | PROG_CAT1 | PTD_REV_BUDGET | REV_BAL_DEFICITS | BOY_FUND_EQUITY | PTD_REVENUE | PTD_EXPENSE | DEFICITS |
|---|
For UMS_DTS_YE_DEFICITS_GIFTS_1000:
| FISCAL_YEAR | ACCOUNTING_PERIOD | BUSINESS_UNIT | PROGRAM_CODE | DEPTID | FUND_CODE | PROG_DESCR | OPERATING_UNIT | PROJECT_ID | PROJ_DESCR | PROJ_START_DT | PROJ_END_DT | BOY_FUND_EQUITY | PTD_REVENUE | PTD_EXPENSE | DEFICITS | PROG_CAT1 |
|---|
Tables Used
Criteria Used
For UMS_DTS_YE_DEFICITS_GIFTS:
- SUBSTR (DEPTID, 2, 6) NOT BETWEEN 000010 AND 000099
- FUND_CODE = 20
- UM_PROG_CAT1 in list ('GIFTS','ENDOW')
- DEFICITS > 0
For UMS_DTS_YE_DEFICITS_GIFTS_1000:
- FUND_CODE = 20
- UM_PROG_CAT1 = 'GIFTS'
- DEFICITS > 1000
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.Special Calculation
/*+DEFICITS */ ( SUM(CASE WHEN (CASE WHEN (SUBSTR(A.ACCOUNT,1,1)) = '1' THEN 'Assets' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '2' THEN 'Liabilities' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '3' THEN 'Net Assets' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '4' THEN 'Revenue' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '8' THEN 'Revenue' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '5' THEN 'Expense' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '6' THEN 'Expense' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '7' THEN 'Expense' ELSE 'Other' END) = 'Net Assets' THEN A.UM_PROJECT_TO_DT ELSE 0 END) ) +( SUM(CASE WHEN (CASE WHEN (SUBSTR(A.ACCOUNT,1,1)) = '1' THEN 'Assets' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '2' THEN 'Liabilities' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '3' THEN 'Net Assets' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '4' THEN 'Revenue' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '8' THEN 'Revenue' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '5' THEN 'Expense' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '6' THEN 'Expense' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '7' THEN 'Expense' ELSE 'Other' END) = 'Revenue' THEN A.UM_PROJECT_TO_DT ELSE 0 END) ) +( SUM(CASE WHEN (CASE WHEN (SUBSTR(A.ACCOUNT,1,1)) = '1' THEN 'Assets' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '2' THEN 'Liabilities' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '3' THEN 'Net Assets' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '4' THEN 'Revenue' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '8' THEN 'Revenue' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '5' THEN 'Expense' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '6' THEN 'Expense' WHEN (SUBSTR(A.ACCOUNT,1,1)) = '7' THEN 'Expense' ELSE 'Other' END) = 'Expense' THEN A.UM_PROJECT_TO_DT ELSE 0 END) )