Clarity

Hi,

I'm looking for option in Clarity to check who approved timesheet for external users. After timesheet has been posted under timesheet i can see Approved by process administrator because of posting process...

Do anybody knows if this data (who approved timesheet) are stored somewhere in DB or for something like that is necessary some customization?

Peter

You do have the right field already - when a timesheet is POSTED it does not affect this "Approved By" value (it does affect the last_updated_by value though).

So if your contractor timesheets say "Approved by process administrator" then you will have a process somewhere that is approving those timesheets - not a actual user!

(PRTIMESHEET.PRAPPROVEDBY is the field on the database which contains the user id of the approver).

Some further discussion here ; Timesheet approver

Hi Dave,

you're right, there is a process behind which approves it.

Thanks for advice

The approver is stored in prtimesheet.PRAPPROVEDBY, but that is the same as is displayed in the GUI and should be the same as before posting the timesheet.
If you see process admin then there are not many options.
If the process is run automatically that would be always the same user, but if it is run on demand and run by a real user you would get that info from the process instance.

Martti K.

another_martink wrote:

The approver is stored in prtimesheet.PRAPPROVEDBY, but that is the same as is displayed in the GUI and should be the same as before posting the timesheet.
If you see process admin then there are not many options.
If the process is run automatically that would be always the same user, but if it is run on demand and run by a real user you would get that info from the process instance.

Martti K.

Martti you're right (again :smile ),

process is initiated by user so it should be possible somehow link process instance with timesheet. I need to investigate how it is connected in DB to get complex result which i need.

Peter

If that is the case in the best case you could modify the process to write the value of the approver to a custom object.

Martti K.

OK yes - if you are using the OOTB "PM approval process" to approve timesheets, then the thing you need to track down would be the ACTION ITEM that was sent to the "PM" to confirm approval of the timesheet (and there could well be multiple approvers). You should have a real strong clue to start from if you are using the OOTB process though, since it will just be the PM(s) of the projects on the timesheet!

If you are using some custom process, then you would need to look at the custom logic in that process to work out how/why that timesheet gets approved.

Many thanks both of you..

our client have to decide if it's necessary for them or no ...

Peter