Table in Project Databse

M

MAT

Hi..
As you know if a Ressource writes its actual work in the timesheettable in
web access, the workhours become red. They stay red untill they are approved
by the PM.
I want to ask: in which table do I find this data, whether the actual work
of the ressource is accepted?
in the Table "MSP_WEB_TRANSACTIONS" I find the last date of the
actualisation. But that does not help me. I need to find for which part
(days) of the task there is a request of actualisation or in which days the
ressource has saved his work (red).
thanks..
 
G

Gary L. Chefetz [MVP]

MAT:

The way it goes is that they're red until they're sent to the PM, and blue
once they're sent to the PM but not updated into the plan. They turn black
after the PM accepts them. You want to grab a copy of svrdb.htm from the
help directory on your server to help answer your question. This is the data
dictionary for the web tables. You'll want to pay attention to the
MSP_WEB_TRANSACTIONS table as well as the source data tables. Hope that gets
you started. You may also consider asking followup developer questions at
microsoft.public.project.developer. Thansk.
 
Top