Project and Portfolio Management Practitioners Forum
cancel

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

SOLVED
Go to solution
Highlighted
Greg_S
Super Contributor.

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
Acclaimed 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
Super Contributor.

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

Awesome: I never would have guessed this - Thanks!
AlexSavencu
Acclaimed 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