Timecard Exception Table vs Time Card Table

[DJM1]

What is/are the specific criteria for a time card data to be entered into the Time_Card_Exception  table vs  Time-Card table? 

[nataliya_b]

time card exception is not table

it is a report based on sys_user table that provides the list of users who did not submit time sheet/card for specific time period

there is ootb report for last week, thus user list who did not submit ('pending') timesheet/card for the last week

[DJM1]

Thank you for your response.  

I apologize.  The tables that I'm asking about are Time_Sheet and Time_Sheet_Exception.    You can see them on the Report page.

[nataliya_b]

I cannot see your image. The idea is the same

your timesheet exceptions report has the user list (sys_user table) who's timecards are not submitted. if you go to Reports and search for Time Card Exceptions (Last Week) report, you could see how it configured.

[M Ashwath Kumar · Accepted solution]

Hello djm

Timesheet: It is a collection of timecards per a week i.e., you can have only one timesheet per week for a particular user, a timesheet can have n number of timecards such as admin, project task, support and so on.

Timesheet Exception: This is just a table used for reporting. It contains the timesheets of users who did not submit their timesheet for any particular week. So that project managers or user managers can follow up on users why they did not submit the timesheets. And records are inserted into this table only if the user has timecard_user role and the manager field is not empty on the user record.

Hope this answers your question, Please mark it as correct if it does. Thanks!

Regards

Ashwath