Project and Portfolio Management Practitioners Forum
cancel

Where can we find the individual task statuses and Summary tasks statuses

Highlighted
Shravan Kathuri
Honored Contributor.

Where can we find the individual task statuses and Summary tasks statuses

Hi,
We are using PPM 7.5.

Can anyone know what is the table to get the individual task statuses and summary task statuses. I am assuming kdrv_states. Whether this table is applicable for all tasks or not.

Thanks
Shravan.
3 REPLIES
Semenov Alexand
Acclaimed Contributor.

Re: Where can we find the individual task statuses and Summary tasks statuses

Hi.
Run this and recive all statuses for all task levels
---------
select
ta.outline_level,tst.state_name

FROM

itguser.WP_TASKS ta,
itguser.WP_TASK_INFO ti,
itguser.KDRV_STATES tst
where
ta.task_info_id=ti.task_info_id
and ti.status = tst.state_id
group by

ta.outline_level,tst.state_name
--------

Good Luck
Shravan Kathuri
Honored Contributor.

Re: Where can we find the individual task statuses and Summary tasks statuses

Hi Semenov Alexander,

Thanks for your response.

Can we use kdrv_states table for all the out line levels, i mean even for summmary task and normal tasks. Right now, i am reffering one of the validation "PM - Task Statuses" .Can we use this validation instead of kdrv_states table.

Thanks
Shravan.
Semenov Alexand
Acclaimed Contributor.

Re: Where can we find the individual task statuses and Summary tasks statuses

Hi.

Yes we can use kdrv_states for summmary task and normal tasks, About PM - Task Statuses do't know. May be this validation use select from this table.