JIRA Reference:
REPORT-460
-
How to return last distribution using UM_DISTRIB_DTL in HRPRD
Closed
Report Purpose
This report is used to return the final distributions, with sequence numbers, that have ended before payroll runs for grant funded accounts. They return last distribution for active employees paid within the preceding two months.
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
USM_MUSKIE_DIST_LAST is additionally limited by HR College "PPP."
UMS_DTS_DIST_LAST_EMPLID is additionally limited by EMPLID prompt.
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| EMPLID | EMPL_RCD | NAME | POSITION_TITLE | REG_TEMP | FTE | FULL_PART | EMPL_CLASS | DEPTID | HR_DEPARTMENT | LAST_PAY_END_DT | EXPECTED_END_DT | START_DT | END_DT | ERNCD | ADDL_SEQ | SEQNO | DIST_PCT | ACCT_CD | ACCT_CD_DESCR | DEPTID_CF | FUND_CODE | ACCOUNT | PROGRAM_CODE | PROJECT_ID | OPER_UNIT | PRODUCT | CLASS_FLD |
|---|
Tables Used (For DARTS users only)
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.