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

Work Plan Status

SOLVED
Go to solution
Highlighted
Jamie Pick
Regular Collector

Work Plan Status

The wp_task_info table has a column called "status" with values like "3", "4", "5", etc. I'm trying to figure out all of the available Work Plan status code values, by looking at the linked tasks (and task info) tables, using the previously mentioned "status" field.

knta_lookups appears to have these status values - they have a lookup_type of "PM - Task Statuses". The only problem is, the lookup_code values do not match the wp_task_info status values. For example, Active is a "5" in wp_task_info, but a "101" in knta_lookups.

Does anytone have any insight into this seemingly simple, yet perplexing problem?

Thanks!

Jamie
2 REPLIES
Erik Cole
Honored Contributor
Solution

Re: Work Plan Status

I think you want to match up the STATE_ID:

select * from KDRV_STATES
Jamie Pick
Regular Collector

Re: Work Plan Status

Thanks!!! I knew someone would know this and I was getting dizzy searching for it.

Thanks again,

Jamie
//Add this to "OnDomLoad" event