Discoverer Migration
DM-214
-
Active Job has Benefits Primary Job Flag of "N"
Closed
REPORT-345
-
UM_FGLEMPLOY_VW is missing active records
Closed
Report Purpose
A simplified data verification query that returns active job rows where the JOB is Active and the Primary Job Indicator is set to 'N'.
This verification aligns with current data entry practices.
This verification has been added to the Payroll MAC Report (an SQR that documents required data corrections) which payroll runs on demand to make data corrections.
This PS Query version is scheduled to run once a month to monitor the MAC Report correction processing. Unaddressed issues in this data affects the correct population of all of the employee flat files.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Campus Solutions-92-Reporting > PS Query tile > Query Manager or Query Viewer
Note - If your CSRPT Reporting Homepage dashboard does not have a PS Query tile, contact the UMS - Campus Solutions Security Liaisons for your institution.
Report Name/Type
UM_F_EMPLOYE_VW_PRI_FLAG
Query
Prompts Required
None
Data Fields Generated
| BUSINESS_UNIT | EMPLID | EMPL_RCD | UM_FORMATTED_NAME | EMPL_STATUS | JOB_INDICATOR | PRIMARY_JOB_IND | UM_EMPL_CLASS_DESC | UM_LAST_PAY_END_DT | Reg/Temp |
|---|
Tables Used
New to PeopleSoft Query?
Click on Getting Started and begin with the Query Basics video
Need help running a query?
Click on Running Reports with Query Viewer & Query Manager for a quick how-to guide for navigating to PS Query and running a report.
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.