- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-09-2020 08:20 AM
What is/are the specific criteria for a time card data to be entered into the Time_Card_Exception table vs Time-Card table?
Solved! Go to Solution.
- Labels:
-
Time Card Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2020 11:45 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
I know this post is about five years old, but I’m hoping someone might still be able to help.
I’m running into an issue where a user is added to the timecard_user role, but when I check the Timesheet Exception report, it shows that they have timesheets from before their actual start date and before the role was assigned.
Example:
- User's physical start date: 10/01/2025
- User added to timecard_user role: 10/10/2025
- The report generated the following week shows the user with timesheets dating back to September, which is before they started and before the role was assigned.
Is there a place I can look to understand the logic behind how these older timesheets are being generated for a new user? Any insight would be appreciated.
