Table which store users who have not submitted time sheet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2023 02:00 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2023 04:56 AM
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)