Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Actual effort value in timesheet

Highlighted
bsbabu
Super Contributor

Actual effort value in timesheet

Hi all,
When we are entering the timesheet we get to see actuals effort column which is sum of efforts entered by all the resources for the particular task.
Can any one tell me that whether this value is being stored in database or being calculated on the fly.
If it is stored can you tell me which table it is being stored.
If it is being calculated on what table values are being used for this calculation.

Regards,
Sridhar
2 REPLIES
Erik Cole
Honored Contributor

Re: Actual effort value in timesheet

Hi,

Actual Effort on the time sheet line is not the sum of efforts entered by all the resources for the task, but rather the sum of efforts entered by _that_ resource for the task.

I believe this is stored in ITG_COMPRESSED_ELEMENTS where owner_type = 'ACTUAL_EFFORT' and owner_id joins to RSC_RESOURCE_ASSIGNMENTS
bsbabu
Super Contributor

Re: Actual effort value in timesheet

Hi Erik,
Thanks for the reply.
I couldn't find the entry of the actual effort, in the table you have mentioned, for the timeperiod i have submitted the timesheet. Any other view on this?

Regards,
babu
//Add this to "OnDomLoad" event