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

Staffing profile name to be matched with project name once the project name changes..

SOLVED
Go to solution
Highlighted
Rash
Regular Collector

Staffing profile name to be matched with project name once the project name changes..

Hi Friends,

 

We have a requirement that is:  

if someone changes a Project Name is it possible for the system to automatically change the name of the Staffing Profile Name and the Financial Summary name?
At the moment  if we change a Project Name, the Staffing Profile and the Financial Summary will still show the old name
 
Can some one please help on this query?
Thanks,
Rajesh
5 REPLIES
Utkarsh_Mishra
Honored Contributor
Solution

Re: Staffing profile name to be matched with project name once the project name changes..

Update

 

STAFFING_PROFILE_NAME column in RSC_STAFFING_PROFILES  table and

NAME column in FM_FINANCIAL_SUMMARY table.

Cheers..
Utkarsh Mishra

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

Re: Staffing profile name to be matched with project name once the project name changes..

Thanks Utkarsh. We found these options, but wanted to check if there is anything avilable by default on setting changes on these profiles.

Utkarsh_Mishra
Honored Contributor

Re: Staffing profile name to be matched with project name once the project name changes..

Apart from DB update there is no other option HP has provided to change these names automatically. Yes you can manually go and update these!!!

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Derek Giedd
Frequent Visitor

Re: Staffing profile name to be matched with project name once the project name changes..

You could create a report that runs on a set schedule.  The report would execute the SQL to update the tables that Utkarsh identified.  It would not be instant, but if you needed it updated quickly, you could just start the report.

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

Re: Staffing profile name to be matched with project name once the project name changes..

Thanks  Utkarsh and

//Add this to "OnDomLoad" event