Actual works for the period - timephased

[Maurício Kobren]

Does anybody kown how can I get the actual works for the period from MSP_
tables for each day for pending tasks submitted by the resources (the tasks
had not been approved by the project managers)?

I want to use a SELECT in the database.

Tks,

Maurício Kobren

 

[Gaurav Wason]

You have to use msp_web_work table.

Refer to this article by Microsoft
http://msdn2.microsoft.com/en-us/library/aa208968(office.11).aspx

 

[Maurício Kobren]

Thank you Gaurav for your answer.
I created this SELECT that returns the data I need:
SELECT
a.WPROJ_ID,
r.WRES_ID,
r.RES_NAME,
a.TASK_NAME,
(w.WWORK_VALUE/480000) AS 'HDs Real',
Convert(Varchar,Convert(DateTime,w.WWORK_START,121),103) AS 'Inicio',
Convert(Varchar,Convert(DateTime,w.WWORK_FINISH,121),103) AS 'Fim'

FROM
MSP_WEB_ASSIGNMENTS a,
MSP_WEB_RESOURCES r,
MSP_WEB_WORK w

WHERE
r.WRES_ID = w.WRES_ID AND
a.WASSN_ID = w.WASSN_ID AND
a.WRES_ID = r.WRES_ID AND
((w.WWORK_START Between '2007-05-28 00:00:00' And '2007-06-01 00:00:00') AND
(w.WWORK_APPROVAL_STATUS=1) AND
(w.WWORK_UPDATE_STATUS=1))

ORDER BY
Convert(Varchar,Convert(DateTime,w.WWORK_START,121),103)

Att,

Maurício.