Search Tags: advancement
JIRA Reference:
DM-288
-
USM Advancement Report 3 Journal Entries
Closed
Report Purpose
This report provides the journal entry for University of Southern Maine advancement.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_UMS06_ADV_JOURNAL
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
- JOURNAL_DATE from and to
Data Fields Generated
| FISCAL_YEAR | ACCOUNTING_PERIOD | FUND_CODE | DEPTID | DEPTID_DESCR | ACCOUNT | CLASS_FLD | ACCT_DESCR | PROGRAM_CODE | PROGRAM_DESCR | PROJECT_ID | MONETARY_AMOUNT_SUM | LINE_DESCR | LONG_DESCR | SOURCE | JRNL_LN_REF | JOURNAL_ID | JOURNAL_DATE | POSTED_DATE | JOURNAL_LINE | OPRID | NAME |
|---|
Tables Used
UM_JRNL_APPR_VW
Criteria Used
- DEPTID between 6500000 and 6599999
- DEPTID NOT in ('6500004','6500015','6500016','6500017','6505000','6506000')
- FUND_CODE NOT in ('11','21','31','51','90')
- BUSINESS_UNIT = UMS06
- STATISTICS_CODE = ' '
- UNPOST_SEQ - UnPost Sequence = 0
- KK_AMOUNT_TYPE - Commitment Control Amount Type NOT in ('2','3')
- JRNL_LINE_SOURCE - Journal Line Source <> 'CLO'
- JRNL_HDR_STATUS - Journal Header Status = P
- LEDGER_GROUP = ACTUALS
- ACCOUNT between 40000 AND 89999
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.