Super Contributor.. JodieOndrejka Super Contributor..
Super Contributor..
360 views

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

Jump to solution

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

0 Likes
1 Solution

Accepted Solutions
Super Contributor.. JodieOndrejka Super Contributor..
Super Contributor..

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

Jump to solution

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

0 Likes
1 Reply
Super Contributor.. JodieOndrejka Super Contributor..
Super Contributor..

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

Jump to solution

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.