Search Tags: Year end, designated
JIRA Reference:
DM-80
-
YE- Deficits - LOC G&C - Liz
Parked
Report Purpose
This report provides PTD revenue budget, revenue balance, BOY fund equity, PTD revenue, PTD expense, and deficits by program for Letter of Credit (LOC) grants and contracts.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
- UMS_DTS_YE_DEFICITS_NONC_LOCGC
- UMS_DTS_YE_DEFICITS_LOC_G_C_UM (for UMS05 only)
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
| BUSINESS_UNIT | FISCAL_YEAR | ACCNT_PERIOD | PROJECT | PROJ_DESCR | FUND | PROGRAM | DEPTID | OPER_UNIT | PROJ_MGR_NAME | PROJ_START_DT | PROJ_END_DT | PROJ_MINSRC | PROJECT_STATUS | PROJ_MAJSRC | PROJ_LOC_SRCE | PTD_REV_BUDGET | PTD_REVENUE | REV_(OVER)_UNDER_BUDGET | PTD_EXP_BUDGET | PTD_EXPENSE | EXP_OVER_(UNDER)_BUDGET | NET_BUDGET | CURR_MO_EXP | PROJECT_(BAL)_DEFICIT | PROJ_CATEGORY |
|---|
Tables Used
Criteria Used
For UMS_DTS_YE_DEFICITS_NONC_LOCGC:
- SUBSTR (DEPTID, 2, 6) NOT BETWEEN 000010 AND 000099
- FUND_CODE = 20
UM_PROJ_CATEGORY in ('GRANTS_CONTRACTS','ARRA_AWARDS')
SUBSTR( UM_PROJ_LOC_SRCE,1,3) = 'LOC'
- FUND_CODE = 20
UM_PROJ_CATEGORY = 'GRANTS_CONTRACTS'
SUBSTR( UM_PROJ_LOC_SRCE,1,3) = 'LOC'
PROJECT_STATUS <> 'C'
BUSINESS_UNIT = 'UMS05'
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.