How you access the status of a task in the SQL Tables

P

paulk

I want to be able to access in SQL a task which has had
time captured in PWA , whether it has been sent to the
project manager or not for a approval.. I want to access
the information from one of the SQL Tables but i cannot
find it any where ? ive looked in the MSP_WEB_WORK and
MSP_WEB_WORK_APPROVAL Tables but cannot find any field
that is updated..
thanks
 
G

Gary L. Chefetz [MVP]

Paul:

Your question is too vague to give you much specific guidance, but a couple
things to get you pointed in the right direction:

1) Find the svrdb.htm file on your server or installation CD. This is a data
dictionary for the web tables.

2) Find the projdb.htm file on your workstation or installation CD. This is
a data dictionary for the project tables.

3) Keep in mind that Tasks are pushed to assignment records when published
to resources. Remember that there's an optional many-to-one relationship
between assignments and tasks. Resources update assignments which get rolled
up into task records when accepted into the plan.

When you've got more specific questions on tables/fields/joins etc. post
them at microsoft.public.project.developer.
 
Top