Project and Portfolio Management Practitioners Forum
cancel

Scheduled Effort by Resource, Task, Week

Highlighted
pepdwill
Honored Contributor.

Scheduled Effort by Resource, Task, Week

Hello,

 

Scheduled effort by resource/task/week is an important metric for some reporting we need to do.  Within PPM however, it seems quite difficult and/or impossible to obtain this data.  I have skimmed through all existing database views and functions but wasn't able to find anything that looked usable, though I mave have missed something.

 

Can anyone suggest a way to do this?  If there is any existing SQL or database function that I can leverage, please let me know.

 


Thanks!

 

Danny

1 REPLY
randull
Acclaimed Contributor.

Re: Scheduled Effort by Resource, Task, Week

Hi Pepdwill,

 

You can find the scheduled effort on the Analyze Assignment Load portlet. Also, you can find it on the following tables.

 

KCRT_FG_WORK_ITEMS

KCRT_FG_WORK_ITEMS_INT

KCRT_REQUEST_RSC_ACTUALS

KRSC_WORK_ITEM_ASSIGNMENTS

WP_TASK_SCHEDULE

Best regards,
Randall

-- Remember to give Kudos to answers! (click the KUDOS star)
"If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”