The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Time sheet closure date

Highlighted
tony sanchez_1
Super Collector

Time sheet closure date

Is there any way of determining when a time sheet was truly closed ?

We can examine tm_time_sheets to see the last update date but if someone has gone into the UI and viewed the timesheet, the last update date is set to this date and you can no longer tell the true close date.

examining ITG_AUDIT_EVENTS only shows when the timesheet was approved
2 REPLIES
Sascha Mohr
Esteemed Contributor

Re: Time sheet closure date

Hello Tony,in the time sheet you will find a transaction history for the time sheet and the individual time sheet lines. Would that be what you are looking for or do you need to know the location in the DB?
tony sanchez_1
Super Collector

Re: Time sheet closure date

Yes, I am looking for the location in the DB
//Add this to "OnDomLoad" event