question Re: Timecard Exception Table vs Time Card Table in SPM forum

Timecard Exception Table vs Time Card Table

DJM1 — Mon, 09 Mar 2020 15:20:21 GMT

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

Re: Timecard Exception Table vs Time Card Table

nataliya_b — Mon, 09 Mar 2020 17:26:01 GMT

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

Re: Timecard Exception Table vs Time Card Table

DJM1 — Mon, 09 Mar 2020 18:02:36 GMT

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.

Re: Timecard Exception Table vs Time Card Table

nataliya_b — Tue, 10 Mar 2020 13:43:52 GMT

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.

Re: Timecard Exception Table vs Time Card Table

M Ashwath Kumar — Tue, 10 Mar 2020 18:45:05 GMT

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

Re: Timecard Exception Table vs Time Card Table

Timbur256 — Thu, 23 Oct 2025 19:57:15 GMT

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.