The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Tommy Vu
Occasional 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
Honored 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
Occasional Contributor

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

how does these table joins together?
Vibhor Dwivedi
Regular Collector

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
Occasional 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
Frequent Visitor

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
Occasional Contributor

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

Thanks so much for all of your helps.
//Add this to "OnDomLoad" event