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: 

For SQL query: Where can I pull Business Unit, Project Class, Asset Class?

SOLVED
Go to solution
Highlighted
Greg_S
Collector

For SQL query: Where can I pull Business Unit, Project Class, Asset Class?

I'm trying to write a SQL query for a portlet on open Projects, having trouble finding a few fields.

Where can I pull Project Manager, Business Unit, Project Class, Asset Class, Planned Start/Finish dates?

 

Here's a sample of what I have:

select p.pfm_request_id PROJ_Num, p.project_name
from
pm_projects p,
WP_TASKS tsk,
pm_work_plans wkp
where
    tsk.work_plan_id = wkp.work_plan_id
AND wkp.project_id = p.project_id
order by tsk.last_update_date

3 REPLIES
Erik Cole
Honored Contributor
Solution

Re: For SQL query: Where can I pull Business Unit, Project Class, Asset Class?

Hi Greg,

 

Have a look at the kcrt_fg_pfm_project table.

Greg_S
Collector

Re: For SQL query: Where can I pull Business Unit, Project Class, Asset Class?

Awesome: I never would have guessed this - Thanks!
AlexSavencu
Honored Contributor

Re: For SQL query: Where can I pull Business Unit, Project Class, Asset Class?

Greg,

You don't need to guess such things if you do a simple search in the Data Model document, which is bundled with PPM.

Cheers
Alex

--remember to kudos people who helped solve your problem
//Add this to "OnDomLoad" event