Project and Portfolio Management Practitioners Forum
cancel

PM_PROJECTS STATUS Field - Where can I find what the values mean?

SOLVED
Go to solution
Highlighted
JodieOndrejka
Super Contributor.

PM_PROJECTS STATUS Field - Where can I find what the values mean?

The PPM internal STATUS field that is listed in PM_PROJECTS table, where can I find what the values in this field mean?  For example, I know that 8 stands for 'ON_HOLD'.  I need to get a list of what the valid values are for the internal STATUS field so when I take a project off hold I can set the STATUS field to the correct value using the "ksc_update_project_status STATUS=" special command.

 

I cannot find any reference to another table in the data model. :(

 

Thank you

1 REPLY
JodieOndrejka
Super Contributor.
Solution

Re: PM_PROJECTS STATUS Field - Where can I find what the values mean?

Finally got a response back from HP SW Support.  Here is the info they provided:

 

Project status codes are defined in java code as following:

 

    public static final int STATUS_IN_PLANNING = 0;

 

    public static final int STATUS_IN_FLIGHT = 1;

 

    public static final int STATUS_COMPLETE = 2;

 

    public static final int STATUS_CANCELLED = 3;

 

    public static final int STATUS_ON_HOLD = 8;

 

The meaning defined in ProjectResource.properties as following:

 

projectStatus.inFlight=In Flight

projectStatus.inPlanning=In Planning

projectStatus.complete=Complete

projectStatus.cancelled=Cancelled

projectStatus.onHold=On Hold