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

Table containing the resources related to tasks

Highlighted
Gaurav Mittal
Occasional Contributor

Table containing the resources related to tasks

Hi Guys,

We are caught in one bizarre problem. The problem is we need to find the table in which resources allocated to tasks are saved.
As you guys know, for every project project, there are certain tasks. Project Managers used to allocate resources to these tasks. Now these resources are going to be saved somewhere in database corresponding to these tasks. That table should be a standard PPM table. But we are not able to find that table till now.
If anyone of you guys, know the table name, please help us on this urgently. Your help is highly appreciated.

Regards,
Amit Trika
3 REPLIES
Mahen M
Honored Contributor

Re: Table containing the resources related to tasks

Hi,
the table name is WP_WORK_UNITS.


select * from prodpitg.WP_WORK_UNITS where task_id= 1363167

Please let me know if you have any questions.

Regards,
Mahendran M
Mahen M
Honored Contributor

Re: Table containing the resources related to tasks

If the Resource ID is Blank, it means it belongs to 'Unassigned Effort'. It gives you all the details in Task Details -> Resource Section.

Regards,
Mahendran M
Gaurav Mittal
Occasional Contributor

Re: Table containing the resources related to tasks

Hi Mahendran,

Thanks alot for your help. We have found the right table and it is the same as suggested by you.

Thanks again.

Regards,
Amit Trika
//Add this to "OnDomLoad" event