Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

which table stores stakeholder information

Highlighted
eata
Regular Collector

which table stores stakeholder information

Hello;

I want to learn at what time a user selected as participant from configure participant> stakeholders > add stakeholder.

Which table stores this information?

Do you have sample query?

6 REPLIES
TurboMan
Member

Re: which table stores stakeholder information

Hi eata,

 

You can find ou in the Model Guide the tables

which are 

krsc_org_unit_members knta_users krsc_org_units

 

Hope it helps

 

Utkarsh_Mishra
Honored Contributor

Re: which table stores stakeholder information

Hi Eata,

 

 

You can use any of these functions to get the Project Stakeholder list/name. You only need to pass the project ID in the HP Provided out of the box package.

 

Oracle Package Name - PM_UTILS

 

  1. Get delimited list of user ID's for all stakeholders of the specified project

    select PM_UTILS.get_prj_stakeholders(<project ID>) from dual  

  2. Get delimited list of all project stakeholder usernames for the specified project 

     select PM_UTILS.get_prj_stakeholder_usernames(<project ID>) from dual

  3. Get delimited list of all project stakeholder full names for the specified project 

     select PM_UTILS.get_prj_stakeholder_name_list(<project ID>) from dual
Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
eata
Regular Collector

Re: which table stores stakeholder information

I think, I mis explained.

My aim is to gather the time a user selected as stakeholder.

Not who is the stakeholder of the project.

I want to find when some one added.

Thanks

Ted Power
Occasional Contributor

Re: which table stores stakeholder information

select us.user_id
                         from knta_user_security us,
                              itg_trustee t,
                              itg_security_group_trustees sgt,
                              pm_projects p
                        where p.project_id = p_project_id
                          and t.project_type_id = p.project_type_id
                          and t.trustee_type_code = 1
                          and sgt.trustee_id = t.trustee_id
                          and us.security_group_id = sgt.security_group_id

eata
Regular Collector

Re: which table stores stakeholder information

Hi;

select us.user_id
                         from knta_user_security us,
                              itg_trustee t,
                              itg_security_group_trustees sgt,
                              pm_projects p
                        where p.project_id = MY PROJECT ID

                          and t.project_type_id = MY PROJECT TYPE ID

                          and t.trustee_type_code = 1
                          and sgt.trustee_id = t.trustee_id
                          and us.security_group_id = sgt.security_group_id

  

returned no result but there are stake holders on this project

eata
Regular Collector

Re: which table stores stakeholder information

Hello;

I revised PM_UTILS.get_prj_stakeholders query as it is.

 

select distinct gpu.*,t.*
       from ppmasya_usr.itg_trustee t,
            ppmasya_usr.itg_group_participant_users gpu,
            ppmasya_usr.pm_projects p
      where p.project_id = 41528
        and t.project_type_id = p.project_type_id
        and t.trustee_type_code = 1
        and gpu.trustee_id = t.trustee_id

 

Does this creation date on the table indicates the time the stake holder added?

I dont have admin access so I could not create a new case :( any idea?

//Add this to "OnDomLoad" event