Table which store users who have not submitted time sheet

Ravi Kumar Nara
Tera Contributor

Hi All,

 

Please let me know if there is any table which would store timesheet user's who have not submitted timesheet.

 

Appreciate your response.

 

Regards

Ravi.N 

1 REPLY 1

martinjanke
Kilo Guru

Hi,

 

I' m not sure there is a table, but you can get this information in a report.

 

Report on table sys_user. Configure the filter to include all users which should submit a timesheet, e.g. active=true and roles is pps_resource - whatever is applicable in your case. 

Add a related list condition for the table Time Sheet->User, with "Equal to 0 selected table records" and some additional conditions to select specific week(s) and time sheet states. That should list all users who have not submitted any timesheet in the selected week(s)

 

martinjanke_1-1674651209849.png