Search Tags: facilities, project, revenue, expense, UMSAccounting
JIRA Reference:
DM-145
-
BoT Project Status Report by Campus
Closed
Report Purpose
This report provides the Board of Trustees project status with revenue, expense and endowment data by campus.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
- UMS_DTS_BOT_PROJ_STATUS_REP
- UMS_DTS_BOT_PROJ_STATUS_REP_JM (contains fewer PROJECT_ID selections)
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 | CAMPUS | PROJECT_ID_R | PROJ_DESCR2 | PROG_CAT1 | PROG_CAT1_D | PROGRAM | PROG_DESCR | STATE_BONDS | STATE_BONDS_EXP | REVENUE_BONDS | REV_BONDS_EXP | GIFTS_ENDOW | GIFTS_ENDOW_EXP | CAMPUS_FUNDS | CAMPUS_FUNDS_EXP | STATE_APP | STATE_APP_EXP | FEDERAL_APP | FEDERAL_APP_EXP | GRANTS | GRANTS_EXP | EMT_NOTES_PAY | EMT_NOTES_PAY_EXP | OTHER | OTHER_EXP | TOTAL_BUD_SOURCE | TOTAL_PROJ_EXP |
|---|
Tables Used
Criteria Used
(from UM_GLQ_REPRTING)
For UMS_DTS_BOT_PROJ_STATUS_REP:
- UM_PROJ_GROUP <> 'BOND_ADMIN'
- PROGRAM_CODE = '89119' and PROJECT_ID <> '8150000' or FUND_CODE in list ('18','28'))
- STATISTICS_CODE = ' '
- PROJECT_ID in list ('2100068', '3100030', '4100027', '4100028', '5100316', '6100237', '6100250', '5100387', '6200181', '6100255', '6100256', '6100257', '6100258', '6100259', '6100260', '5100414', '6100245', '1100528', '3100029', '3100031', '6100280', '6100272', '6100271', '6200191', '5200484', '6100274', '5100432', '5100427', '5100424', '5100440', '4100037', '4100036', '2100065')
For UMS_DTS_BOT_PROJ_STATUS_REP_JM:
- Same as above except PROJECT_ID in list ('2100068', '3100030', '4100027', '4100028', '5100316', '6100237', '6100250', '3100029', '3100031', '2100065', '2100035', '2100039', '3100026', '4100026', '5100357', '5100358', '5100361', '5100362', '5100379', '6100195', '6100236', '6100238', '6100240', '7100009', '6100246')
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 adjustment. Please contact the Change Management /Systems Security Analyst at 581-5420.
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.