New Compensation Split query available for HR & Payroll users

posted Jun 19, 2018, 5:21 PM by Peyri Herrera
NEW
 
After a paycheck becomes available in PeopleSoft Employee Self-Service (ESS), employees can view the Compensation Split page in ESS to view their earnings in greater detail. Multiple Components of Pay (MCOPs), additional pays, stipends, payroll earnings, and items which add to the total gross are listed as line items with corresponding values.

Here is a sample Compensation Split for February 2018 as seen by Employee ID 28445 in ESS:
Compensation Split for February 2018

Effective June 18, 2018, district office staff with Payroll or Human Resources roles can run the M_PY_COMPENSATION_SPLIT query to see the same information viewed by the employees on the Compensation Split screen in ESS.

Here are sample query results for the February 2018 paycheck for Employee ID 284453. Notice how they match exactly what the employee sees in ESS.
M_PY_COMPENSATION_SPLIT query

Notes for using the M_PY_COMPENSATION_SPLIT query:
  • There are three prompts. The first, Company (Co), is a required field. Example: 099 
  • You can run the query for the following scenarios: 
    • For 1 employee for 1 pay period – Enter Prompts 1, 2, 3 
    • For 1 employee for all pay periods for which he or she had a PeopleSoft paycheck produced – Enter Prompts 1, 2 
    • For all employees for 1 pay period – Enter Prompts 1, 3 
    • For all employees for all pay periods – Enter Prompt 1 
  • A Payroll or HR role is required to run this query: M_HR_JOB_DATA, M_HR_JOB_DATA_RDO, M_HR_JOB_EDIT_ONLY, M_HR_JOB_EMPL_DATA, M_HR_JOB_EMPL_DATA_RDO, M_HR_JOB_RDO, M_HR_PERSON_CONTACT, M_HR_PERSON_CONTACT_RDO, M_HR_SPECIALIST, M_HR_SPECIALIST_RDO, M_PAYROLL_ADMINISTRATOR, M_PAYROLL_ADMINISTRATOR_RDO, M_PAYROLL_CBO, M_PAYROLL_CBO_RDO, M_PAYROLL_SPECIALIST, M_PAYROLL_SPECIALIST_RDO, M_RECRUITER, M_RECRUITING_HIRING_MANAGER, M_RECRUITING_MANAGER, M_RECRUITMENT_ADMINISTRATOR 
Related links: