Resource Wise, Time Phased, Baseline Work

[Rishi Sharma]

Hi All,

I want the time-phased, task-wise baseline work for a
resource.

I am not able to get the exact Baseline Work. I am not
able to tally the result (Baseline Work) with the project
plan, which i get from the following query:

-------------------------------------------------

SELECT MSP_WEB_ASSIGNMENTS.WRES_ID, res_euid, Task_id,
Task_name,
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeBaselineWork
/60000 As Base_Work,

dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeStart,
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeFinish
FROM dbo.MSP_WEB_ASSIGNMENTS INNER JOIN
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY ON
dbo.MSP_WEB_ASSIGNMENTS.WPROJ_ID =
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID AND
dbo.MSP_WEB_ASSIGNMENTS.ASSN_UID =
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentUniqueID
INNER JOIN
dbo.MSP_WEB_RESOURCES ON
dbo.MSP_WEB_ASSIGNMENTS.WRES_ID =
dbo.MSP_WEB_RESOURCES.WRES_ID

-------------------------------------------------

If anybody can help me out....

Can anybody tell me if there is any other table which i
need to use in the above query?

Thanks in advance
Rishi