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:

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.