1 of 15

Using HCM queries to find errors/issues before Payroll is run

Presented by Jason Cohee

August 20, 2020

2 of 15

Overview

  • M_TL_PAYABLE_TIME_AUDIT for timesheet transactions
  • M_PY_CALC_ERROR_MSGS_BY_DIST query to isolate and resolve errors
  • M_TL_RAPIDTIME_SESSION_INFO query can be used to find errors within a Rapid Time session
  • M_PY_PAYLINES_SUBSETS When processing off-cycles - to confirm subsets are set as needed.
  • M_AM_UNAPPROVED_ABSENCES To ensure all absence transactions are approved, shows those which are unapproved.
  • M_PY_OK_Y_433 Helps to identify paylines with the Okay to Pay checked that also have 4.33 hours set to pay (Generally incorrect and should not be paid).
  • M_HR_MORE_PRIMARY_JOB_FLAG Isolate and resolve employee records with more than one primary job.
  • M_HR_NO_PRIMARY_ONEJOB Isolate and resolve employee records with no primary job defined.
  • M_BN_BEN_PROG_JOB_DATA Snapshot of critical HR data that impacts benefits.

2

3 of 15

�M_TL_PAYABLE_TIME_AUDIT Query ��

3

4 of 15

�

  • Can be used to:
    • Validate timesheet entries are paying
    • Validate timesheet entries will pay
    • Resolve or review “Reject by Payroll” rows.
    • Explain why you are receiving the “Employee is Terminated” error.

​

​

4

M_TL_PAYABLE_TIME_AUDIT Explained

5 of 15

�

5

M_TL_PAYABLE_TIME_AUDIT Example

6 of 15

�M_PY_CALC_ERROR_MSGS_BY_DIST �Query ��

6

7 of 15

�

  • Details on errors available here: http://crc.sdcoe.net/announcements/peoplesoftnews/runthempycalcerrormsgsbydistaftereachnightofpayrollcalc
  • Common Errors:
    • Invalid One-Time Deduction
    • Too Many Primary Jobs/No Primary Job
    • Employee is Terminated
    • Earnings Went Negative/Negative Gross Pay
    • No active Job for Earnings

​

7

M_PY_CALC_ERROR_MSGS_BY_DIST -

How can this help? It can save a paycheck!!

8 of 15

�

8

M_PY_CALC_ERROR_MSGS_BY_DIST –

Query Example

9 of 15

�

9

M_PY_CALC_ERROR_MSGS_BY_DIST –

Query Example

10 of 15

�M_TL_RAPIDTIME_SESSION_INFO �Query ��

10

11 of 15

�

  • Used to validate data within a Rapid Time session BEFORE that data is submitted to timesheets.
    • Allows resolution of errors which would lead to the process failing – VERY BAD!
    • Helps to catch minor date related errors which would lead to time not paying/processing and/or save you from manually fixing the entry on the timesheet.

11

M_TL_RAPIDTIME_SESSION_INFO Explained

12 of 15

�

    • M_PY_PAYLINES_SUBSETS
      • When processing off-cycles - to confirm subsets are set as needed.
    • M_AM_UNAPPROVED_ABSENCES
      • To ensure all absence transactions are approved, shows those which are unapproved..
    • M_PY_OK_Y_433
      • Helps to identify paylines with the Okay to Pay checked that also have 4.33 hours set to pay (Generally incorrect and should not be paid).

​

​

12

Additional Helpful Queries

13 of 15

�

    • M_HR_MORE_PRIMARY_JOB_FLAG
      • Isolate and resolve employee records with more than one primary job.
    • M_HR_NO_PRIMARY_ONEJOB
      • Isolate and resolve employee records with no primary job defined.
    • M_BN_BEN_PROG_JOB_DATA
      • Snapshot of critical HR data that impacts benefits.

13

Additional Helpful Queries

14 of 15

Closing Notes and Suggestions

  • Scheduling Queries:
    • Saves significant time, avoids a timeout due to query output size/data and allows you to continue working while it processes.
    • Scheduling PeopleSoft Queries and Reports
  • More queries available in the Query Reference Guide:

14

15 of 15

�

15