JIRA Reference:
Report Purpose
These reports return the years of service of employees, as of the last day of each calendar year in five year increments. Data returned can be filtered by Department Code to find specific entries. This query is frequently used to determine longevity awards. Requires annual updating. Contact darts@maine.edu.
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_SERVICE_DATE_FOR_AWARDS - returns College, Director, Dean, etc. specific to USM
- UMS_SERVICE_DATE_FOR_AWARDS - basic report for use by all institutions
Report Type
Query
Prompts Required
None
Data Fields Generated
1.
| UNIT | EMPL_CLASS | EMPLID | NAME_SORT | NAME | TITLE | POSITION_DESC | DEPTID | DEPARTMENT | UMS_COLLEGE | USM_COLLEGE | DIVISION_HEAD | DIVISION_HEAD_EMAIL | SENIOR_STAFF | SENIOR_STAFF_EMAIL | REG_TEMP | HIRE_DATE | SERVICE_DATE | PAYGROUP | SERVICE_AS_OF_12/31/2018 | SUPERVISOR_LAST_NAME | SUPERVISOR_LAST_NAME | SUPERVISOR_NAME | SUPERVISOR_TITLE | SUPERVISOR_ADDRESS | SUPERVISOR_CAMPUS | SUPERVISOR_EMAIL | EMPLID | POI Cat. | POI_TYPE | POI_UNIT | BEGIN_DT | END_DT | COMMENTS |
|---|
2.
UNIT | EMPL_CLASS | EMPLID | NAME_SORT | NAME | TITLE | POSITION_DESC | DEPTID | DEPARTMENT | UMS_COLLEGE | REG_TEMP | HIRE_DATE | SERVICE_DATE | PAYGROUP | SERVICE_AS_OF_12/31/2018 | SUPERVISOR_LAST_NAME | SUPERVISOR_LAST_NAME | SUPERVISOR_NAME | SUPERVISOR_TITLE | SUPERVISOR_ADDRESS | SUPERVISOR_CAMPUS | SUPERVISOR_EMAIL | EMPLID | POI Cat. | POI_TYPE | POI_UNIT | BEGIN_DT | END_DT | COMMENT |
|---|
Tables Used
- 1.UM_F_EMPLOYE_VW - Employee Flat Table
- UM_PER_POI left outer joined with A
- UM_POI_CAT_TBL - POI category table left outer joined with B
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.