Project and Portfolio Management Practitioners Forum
cancel

Project Management - Where to pull the percent complete for a project?

Highlighted
Tommy Vu
Valued Contributor.

Project Management - Where to pull the percent complete for a project?

I am new to this Project Management, I want to pull the percent complete for project. What table can i get this information from?
any documents that will help me to understand the project management data is greatly appreciated.
6 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Project Management - Where to pull the percent complete for a project?

WP_TASK_ACTUALS

You would need to join (back up the hierarchy) to WP_TASKS, PM_WORK_PLANS, PM_PROJECTS

The top-level task (SEQUENCE_NUMBER = 0) contains the % complete for the entire work plan.
Tommy Vu
Valued Contributor.

Re: Project Management - Where to pull the percent complete for a project?

how does these table joins together?
Vibhor Dwivedi
Super Contributor.

Re: Project Management - Where to pull the percent complete for a project?

SELECT WTA.PERC_COMPLETE, PP.PROJECT_ID, WT.TASK_ID
FROM PM_PROJECTS PP, WP_TASK_ACTUALS WTA, WP_TASKS WT, PM_WORK_PLANS PWP
WHERE PWP.PROJECT_ID = PP.PROJECT_ID
AND WT.WORK_PLAN_ID = PWP.WORK_PLAN_ID
AND WTA.ACTUALS_ID = WT.TASK_ACTUALS_ID
ORDER BY PP.PROJECT_ID, WT.TASK_ID;

i hope it will help u

Tommy Vu
Valued Contributor.

Re: Project Management - Where to pull the percent complete for a project?

Thanks so much, do you have any documents that will help me understand the data relationship for the project management?
hyllplan
Honored Contributor.

Re: Project Management - Where to pull the percent complete for a project?

There is a document called DataModel something, check:
http://support.openview.hp.com/selfsolve/manuals
Regards,
Johan
Tommy Vu
Valued Contributor.

Re: Project Management - Where to pull the percent complete for a project?

Thanks so much for all of your helps.