Search Tags: transfer, UMS accounting
JIRA Reference:
DM-267
-
Transfer check
Closed
Report Purpose
This report provides data for transfer accounts by fiscal year and accounting period, and is used by the UMS Accounting Office.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_TRANSFER_CHECK
Report Type
SQR
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| FISCAL_YEAR | ACCOUNTING_PERIOD | ACCOUNT | FUND_CODE | ACCT_DESCR | TRANSFER_TYPE | ACTUALS_YTD | COMMENT |
|---|
Tables Used
Criteria Used
ACCOUNT between 70000 and 89999
Special Expressions
*-TRANSFER_TYPE*/
CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END
/*-COMMENT */
CASE WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '00&03' THEN 'Research'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '00&16' THEN 'Research'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '00&20' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '00&28' THEN 'Disallowed'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '03&10' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '03&16' THEN 'Research'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '03&20' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '03&23' THEN 'Disallowed'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '04&20' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '04&28' THEN 'Disallowed'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '10&20' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '10&23' THEN 'Research'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '10&28' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '12&20' THEN 'Disallowed'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '12&22' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '15&15' THEN 'Research'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '15&20' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '15&28' THEN 'Disallowed'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '18&20' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '18&23' THEN 'Disallowed'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '18&28' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '20&31' THEN 'Disallowed'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '21&31' THEN 'Disallowed' WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE
THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '28&50' THEN 'Disallowed'
WHEN ( CASE WHEN ( SUBSTR(A.ACCOUNT,2,2) ) < A.FUND_CODE THEN ( SUBSTR(A.ACCOUNT,2,2) ) || '&' || A.FUND_CODE
ELSE A.FUND_CODE || '&' || ( SUBSTR(A.ACCOUNT,2,2) ) END ) = '31&51' THEN 'Disallowed' ELSE ' ' END
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.