JIRA Reference:
Report Purpose
The report provides each actual transaction by dates, fund, program, project, department, or account.
It is recommended to use the scheduler or to limit criteria (eg. very narrow date range) since this report gets very large.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_OPERATING_DETAIL
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt. Leave the prompt blank if you would like to get all data except journal dates.
- Journal Date (From / To)
- Fund Code
- Program Code
- Project ID
- Account (From / To)
- Business Unit
- DEPT_CR_2
- DEPT_CR_3
- DEPTID
Data Fields Generated
| Fiscal Year | Acct Period | Dept_Cr_2 | Dept_Cr_3 | Deptid | Deptid Descr | Fund | Program | Program Descr | Proj Id | Proj Category | Proj Descr | Proj Mgr ID | Proj Mgr Name | Proj Status | Proj Start Date | Proj End Date | Acct Grp | Acct Cat | Acct Subcat | Account | Acct Descr | Class | Line Descr | Amount | Jrnl Date | Jrnl ID | Jrnl Ln Ref | Jrnl Descr |
|---|
Tables Used
Criteria Used
- B.LEDGER_GROUP = 'ACTUALS'
- B. KK_AMOUNT_TYPE not in list ('2', '3') - 2= Encumbrance and 3= Pre-encumbrance
- A. ACCOUNTING_PERIOD between 1 and 12
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.