RJIRA Reference:
REPORT-534
-
UMS_UGRD_UM_DIST_RULES Public query in HRPRD
Closed
Report Purpose
This report is used to track the account updates for the UMS Special Distribution Tracking Pages in HR. When Federal Work Study Funding Programs are assigned to new projects for each academic year, Finance creates the new projects in FNPRD, and the tables in HR must be manually updated to link to these new projects.
The updates are verified with this query, and it documents the account structure for payroll for their reference.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Human Resources - Production > NavBar (compass icon, top right) > Navigator > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_UGRD_UM_DIST_RULES
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| BUSINESS_UNIT | UM_DS_CATEGORY | DIST_CAT_TITLE | DIST_CAT_DETAIL | UM_FND_DEPT | Fnd FND CD | UM_FND_GL_ACCT | UM_FND_PROJECT | FND_ACCOUNTING_ID | UM_FND_PCT | UM_NOT_FND_DEPT | UM_NOT_FUND_FUND | UM_NOT_FND_ACCOUNT | NOT_FND _ACCOUNTING_ID | UM_NOT_FND_PCT |
|---|
Tables Used (For DARTS users only)
- UM_DIST_RULES - UM Work Study Distrib Rules
- UM_DIST_CAT - UM Work Study Distrib Category
- ACCT_CD_TBL - Account Codes
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.