Project and Portfolio Management Practitioners Forum
cancel

display the financial management settings of projects in a list

SOLVED
Go to solution
Highlighted
Erik Cole
Acclaimed Contributor.

display the financial management settings of projects in a list

Does anyone have a query to display the financial management settings of projects in a list? I can see settings such as CE.rollupCostsToBudget in itg_settings_attributes but I can't seem to figure out how to relate these rows back to a project/proposal/asset...

2 REPLIES
dirkf
Acclaimed Contributor.
Solution

Re: display the financial management settings of projects in a list

Hi Eric,

 

not specifically for Financial Management, but the following query should help you for all the project settings I think:

 

select *
from itg_settings_attributes at, itg_settings_containers cont, itg_settings_cont_attrs al, pm_project_types pt
where al.settings_attribute_id = at.settings_attribute_id and pt.pt_settings_key = cont.settings_container_id
and cont.settings_container_id=al.settings_container_id  
order by attr_map_key

 

Hope this helps.

Best regards,

Dirk

Erik Cole
Acclaimed Contributor.

Re: display the financial management settings of projects in a list

Hi Dirk...thanks, I'll have to look into this further. For now, I am using the following to find out which projects have been set to roll up costs to their financial summary automatically:

 

select p.project_name ,ps.attribute_name,ps.attribute_value
from pm_projects p
join pm_work_plans wp on (wp.project_id = p.project_id AND wp.entity_type = 'WORK_PLAN')
join wp_tasks t on (t.work_plan_id = wp.work_plan_id and t.sequence_number = 0)
join kdrv_project_setup ps on ps.source_id = t.task_id and ps.source_entity_id = 6
where 1=1
and ps.attribute_name like 'CE.rollupCostsToBudget'
and ps.attribute_value != 'MANUAL'
order by 1,2