Created by Miki Yanagi, last modified by Cori Schneider on Sep 24, 2019

Search Tags: payroll, earnings, distribution, wages, HR

JIRA Reference:   DM-156 - Dist Review Closed

                            DM-164 - Paid wages by FY and emplid BI Tool

                             DM-87 - Regular2 wages by FY and emplid2 Closed  

                             BI-3 - HR Reports for BI tool Open

Report Purpose

Provides payroll paid wages data by Pay Period, EMPLID or Fiscal Year. It is prompted by campus, but only for UMA, UMF, UMFK, UMM, UM, USM, UMPI or SWS.

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

  1. UMS_DTS_HR_PAID_WAGES_DATE -- Use this report to search by dates (Pay period end)
  2. UMS_DTS_HR_PAID_WAGES_ID -- Use this report to search by EMPLID
  3. UMS_DTS_HR_PAID_WAGES_FY -- Use this report to search by Fiscal Year and Fund Code

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

  1. UMS_DTS_HR_PAID_WAGES_DATE
    1. PAY_END_DT from
    2. PAY_END_DT to
    3. Campus: Limited to UMA, UMF, UMFK, UMM, UM, USM, UMPI or SWS (Case statement was created based on DEPTID_CF.)
  2. UMS_DTS_HR_PAID_WAGES_ID
    1. Fiscal Year
    2. EMPLID
  3. UMS_DTS_HR_PAID_WAGES_FY
    1. Fiscal Year
    2. Fund code
    3. Campus: Limited to UMA, UMF, UMFK, UMM, UM, USM, UMPI or SWS (Case statement was created based on DEPTID_CF.)

Data Fields Generated

1.  UMS_DTS_HR_PAID_WAGES_DATE

FISCAL_YEARPAY_PERIOD_ENDCAMPUSEMPLIDNAMEDEPTIDFUND_CODEACCOUNTACCT_DESCRCOMBO_CODEACCTCD_DESCRSUM_EARNINGSEARN_CODEERNCD_DESCRPOSITION_NBRPAYGROUP


2.  UMS_DTS_HR_PAID_WAGES_ID

FISCAL_YEARPAY_PERIOD_ENDCAMPUSEMPLIDNAMEDEPTIDFUND_CODEACCOUNTCOMBO_CODEACCTCD_DESCRSUM_EARNINGSEARN_CODEPOSITION_NBR


3.  UMS_DTS_HR_PAID_WAGES_FY

FISCAL_YEARCAMPUSEMPLIDNAMESUM_EARNINGSDEPTIDEARN_CODEERNCD_DESCRACCOUNT


Tables Used

UM_PAYEARNS_VW

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.