Project and Portfolio Management Practitioners Forum
cancel

Time sheet closure date

Highlighted
tony sanchez_1
Valued Contributor.

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
Acclaimed 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
Valued Contributor.

Re: Time sheet closure date

Yes, I am looking for the location in the DB