Search Tags: delaware, hr 

JIRA Reference:   IR-10 - Delaware Study Issues/Projects Master Ticket Done

Report Purpose

These two reports pull HR data for full-time and part-time faculty for the Delaware Study for system IR. 

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_ERNCD_PROMPT_TEMP (part-time)
UMS_ERNCD_PROMPT_FULLTIME

Report Type

Query

Prompts Required


Data Fields Generated

UnitEstab IDIDEmpl RecordNameSum EarningsEarn CodeERNCD DescrUnion CD DescrReg/TempEmpl Class DescTenure DescrTitlePosition DescrAcctDept IDProjectFundFringe RateAccount DescrDeptid DescrProject DescrFund DescrFTEUM TOTAL FTESex

Tables Used

UM_PAYEARNS_VW

UM_F_EMPLOYE_VW - Employee Flat Table

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!

Round, red help button. Click to email DARTS.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.