Project and Portfolio Management Practitioners Forum
cancel

Work Plan Status

SOLVED
Go to solution
Highlighted
Jamie Pick
Super Contributor.

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
Acclaimed Contributor.
Solution

Re: Work Plan Status

I think you want to match up the STATE_ID:

select * from KDRV_STATES
Jamie Pick
Super Contributor.

Re: Work Plan Status

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

Thanks again,

Jamie