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