AnsweredAssumed Answered

Timesheet Submit date

Question asked by fabricio.de.marchi on Aug 4, 2011
Latest reply on Aug 4, 2011 by fabricio.de.marchi
Hi All,

I am trying to figure out where can I get the submit date of a timesheet. By Submit I mean the date and time the user has clicked the "Submit" button to send his timesheet to be reviewed by his manager.

If that is not available by default, anyone knows of a simple way to do it? I was thinking about adding a trigger to the PRTIMEENTRY table and look for that information to store in a custom table. Not sure if that is the correct table yet, still have to investigate maybe I will have to do that at the PRTIMESHEET table instead.

If that is not possible I believe the POSTED_TIME in the PRTIMESHEET table, which indicates when the manager has approved the timesheet (is that correct?), should be good enough.

Thanks,

Fabrício De Marchi

Outcomes