“Error Message” column added to M_TL_RAPIDTIME_SESSION_INFO query

posted Dec 4, 2017, 4:34 PM by Peyri Herrera
NEW!

For Rapid Time users 

A new Error Message field has been added to the end of the M_TL_RAPIDTIME_SESSION_INFO - Rapid Time Session Information query to help identify time entries with a Date Under Report (Rpt Dt) that can cause the submitted Session to get a “No Success” error.
 
M_TL_RAPIDTIME_SESSION_INFO

The best practice is to run the M_TL_RAPIDTIME_SESSION_INFO query after you have uploaded the time entries from the Rapid Time Excel/CI Spreadsheet to the Rapid Time screen and before you submit the Rapid Time entries to Time & Labor for processing and loading onto the Timesheet screen, like this:

M_TL_RAPIDTIME_SESSION_INFO Process

Download the M_TL_RAPIDTIME_SESSION_INFO query results to Excel then filter the Error Message column to look for errors. The query error messages are:
  • Rpt Dt BEFORE Position Start Date (Hire). This error means the date of the time worked is before the employee’s hire date on the Job Data screen. 
  • Rpt Dt AFTER Term Date. This error means the date of the time worked is after the employee’s termination date on the Job Data screen. 
  • Rpt Dt AFTER Inactive Time Rprtr Eff Date. This error means the date of the time worked is after the employee’s Inactive Time Reporter Data screen effective date. 
  • Rpt Dt BEFORE Active Time Rprtr Eff Date. This error means the date of the time worked is before the employee’s Active Time Reporter Data screen effective date. 
  • Blank field. This indicates no error.
Rapid Time entries containing errors need to be corrected before submitting them to Time & Labor otherwise they will cause the Session to fail with a “No Success” error. The Error Message field will be blank if no errors are found. If there are no errors found you can proceed with submitting the Rapid Time entries to Time & Labor for processing and loading onto the Timesheet screen.