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

removing staffing positions via script?

Erik Cole
Honored Contributor

removing staffing positions via script?

We have a lot of staffing profiles that were created from templates. As such, they all have the same 14 positions but many of the positions are no longer required and never had any forecast. I have a requirement to "administratively" remove all positions without a forecast, as they still show up in the Analyze Resource Pools portlet & data sets. Deleting these rows from RSC_POSITIONS is easy, but then you also need to update the remaining values for STAFFING_PROFILE_SEQ for each staffing profile so there are no gaps in the numbers and this has me stumped.


Does anyone have a solution for this, or a better way to accomplish it?

Frequent Visitor

Re: removing staffing positions via script?

I think the best way would be to go the staffing profiles individually and then click on the position link to be deleted....choose "Delete Position" in the pop-up shown next.

This is the ideal way if you are not sure what all tables to update when deleting a forecasted position.




//Add this to "OnDomLoad" event