Table which store users who have not submitted time sheet

[Ravi Kumar Nara]

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 

[martinjanke]

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)